Home > database >  Navicat error: 1064 - You have an error in your SQL syntax; Check the manual..
Navicat error: 1064 - You have an error in your SQL syntax; Check the manual..

Time:09-21

Navicat 15.0.11 Mariadb error: 1064 - You have an error in your SQL syntax; Check the manual that corresponds to MariaDB server version for the right syntax to use near 'insert into reg (loginname, name, password) values (' Tom', 'Tom', 'Tom') 'at line 2, Time: 0.000000 s



Statement:
Select * from reg
Insert into reg (loginname, name, password) values (' Tom ', 'Tom', 'Tom')

The official document query: https://mariadb.com/kb/en/mariadb-error-codes/#shared-mariadbmysql-error-codes

Change:
Select * from reg;
Insert into reg (loginname, ` name `, ` password `) values (' Tom ', 'Tom', 'Tom');


Problem solving!

  • Related