mysql,介绍

create table class( id int primary key auto_increment, sname varchar(10) not null default '', gender char(1) not null default '', company varchar(20) not null default '', salary decimal(6,2) not null default 0.00, fanbu smallint not null default 0 )engine myisam charset utf8;

往哪张表 添加行 class

添哪几列 (id,sname,gender,company,salary,fanbu)

分别添加什么值(1,'张三','男','百度',8888.67,234)

insert into class (id,sname,gender,company,salary,fanbu) values (1,'张三','男','百度',8888.67,234);

insert into class (sname,company,salary) values ('刘备','皇室成员',15.28), ('孙策','江东集团',56.34), ('曹操','宦官后裔',88.56);