MySQL 基本知识点

创建表：

CREATE TABLE `table` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(32) NOT NULL DEFAULT '' COMMENT '用户名',
  `password` varchar(64) NOT NULL DEFAULT '' COMMENT '密码',
  `email` varchar(64) NOT NULL DEFAULT '' COMMENT '邮箱',
  `tel` varchar(11) NOT NULL DEFAULT '' COMMENT '联系电话',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

插入数据：

INSERT INTO `table` (`id`, `username`) VALUES (NULL, 'username');

INSERT INTO `table` VALUES (NULL, 'username', 'password', '163@163.com', '12345678910', '1501234567', 0);

INSERT INTO `table` VALUES 
(NULL, 'username', 'password', '163@163.com', '12345678910', '1501234567', 0),
(NULL, 'username', 'password', '163@163.com', '12345678910', '1501234567', 0),
...
(NULL, 'username', 'password', '163@163.com', '12345678910', '1501234567', 0);

 修改数据：

UPDATE `table` SET `username` = 'admin' WHERE id = 1;

查询数据：

SELECT * FROM `table` WHERE id = 1;

删除数据：

DELETE FROM `table` WHERE id = 1;

添加字段：

ALTER TABLE `table` ADD `realname` varchar(64) NOT NULL DEFAULT '' COMMENT '真实姓名';

 修改字段：

ALTER TABLE `table` MODIFY `status` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '状态';