MySQL的基础用法（增删查改）

# MySQL创建数据库
create database 数据库名;
# 删除数据库
drop database 数据库名;
# 选择数据库
use 数据库名;


# MySQL创建数据表：表名、表字段名、定义每个表字段
create table table_name (column_name column_type);
'''
CREATE TABLE runoob_tbl(
    runoob_id INT NOT NULL AUTO_INCREMENT,
    runoob_title VARCHAR(100) NOT NULL,
    runoob_author VARCHAR(40) NOT NULL,
    submission_date DATE,
    PRIMARY KEY ( runoob_id )
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
'''
# 删除数据表
drop table table_name;
# 使用数据表
use table_name
# 插入数据
insert into table_name (field1, f2, ...fn) values (value1, v2, ...vn);
'''
INSERT INTO runoob_tbl 
    (runoob_title, runoob_author, submission_date)
    VALUES
    ("学习 PHP", "菜鸟教程", NOW());
'''
# 查询数据
SELECT field1, field2,...fieldN FROM table_name1, table_name2...
[WHERE condition1 [AND [OR]] condition2.....
'''
 SELECT * from runoob_tbl WHERE runoob_author='菜鸟教程';
'''
 # 更新数据
UPDATE table_name SET field1=new-value1, field2=new-value2 [WHERE Clause]
'''
UPDATE runoob_tbl SET runoob_title='学习 C++' WHERE runoob_id=3;
'''
# 删除数据
DELETE FROM table_name [WHERE Clause]
'''
DELETE FROM runoob_tbl WHERE runoob_id=3;
'''
# 排序
SELECT fieldN FROM table_nameN ORDER BY field1 [ASC|DESC],...fieldN[ASC|DeSC]
'''
SELECT * from runoob_tbl ORDER BY submission_date ASC;
'''
# 正则表达式 REGEXP
'''
SELECT name FROM person_tbl WHERE name REGEXP 'ok$';
'''