便签
- | |
---|---|
where语句 | runoob |
WHERE
文本字段推荐使用单引号;数值字段不要使用引号
1SELECT * from table_name WHERE condition; 2SELECT column1, column2 from table_name WHERE column1='str_value'; 3SELECT column1, column2 from table_name WHERE column1=int_value;
- | |
---|---|
where语句 | runoob |
文本字段推荐使用单引号;数值字段不要使用引号
1SELECT * from table_name WHERE condition; 2SELECT column1, column2 from table_name WHERE column1='str_value'; 3SELECT column1, column2 from table_name WHERE column1=int_value;