sql 学习语句（SQL learning statement）.docVIP

sql 学习语句（SQL learning statement） SQL, DML, and DDL SQL can be divided into two parts: the data manipulation language (DML) and the data definition language (DDL). SQL (Structured Query Language) is the syntax used to execute queries. But the SQL language also contains the syntax for updating, inserting, and deleting records. The query and update directives form the DML part of the SQL: SELECT - get data from the database table UPDATE - update the data in the database table DELETE - deletes data from the database table INSERT INTO - inserts data into the database table The SQL data definition language (DDL) section enables us to create or delete tables. We can also define indexes (keys), specify links between tables, and impose constraints between tables. The most important DDL statement in SQL: CREATE DATABASE - create a new database ALTER DATABASE - modify the database CREATE TABLE - create new tables ALTER TABLE - change (change) database tables DROP TABLE - delete table CREATE INDEX - create index (search key) DROP INDEX - delete index SELECT * FROM table name WHERE column operator value UPDATE table name, SET column name = new value, WHERE column name = a value DELETE FROM table name WHERE column name = value SELECT * FROM, Persons, WHERE, City=Beijing SQL uses single quotes to wrap around text values (most database systems also accept double quotes). If numeric, please dont use quotation marks. SELECT * FROM, Persons, WHERE, Year1965 The ORDER BY statement is used to sort the result set according to the specified column. The ORDER BY statement defaults to sorting the records in ascending order. If you want to sort the records in descending order, you can use the DESC keyword. INSERT, INTO, table_name (column 1, column 2,...) VALUES (value 1, value 2,...) SELECT TOP 50 PERCENT * FROM Persons SELECT * FROM Persons WHERE City LIKEN% SELECT * FROM Persons WHERE, City, NOT, LIKE,%lon% Wildcard description % replaces one or more characters _ only replace a character