SQL 语句

1. 新建表

CREATE TABLE `Table_Name` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `Account` varchar(255) NOT NULL,
  `Password` varchar(255) NOT NULL,
  `CreateTime` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

2. 删除表

DROP TABLE tablename;

3.倒序（由大到小）排列

select * from tablename order by id desc

4. 更新字段信息

update tablename set Export = false where id = 1;
update tablename set count = 3 where id = 1;
update tablename set name= "cat" where id = 1;

5. 删除表中部分数据

delete from tablena