- select * from test;
- id name
- 1 ...
- 2 ...
- 3 ...
- 4 ...
- select * from test order by id desc;
- id name
- 4 ...
- 3 ...
- 2 ...
- 1 ...
- 增加id列
- alter table TABLE_NAME add id int
- create database Mr default character set utf8
- create table TABLE_NAME default charset=utf8
- set names utf8
- --该片段来自于http://www.codesnippet.cn/detail/2910201410816.html
来源: http://www.codesnippet.cn/detail/2910201410816.html