这是我在mysqladmin中bbs数据库下建表grant,想使得read,write,update,delete成为可选选项.本人菜鸟,求大虾给出解决方案。谢谢!
create table grant (
id int(1) not null unique primary key,
read bool,
write bool,
update bool,
delete bool
)#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 'grant ( id int(1) not null unique primary key, read bool, write bool, ' at line 1
create table grant (
id int(1) not null unique primary key,
read bool,
write bool,
update bool,
delete bool
)#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 'grant ( id int(1) not null unique primary key, read bool, write bool, ' at line 1
解决方案 »
- 求助一个SQL显示当前修改过的分数,并且还有原始记录的问题,在线等~~~~~~~~~~~~~
- datetime日期类型如何比较
- SQL SERVER Enterprise Manager,用DTS导出一个表到文本(TXT), 出现乱码,请指教!
- 一个小小的求平均分问题?
- 请教一条查询语句~~~~~~非常急
- mssql2000在windows2003服务器上本机连接(localhost)不上!
- 我怎样得到一个目录下的所有的文件的文件名?
- **********vb.net开发windows应用程序大数据量的问题********
- 怎样把数据库从SQL SERVER6.5 转移到 SQL SERVER2000??
- ADOQuery怎样调用access的查询,是和sql server的储存过程一样吗?
- 将一个表的所有记录复制加到另一个表里?
- 无法启动SqlServer2008的配置管理器
id int(1) not null unique primary key,
`read` bool,
`write` bool,
`update` bool,
`delete` bool
);
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.1.21-communityType 'help;' or '\h' for help. Type '\c' to clear the buffer.mysql> use tempdb
Database changed
mysql> create table `grant` (
-> id int(1) not null unique primary key,
-> `read` bool,
-> `write` bool,
-> `update` bool,
-> `delete` bool
-> );
Query OK, 0 rows affected (0.12 sec)