MySQL学习2：数据表的创建与查询

use 数据库名字;

select database();

show tables;

desc 数据表名字

create table 数据表名字(字段 类型 约束)

insert into 数据表名字 values(每个字段数值);

select * from students;

create table students(
	id int unsigned not null auto_increment primary key,
	name varchar(30),
	age tinyint unsigned default 0,
	high decimal(5,2),
	gender enum(”男","女","保密") default "保密",
	cls_id int unsigned
);

insert into students values(0,"zstar",20,185.55,"男",0);