SQL常用语句
选择操作 SELECT .. FROM .. 最基本的操作,指定选取的表和选取的列 *号表示选取所有列,或者table.*表示选择这个table的所有列 注意如果不加where限定的话得到的是多张表的笛卡尔积 SELECT * FROM myorder, order_detail WHERE myorder.order_id = order_detail.order_id -- SELECT order_detail.*, myorder.order_time FROM myorder, order_detail WHERE myorder.order_id = order_detail.order_id SELECT DISTINCT 用于排除重复的行 SELECT `user`.user_name,`user`.user_status FROM `user` SELECT DISTINCT `user`.user_name,`user`.user_status FROM `user` ORDER BY 用于对结果集进行排序 SELECT `user`.*, myor....