order by
用于对结果集按照一个列或者多个列进行排序。(默认为升序(ASC),降序(DESC)
SELECT column_name1,column_name2 from table_name order by column_name1 ASC|DESC,column_name2 ASC|DESC;
insert into select 和select into from 的区别
insert into scorebak select * from socre where neza=‘neza’ --插入一行,要求表scorebak 必须存在
select * into scorebak from score where neza=‘neza’ --也是插入一行,要求表scorebak 不存在