The Query builder does not support this syntax: near "DATABASE" : syntax error.-CodePudding

CodePudding user response:

SQL syntax errors, stick your SQL out ah,,

CodePudding user response:

Also encounter similar, solving:
The Create table message (
` id ` INT Unsigned not null auto_increment primary key, and - on the primary key
` title ` varchar (120) not null default ', '
` content ` varchar (255) not null default ', '
` created_at ` INT the not null default '0', - create time (time stamp)
Unsigned ` user_name ` varchar (32) not null default ', '
The Key message_user_name (user_name)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;

CodePudding user response:

refer to the second floor Simonaaasss response:

also encounter similar, solving:
The Create table message (
` id ` INT Unsigned not null auto_increment primary key, and - on the primary key
` title ` varchar (120) not null default ', '
` content ` varchar (255) not null default ', '
` created_at ` INT the not null default '0', - create time (time stamp)
Unsigned ` user_name ` varchar (32) not null default ', '
The Key message_user_name (user_name)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;