FAQs about inserting keywords in the mySQL Field

An error is reported when the table tb_system_help2 contains the keyword "order" in the mySQL field. INSERTINTOtb_system_help2 (sysid, sysname, helpid, helpname, parentid, isLeaf, order) VALUES (?,?,?,?,?,?,?)? Solution: INSERTINTOtb_system_help2 (sysid, sysn

An error is reported when the table tb_system_help2 contains the keyword "order" in the mySQL field. Insert into tb_system_help2 (sysid, sysname, helpid, helpname, parentid, isLeaf, order) VALUES (?,?,?,?,?,?,?) ? Solution: insert into tb_system_help2 (sysid, sysn

Keyword insertion in the mySQL Field

An error is reported when the table tb_system_help2 contains the keyword field order.

Insert into tb_system_help2 (sysid, sysname, helpid, helpname, parentid, isLeaf, order) VALUES (?,?,?,?,?,?,?)

? Solution:

Insert into tb_system_help2 (sysid, sysname, helpid, helpname, parentid, isLeaf, 'order') VALUES (?,?,?,?,?,?,?)

?

Changed? 'Order '?, Note that it is next to number key 1.Reverse quotation marks'? (Select the English input method), and? Not '?? Single quotes