MySQL创建数据库并插入数据

开启

sudo service mysql start

进入

sudo mysql -u root

创建数据库

​​CREATE DATABASE mysql_shiyan;​​

​​use mysql_shiyan;​​

添加纪录

​​CREATE TABLE employee (id int(10), name char(20), phone int(12));​​​​CREATE TABLE department (dep_name CHAR(20), dep_phone INT(12));​​

插入

​​INSERT INTO employee(id, name, phone) VALUES(01. 'Tom', 111);​​​​INSERT INTO employee(id, name, phone) VALUES(02. 'Jack', 222);​​​​INSERT INTO employee(id, name) VALUES(03. 'Rose', 333);​​ 或者

INSERT INTO employee(id, name, phone) VALUES
(01. 'Tom', 111)，
(02. 'Jack', 222)；
INSERT INTO employee(id, name) VALUES(03. 'Rose', 333);