MySQL创建数据表 | 开局一条龙

mysql -u root #登录

create database chapcher04; #创建数据库

show databases; #查看数据库

use chapcher04; #使用该数据库

create table sh_goods(
id int(10) unsigned primary key auto_increment, #主键+自动增长
categoryid int(10) unsigned not null default 0, #非空+0
spuid int(10) unsigned not null default 0,
city varchar(20) not null,
name varchar(20) not null,
price int(10) unsigned
);

desc sh_goods; #查看数据表结构

insert into sh_goods values(1,3,5,'GZ','2Bpencil',5); #添加数据
 
insert into sh_goods values(1,3,5,'GZ','2Bpencil',5);
 
insert into sh_goods values(3,3,3,'GZ','box',10);
 
insert into sh_goods values(4,2,7,'SZ','ruler',3);
  
insert into sh_goods values(5,2,8,'SH','computer',10000);

insert into sh_goods values(8,12,7,'ZH','TV',2000);

select * from sh_goods; #查看数据表