本文涵盖内容均源于《PHP&MySQL Novice to Ninja》一书,在此感谢著者“Kevin Yank”[澳]。
MySQL 基础:
- 创建
1.创建库:
CREATA DATABASE db_name
2.创建表:
CREATA TABLE [db_name.]table_name
{
column1_name column1_type column1_details,
column2_name column2_type column2_details,
// etc.
}DEFAULT CHARACTER SET charset ENGINE=storage_engine
3.插入单条:
INSERT INTO FROM table_name SET
column1_name = column1_value,
column2_name = column2_value,
// etc.
- 删除
1.删除库:
DROP DATABASE db_name
2.删除表:
DROP TABLE table_name
3.删除表内列:
ALTER TABLE table_name DROP COLUMN col_name
4.删除单条:
DELETE FROM table_name WHERE conditions
- 修改
1.修改库:暂无
2.修改表:
ALTER TABLE table_name ADD COLUMN
new_col_name new_col_details
3.增加表内列:
ALTER TABLE table_name ADD COLUMN col_name col_details
4.修改单条:
UPDATE table_name SET
col_name = new_value, /* etc. */
WHERE conditions
- 查询
1.查询表结构:
DESCRIBE table_name
2.查询数据1:
SELECT column1_name, column2_name, /* etc. */ FROM table_name
- 在需格式化引号前,加反斜杠(\)进行转义(escape)。 ↩