创建数据库db_ck,再创建表t_hero,将四大名著中的主要人物都插入这个表中,将实现过程中sql提交上上来
1、创建数据库db_ck
mysql> create database db_ck;
2、创建表t_hero
mysql> use db_ck
Database changed
mysql> create table t_hero (
-> id int primary key auto_increment,
-> name varchar(255) not null);
Query OK, 0 rows affected (0.01 sec)
3、插入数据
mysql> insert into t_hero (name )values
-> (“悟空”),
-> (“贾宝玉”),
-> (“赵云”),
-> (“松江”);
Query OK, 4 rows affected (0.00 sec)
4、查看