CREATE TABLE `look` ( `u_id` INT UNSIGNED AUTO_INCREMENT, `u_name` CHAR (10), `u_date` TIMESTAMP (14) NOT NULL, PRIMARY KEY(`u_id`) ) ;insert into look (u_name) values ('ok?');
create table test ( u_id int(10) not null auto_increment, u_name varchar(50) not null, u_date date not null, primary key(u_id) );insert into test (u_name,u_date) values ('ok?',now());
其实就是auto_increment自动排号咯。
CREATE TABLE ebus ( id INT UNSIGNED AUTO_INCREMENT, name CHAR (20), date TIMESTAMP (24) NOT NULL, PRIMARY KEY(`id`) ) ;
(
`u_id` INT UNSIGNED AUTO_INCREMENT,
`u_name` CHAR (10),
`u_date` TIMESTAMP (14) NOT NULL,
PRIMARY KEY(`u_id`)
) ;insert into look (u_name) values ('ok?');
u_id int(10) not null auto_increment,
u_name varchar(50) not null,
u_date date not null,
primary key(u_id)
);insert into test (u_name,u_date) values ('ok?',now());
(
id INT UNSIGNED AUTO_INCREMENT,
name CHAR (20),
date TIMESTAMP (24) NOT NULL,
PRIMARY KEY(`id`)
) ;