mysql 插入%s $d_mysql插入数据报错

IINSERTINTOcmb_tbl(a,b,c,d,e,f,g,h)VALUES(%s,%s,%s,%f,%f,%f,%f,%f)%('up','14.215.116.219','2018-04-0409:54:49',0,31.047,31.634,32.712,0.579);ERROR1064(42000):Youhaveanerr...

IINSERT INTO cmb_tbl (a,b,c,d,e,f,g,h) VALUES (%s, %s, %s, %f, %f, %f, %f, %f) %('up', '14.215.116.219', '2018-04-04 09:54:49',0, 31.047, 31.634, 32.712, 0.579);

ERROR 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 '%s, %s, %s, %f, %f, %f, %f, %f) %('up', '14.215.116.219', '2018-04-04 09:54:49',' at line 1

表字段如下，求大神解答

Field | Type | Null | Key | Default | Extra |

+-----------------+------------------+------+-----+---------------------+----------------+

| id | int(10) unsigned | NO | PRI | NULL | auto_increment |

| a | varchar(4) | NO | PRI | | |

| b | varchar(40) | YES | | NULL | |

| c | datetime | NO | PRI | 0000-00-00 00:00:00 | |

| d | float | NO | PRI | 0 | |

| e | float | YES | | NULL | |

| f | float | YES | | NULL | |

| g | float | YES | | NULL | |

| h | float | YES | | NULL | |

| submission_date | date | YES | | NULL | |

+-----------------+------------------+------+-----+---------------------+----------------+

展开