第3.1章 SQL语言创建数据库

USE itpux

--1、创建一个数据库
CREATE DATABASE itpux

--2、创建用户、刷新权限与分配权限
CREATE USER 'itpux'@'%' IDENTIFIED BY 'itpux';
FLUSH PRIVILEGES;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'itpux'@'%' IDENTIFIED BY 'itpux' WITH GRANT OPTION;

--3、查询系统有哪 些用户
SELECT HOST,USER FROM mysql.user;

--4、创建表和数据插入
CREATE TABLE dept(
deptno INT AUTO_INCREMENT PRIMARY KEY,
dname VARCHAR(15),
loc VARCHAR(50)
)ENGINE=INNOBASE;

INSERT INTO dept(deptno,dname,loc) VALUE(1,'it','bj');
INSERT INTO dept VALUES(2,'cw','sh');
INSERT INTO dept VALUES(3,'hr','sz');
COMMIT;