1

mysql -u root -p

1

create database bookstore;

1

show databases;

1

use test

1
2
3
4
5
6
7

create table user
(
id         int auto_increment not null,
username   varchar(10) not null,
password   varchar(10) not null,
primary    key(id)
);

1

show tables;

1

descirbe tables;

1
2

insert into user values(1,'yu','yu');
insert into user values(2,'zhouhejun','19830925');