mysql教程

（一）数据库操作
1、创建数据库
create database 数据库名;
create database runoob;
2、选择数据库
use 数据库名;
use runoob;
3、删除数据库
drop database 数据库名;
drop database runoob;
（二）数值类型

（三）数据表
1、创建数据表
CREATE TABLE 数据表名 (字段名 字段类型);
CREATE TABLE runoob_tbl(
runoob_id INT UNSIGNED 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;
2、删除数据表
DROP TABLE 数据表名 ;
DROP TABLE runoob_tbl ;
（四）数据操作
1、增
INSERT INTO table_name ( field1, field2,…fieldN )
VALUES
( value1, value2,…valueN );

INSERT INTO runoob_tbl (runoob_title, runoob_author, submission_date)
VALUES
(“学习 PHP”, “菜鸟教程”, NOW());
2、删
DELETE FROM table_name [WHERE Clause];
DELETE FROM runoob_tbl WHERE runoob_id=1;
3、改
UPDATE table_name SET field1=new-value1, field2=new-value2
[WHERE Clause];
UPDATE runoob_tbl SET runoob_title=‘学习 C++’ WHERE runoob_id=1;
4、查
SELECT field1, field2,…fieldN FROM table_name1, table_name2…
[WHERE condition1 [AND [OR]] condition2…
SELECT * from runoob_tbl WHERE runoob_author=‘菜鸟教程’;