MSYQL数据操作语言（DML)Linux认证考试

文章作者 100test 发表时间 2010:04:28 20:41:10
来源 100Test.Com百考试题网

　　一、0select语法

　　SELECT

　　[ALL | DISTINCT | DISTINCTROW ]

　　[HIGH_PRIORITY]

　　[STRAIGHT_JOIN]

　　[SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT]

　　[SQL_CACHE | SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS]

　　0select_expr [, 0select_expr ...]

　　[FROM table_references

　　[WHERE where_condition]

　　[GROUP BY {col_name | expr | position}

　　[ASC | DESC], ... [WITH ROLLUP]]

　　[HAVING where_condition]

　　[ORDER BY {col_name | expr | position}

　　[ASC | DESC], ...]

　　[LIMIT {[offset,] row_count | row_count OFFSET offset}]

　　[PROCEDURE procedure_name(argument_list)]

　　[INTO OUTFILE file_name

　　[CHARACTER SET charset_name]

　　export_options

　　| INTO DUMPFILE file_name

　　| INTO var_name [, var_name]]

　　[FOR UPDATE | LOCK IN SHARE MODE]]