MYSQL语句集合笔记

SHOW DATABASES;
SELECT DATABASE();
CREATE DATABASE 陌上;
USE 陌上;
CREATE DATABASE IF NOT EXISTS 陌上;
DROP DATABASE 陌上;
DROP DATABASE IF EXISTS 陌上;
SHOW TABLES;
CREATE TABLE day1(
	id INT COMMENT '编号',
	NAME VARCHAR(50) COMMENT '姓名',
	age INT COMMENT '年龄',
	gender VARCHAR(1) COMMENT '性别'
	) COMMENT '用户表';
DESC day1;
SHOW CREATE TABLE day1;

CREATE TABLE day2(
	id INT,
	workno VARCHAR(10),
	NAME VARCHAR(10),
	gender CHAR(1),
	age TINYINT UNSIGNED,
	idcard CHAR(18),
	ertrydate DATE
	) COMMENT '员工表';
SHOW CREATE TABLE day2;
DESC day2;
ALTER TABLE day2 ADD nickname VARCHAR(20); 
ALTER TABLE day2 MODIFY username VARCHAR(20);
ALTER TABLE day2 CHANGE nickname username VARCHAR(20);
ALTER TABLE day2 DROP username;
ALTER TABLE day3 RENAME TO day2;
DROP TABLE IF EXISTS day2;
TRUNCATE TABLE day2;
INSERT INTO day2(
	id,workno,NAME,gender,age,idcard,ertrydate) VALUES (1,'1','陌上','男',18,'610324200406261014','2004-06-26'
	);
SELECT*FROM day2;
INSERT INTO day2 VALUES(
	2,'2','人途','男',18,'610324200406261017','2004-05-21'
	);
INSERT INTO day2 VALUES(
	3,'3','帅奔','男',18,'610324200406372382','2003-12-05'
	),(
	4,'4','酷震','男',18,'610324200443354545','2004-11-08'
	);
UPDATE day2 SET NAME='吊彤' WHERE id=1;
DELETE FROM day2 WHERE id=2;
SELECT NAME,gender,age FROM day2;
SELECT NAME AS ' 姓名' FROM day2;
SELECT*FROM day2;
SELECT DISTINCT id FROM day2;
SELECT*FROM day2 WHERE id=1;
SELECT COUNT(*) FROM day2;
SELECT COUNT(id) FROM day2;
SELECT MIN(id) FROM day2 WHERE age=18;