官术网_书友最值得收藏!

WHERE clause

The following code block has the general syntax for the select query with the WHERE clause:

SELECT FIELD1, FIELD2, FIELD3,...FIELDn from TABLE_NAME1 ,TABLE_NAME2 [WHERE condition1 [AND [OR]] condition2...

The WHERE clause is an optional part of the SELECT command. You can use AND or OR to specify conditions. The WHERE clause can also be used with DELETE and UPDATE query, which we will discuss soon in this chapter.

Here is the list of operators used with the where clause for conditions. Let's take an example of a table schema to understand these operations. Let's create a table called users with schema mentioned here having id, first_name, last_name, address, city, state, zip, login_attempts, contact_number, email, username, and password:

CREATE TABLE `users` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`first_name` varchar(255),
`last_name` varchar(255),
`address` varchar(255),
`city` varchar(50),
`state` varchar(2),
`zip` varchar(10),
`login_attempts` int(10),
`contact_number` varchar(20),
`email` varchar(191),
`username` varchar(191),
`password` varchar(255),
PRIMARY KEY (`id`)
) ENGINE=InnoDB PRIMARY KEY (`id`) AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
主站蜘蛛池模板: 商南县| 沙洋县| 盖州市| 邵阳市| 蓝山县| 吉木乃县| 皮山县| 嘉黎县| 来宾市| 同江市| 赣榆县| 会宁县| 朝阳区| 汝城县| 卢湾区| 宽城| 息烽县| 甘肃省| 南投市| 汶川县| 武强县| 甘泉县| 浠水县| 竹山县| 墨脱县| 合阳县| 集贤县| 宜丰县| 拉孜县| 肥东县| 应城市| 宁陕县| 潜江市| 波密县| 资兴市| 鄢陵县| 从化市| 名山县| 海丰县| 汉寿县| 奉节县|