SELECT和WHERE子句中的函數

基本型

Select 欄位名稱 from 表格名稱;

欄位名稱：可以一個，亦可以多個，多個時，以逗號(,)隔開即可。當你選擇的一個表格中的所有欄位，可以用＊號代替。

例如：

select custid,name from customer;

條件型

select custid,name from customer　
where custid > 1000

select * from usertb
where username = "hlf"

select * from usertb
where username like "hlf"

進階型

select student.student_name from student,course
where student.student_id=course.student_id;

SELECT完整型
SELECT [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [HIGH_PRIORITY]

       [DISTINCT | DISTINCTROW | ALL]
    select_expression,...
    [INTO {OUTFILE | DUMPFILE} 'file_name' export_options]
    [FROM table_references
        [WHERE where_definition]
        [GROUP BY col_name,...]
        [HAVING where_definition]
        [ORDER BY {unsigned_integer | col_name | formula} [ASC | DESC] ,...]
        [LIMIT [offset,] rows]
        [PROCEDURE procedure_name] ]

SELECT被用來檢索從一個或多個表中精選的行。select_expression指出你想要檢索的列。SELECT也可以用來檢索不引用任何表的計算行。