CREATE TABLE animals (
grp ENUM('fish','mammal','bird') NOT NULL,
id MEDIUMINT NOT NULL AUTO_INCREMENT,
name CHAR(30) NOT NULL,
PRIMARY KEY (grp,id)
) ENGINE=MyISAM;
INSERT INTO animals (grp,name) VALUES
('mammal','dog'),('mammal','cat'),
('bird','penguin'),('fish','lax'),('mammal','whale'),
('bird','ostrich');
INSERT INTO animals (grp,name) VALUES
('mammal','dog'),('mammal','cat'),
('bird','penguin'),('fish','lax'),('mammal','whale'),
('bird','ostrich');
INSERT INTO animals (grp,name) VALUES
('mammal','dog'),('mammal','cat'),
('bird','penguin'),('fish','lax'),('mammal','whale'),
('bird','ostrich');
create table tb(id int(5) unsigned not null auto_increment,
name varchar(60) not null,
primary key(id)
)
default char set=utf8
engine=InnoDB;
insert into tb values(null,"afd");
insert into tb values(null,"afdsa");
insert into tb values(null,"afdsa");
insert into tb values(null,"afdsa");
select * from tb;
delete from tb where id<3;
insert into tb values(null,"afdsa");
insert into tb values(null,"afdsa");
delete from tb;
insert into tb values(null,"afdsa");
类似这种情况这个最后插入数据的ID怎么获得?请继续帮忙把sql语句写出来