We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
CREATE TABLE `app_icon` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID', `icon_name` varchar(64) NOT NULL DEFAULT '' COMMENT '名称', `file_name` varchar(20) NOT NULL DEFAULT '' COMMENT '文件名称', `introduce` varchar(64) NOT NULL DEFAULT '' COMMENT '介绍文案', `get_desc` varchar(64) NOT NULL DEFAULT '' COMMENT '获取方式', `app_version` varchar(64) NOT NULL DEFAULT '' COMMENT '已预埋版本号', `zip_file` text COMMENT 'app图标zip文件url', PRIMARY KEY (`id`) /*T![clustered_index] CLUSTERED */, UNIQUE KEY `uniq_file_name` (`file_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='app'
如上表,会提示警告如下:
Column 'zip_file' in table 'app_icon' is not allowed to been nullable.
text/blob 可以不需要设置not null,如果设置not null就警告(这个已经有了),设置default 报异常
The text was updated successfully, but these errors were encountered:
No branches or pull requests
如上表,会提示警告如下:
text/blob 可以不需要设置not null,如果设置not null就警告(这个已经有了),设置default 报异常
The text was updated successfully, but these errors were encountered: