目錄

1.創(chuàng)建數(shù)據(jù)庫和表

2.插入數(shù)據(jù)

創(chuàng)建一個數(shù)據(jù)庫，在數(shù)據(jù)庫種創(chuàng)建一張叫heros的表，在表中插入幾個四大名著的角色：

1.創(chuàng)建數(shù)據(jù)庫和表

#創(chuàng)建表
CREATE DATABASE db_test;#查看創(chuàng)建的數(shù)據(jù)庫
show databases;

#使用db_test數(shù)據(jù)庫
USE db_test;#查看當前所在的數(shù)據(jù)庫
select database();

#創(chuàng)建heros表
create table heros(id int,name varchar(50),gender char(5),novel varchar(50)
);#顯示數(shù)據(jù)庫中的表
show tables;#查看表的詳細信息
desc heros;

2.插入數(shù)據(jù)

#逐條插入數(shù)據(jù)
insert into heros values(1,"孫悟空","男","《西游記》");
insert into heros values(2,"諸葛亮","男","《三國演義》");
insert into heros values(3,"林沖","男","《水滸傳》");
insert into heros values(4,"林黛玉","女","《紅樓夢》");#查看heros表中的數(shù)據(jù)
select * from heros;