WHERE子句用于提取那些满足指定标准的记录。
语法:
SELECT column_name, column_name FROM table_name WHERE column_name operator value;
示例:
SELECT * FROM Websites WHERE country=’CN’;
SELECT * FROM Websites WHERE id=1;
SQL使用单引号来环绕文本值
WHERE子句用于提取那些满足指定标准的记录。
语法:
SELECT column_name, column_name FROM table_name WHERE column_name operator value;
示例:
SELECT * FROM Websites WHERE country=’CN’;
SELECT * FROM Websites WHERE id=1;
SQL使用单引号来环绕文本值