A table must have at least 1 column
程序员文章站
2022-07-15 13:02:09
...
用MySQL创建table时报错
use bbs2;
create table article{
id int primary key auto_increment,
pid int,
rootid int,
title varchar(255),
cont text,
pdate datetime,
isleaf int
};
insert into article values (null, 0, 1, '你好', '你好', now(), 1);
报错:A table must have at least 1 column
解决办法:create table article(int , text)。应该是(),而不是{};
推荐阅读
-
MySQL 脚本报错:Every derived table must have its own alias 每个派生表必须有自己的别名
-
A table must have at least 1 column
-
Mysql错误Every derived table must have its own alias解决方法
-
beego 使用连接mysql 报错 register db Ping `default1`, Error 1049: Unknown database 'test_beego' must have one register DataBase alias named `default
-
mysql-MySQL错误Every derived table must have its own alias
-
mysql-MySQL错误Every derived table must have its own alias
-
MySQL碰到“Every derived table must have its own alias”类似错误说明
-
【mysql解决方案】ERROR 1248 (42000): Every derived table must have its own alias
-
mysql原生SQL查询错误出现异常“ Every derived table must have
-
mysql原生SQL查询错误出现异常“ Every derived table must have