创建数据库表时发生错误: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 8
源码:
# 创建配水间的表 create_peishuijian_sql = f""" CREATE TABLE parameter_peishuijian ( id INT AUTO_INCREMENT PRIMARY KEY, elavation float, pressure float, flow float, gross_head float, -- 添加更多列... ) """
解决方法:去掉gross_head float 后面的逗号
改正后的代码:
# 创建配水间的表 create_peishuijian_sql = f""" CREATE TABLE parameter_peishuijian ( id INT AUTO_INCREMENT PRIMARY KEY, elavation float, pressure float, flow float, gross_head float -- 添加更多列... ) """