问题遇到的现象和发生背景
执行这个语句时,cursor.execute('insert into j1 (id,name,sex) values (s%,s%,s%)',['001','张三','男'])
出现这样提示,Not all parameters were used in the SQL statement
出现这样提示,Not all parameters were used in the SQL statement
百分号应该在s前边吧cursor.execute('insert into j1 (id,name,sex) values (%s,%s,%s)',('001','张三','男'))