mysqlisql

mysql insert error with column name is "key"

my table header is follow:
id:name:key:value

when insert something using below sql syntax shows error:
insert table( name, key, value) value ("jack","mobile","18561436678")

Solution

  • Do it like this:

     insert table( `name`, `key`, `value`) value ("jack","mobile","18561436678");