MySQL 常用查询语句

清空表数据

truncate table;

复制表数据

INSERT INTO `table1` SELECT * FROM `table2`

获得数据中最大的id

select id from products order by id desc limit 1

202 total views, 2 views today

Revisions

There are no revisions for this post.

No comments yet.

发表评论