今天通过python程序给数据库的表格插入数据,却提示报错
File "C:\Users\hjl\AppData\Local\Programs\Python\Python38\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.OperationalError: (1136, "Column count doesn't match value count at row 1")
看了看发现是插入数据匹配错误:
原来代码:
sql="insert into table1(name,age,score) values('"+name+","+age+","+score+"')"
把values里面的每一个数据都加上 ' ' 就好了
如:
sql="insert into table1(name,age,score) values('"+name+"','"+age+"','"+score+"')"