MySQLWorkbench正向工程错误1064

我正试图将我的SQL模型转发给我无所事事的Laravel宅基地phpMyAdmin数据库。但是,我得到的错误代码是1064。数据库MySQL版本是5.7.2,Laravel 5.8,MySQLWorkbench版本8.0.12。从MySQLWorkbench自动生成的MySQL脚本怎么了?

消息日志:

Executing SQL script in server
ERROR: Error 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 'UNSIGNED NOT NULL AUTO_INCREMENT,`created_at` DATETIME NOT NULL DEFAULT CURRE' at line 5
SQL Code:
        -- -----------------------------------------------------
        -- Table `mydb`.`asset_types`
        -- -----------------------------------------------------
        CREATE TABLE IF NOT EXISTS `mydb`.`asset_types` (
          `id` INT(11) UNIQUE UNSIGNED NOT NULL AUTO_INCREMENT,`created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,`updated_at` DATETIME NULL,`deleted_at` DATETIME NULL,`name` VARCHAR(255) NOT NULL,`system_name` VARCHAR(255) NOT NULL,PRIMARY KEY (`id`),UNIQUE INDEX `id_UNIQUE` (`id` ASC),UNIQUE INDEX `system_name_UNIQUE` (`system_name` ASC))

SQL script execution finished: statements: 8 succeeded,1 failed

Fetching back view definitions in final form.
Nothing to fetch
qjttn 回答:MySQLWorkbench正向工程错误1064

暂时没有好的解决方案,如果你有好的解决方案,请发邮件至:iooj@foxmail.com
本文链接:https://www.f2er.com/3160195.html

大家都在问