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);