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
