Blog Pages

MySQL - MariaDB - error in your SQL syntax near ';

Error Message:
Error Code: 1064. You have an error in your SQL syntax;
check the manual that corresponds to your MariaDB server version for the right syntax to use near '; INSERT CITY (..... at line 1

The case:
INSERT CITY (CITY_CODE, CITY_DESCRIPTION) VALUES (N'TT1', N'test1');;
INSERT CITY (CITY_CODE, CITY_DESCRIPTION) VALUES (N'TT2', N'test2');


The cause:
The ';' without a statement.

Solution:
;; --> ;

No comments:

Post a Comment