各们高手,小弟第一次使用MySQL,但是在建表的时候不能设置自动增长问题,所以请各们帮忙指点一下,谢谢啦!下面是我的SQL语句,我也不知道是否正确,请大家帮忙:create database Demouse Demo/*用户表*/
create table Demo_user
(
Demo_user_Id int primary key default'1' auto_increment,
Demo_user_Name varchar(30) not null,
Demo_user_Pass varchar(20) not null,
Demo_user_Code varchar(20) not null,
Demo_user_Sex int not null
)
create table Demo_user
(
Demo_user_Id int primary key default'1' auto_increment,
Demo_user_Name varchar(30) not null,
Demo_user_Pass varchar(20) not null,
Demo_user_Code varchar(20) not null,
Demo_user_Sex int not null
)
解决方案 »
- 急mysql定时任务怎么不执行
- 请问这里面这个校验码怎么数据库体现呢
- 请问一个棘手问题?请高手帮忙
- Cannot create PoolableConnectionFactory
- 求救mysql error:the table is full
- MySQL如何指定磁盘储存位置?高手入
- MYSQL的问题
- mysql执行错误use mysql update user Set user='ok',password=password('ok') where user='root'
- trigger 不能用begin...end
- 关于MYSQL内存配置.
- php 初學 關于mysql 的隨機查詢問題。
- 请教一个Mysql 的统计各个月份的总数的语句
改成: Demo_user_Id unsigned int primary key auto_increment,
-----------------------------------
unsigned int 指:该colunm的取值范围:0 ~ 4294967295.
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 int primary key auto_increment,
Demo_user_Name varchar(30) not null,' at line 3
(0 ms taken)这是错误信息!
Demo_user_Id int(11) not null auto_increment
试试?
Demo_user_Id int unsigned primary key auto_increment对不起,把int unsigned 写成 unsigned int. ^ ^
create table Demo_user
(
Demo_user_Id int primary key auto_increment,
Demo_user_Name varchar(30) not null,
Demo_user_Pass varchar(20) not null,
Demo_user_Code varchar(20) not null,
Demo_user_Sex int not null
);
版本:5.0.20a-nt,不知道你数据库是什么版本
insert into type values(0,'BBB')
这样就可以了
(
Demo_user_Id int auto_increment primary key ,
Demo_user_Name varchar(30) not null,
Demo_user_Pass varchar(20) not null,
Demo_user_Code varchar(20) not null,
Demo_user_Sex int not null
)
insert into demo_user(Demo_user_Name,Demo_user_Pass,Demo_user_Code,Demo_user_Sex)
values
('test1','llllllll','llllll',1),
('test2','lllfff','ldddl',2),
('test3','sdfsaflll','lsdfll',1);select * from demo_user;
Demo_user_Id Demo_user_Name Demo_user_Pass Demo_user_Code Demo_user_Sex
1 test1 llllllll llllll 1
2 test2 lllfff ldddl 2
3 test3 sdfsaflll lsdfll 1