Error 1064 - when i import sql db to local server

Avatar
  • Answered
CREATE TABLE `rv_assets` (
`id` int(10) UNSIGNED NOT NULL COMMENT 'Primary Key',
`parent_id` int(11) NOT NULL DEFAULT '0'COMMENT
)

MySQL said: Documentation
#1064 - 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 ')' at line 4
Avatar
Arn
Hello [email protected],

Sorry for the syntax error in your MySQL query. The problem is associated with your second COMMENT. You have no value assigned to it like you do in the first COMMENT. Either remove the comment or give it a value and the error will be resolved.

If you have any further questions or comments, please let us know.

Regards,
Arnel C.