开始学习MySQL。
// 创建数据库 CREATE DATABASE db_name; // 删除数据库 DROP DATABASE db_name; // 显示数据库 SHOW DATABASES; // 选择数据库 USE db_name; // 显示表 SHOW TABLES;
// 创建表 CREATE TABLE customer ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, name varchar(32) NOT NULL DEFAULT '0', PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; // 查看表结构 DESC customer; SHOW CREATE TABLE customer G; SHOW TABLE STATUS LIKE 'customer' G; // 删除表 DROP TABLE customer; // 修改表中某一字段数据类型 ALTER TABLE customer MODIFY COLUMN name varchar(16) NOT NULL DEFAULT '0' AFTER id; // 修改表中某一字段名称 ALTER TABLE customer CHANGE COLUMN name nickname varchar(16) NOT NULL DEFAULT '0' AFTER id; // 添加新字段 ALTER TABLE customer ADD COLUMN last_name varchar(16) NOT NULL DEFAULT '0' AFTER id; // 删除某一字段 ALTER TABLE customer DROP COLUMN nickname;
// 插入数据 INSERT INTO customer(id, first_name, last_name, nickname) VALUES(10000,'Wayne', 'Bruce', 'Batman'); // 部分插入数据 INSERT INTO customer(first_name, last_name) VALUES('Logan', 'Howlett'); // 省略字段名称 INSERT INTO customer VALUES(10002, 'Banner', 'Bruce', 'Hulk'); // 省略字段名称(auto_increament) INSERT INTO customer VALUES(NULL, 'Stark', 'Tony', 'Iron Man');
// 更新记录 UPDATE customer SET nickname = 'Wolverine' WHERE id = 10001; // 删除记录 DELETE FROM customer WHERE nickname LIKE '%Iron%';
customer表如下:
参考资料: