查询：
SELECT * FROM `person`
SELECT * FROM `person` WHERE `id` = 1
SELECT name,age FROM `person` WHERE number = 666333
插入：
INSERT INTO `person` (`id`, `name`, `sex`, `age`, `number`) VALUES (‘1’, ‘小红’, ‘女’, ’18’, ‘333666’), (‘2’, ‘李明’, ‘男’, ’24’, ‘666333’);
INSERT INTO `article` (`id`, `article_id`, `titile`, `content`, `articleLink`, `crawlSign`, `publishSign`) VALUES (NULL, ‘1’, ‘1’, ‘1’, ‘1’, ‘1’, ‘1’), (NULL, ‘1’, ‘1’, ‘1’, ‘1’, ‘1’, ‘1’);
更新：
UPDATE `person` SET `age` = ’33’ WHERE `person`.`id` = 3;
UPDATE `person` SET `name` = ‘李爱华’ WHERE `person`.`number` = 333666
UPDATE `articles` SET `title_en` = ‘1’, `content_en` = ‘1’ WHERE `articles`.`id` = 3998;
删除：
DELETE FROM `person` WHERE `person`.`id` = 4
删除表：
DROP TABLE `test`.`person`
清空表：
TRUNCATE `test`.`person`
建表：
CREATE TABLE `test`.`student` ( `id` INT NOT NULL AUTO_INCREMENT , `name` VARCHAR(6) NOT NULL , `sex` VARCHAR(2) NOT NULL , `age` INT(3) NOT NULL , `number` INT(6) NOT NULL , PRIMARY KEY (`id`)) ENGINE = MyISAM;