目錄

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

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

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

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

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

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

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

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

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