SQL速成手册，yyds（建议收藏！）

ゝ一世哀愁。 2022-09-05 01:41 247阅读 0赞

## SQL 语句 ##

<table> 
 <tbody> 
 <tr> 
 <th> 
 <ul> 
 <li>语句</li> 
 </ul></th> 
 <th> 
 <ul> 
 <li>语法</li> 
 </ul></th> 
 </tr> 
 <tr> 
 <td> AND / OR </td> 
 <td> <pre><code>SELECT column_name(s)
FROM table_name
WHERE condition
AND|OR condition</code></pre> </td> 
 </tr> 
 <tr> 
 <td> ALTER TABLE (add column) </td> 
 <td> <pre><code>ALTER TABLE table_name

ADD column_name datatype
</code></pre> </td> 
 </tr> 
 <tr> 
 <td> ALTER TABLE (drop column) </td> 
 <td> <pre><code>ALTER TABLE table_name
DROP COLUMN column_name</code></pre> </td> 
 </tr> 
 <tr> 
 <td> AS (alias for column) </td> 
 <td> <pre><code>SELECT column_name AS column_alias
FROM table_name</code></pre> </td> 
 </tr> 
 <tr> 
 <td> AS (alias for table) </td> 
 <td> <pre><code>SELECT column_name
FROM table_name&nbsp; AS table_alias</code></pre> </td> 
 </tr> 
 <tr> 
 <td> BETWEEN </td> 
 <td> <pre><code>SELECT column_name(s)
FROM table_name
WHERE column_name
BETWEEN value1 AND value2</code></pre> </td> 
 </tr> 
 <tr> 
 <td> CREATE DATABASE </td> 
 <td> <pre><code>CREATE DATABASE database_name</code></pre> </td> 
 </tr> 
 <tr> 
 <td> CREATE INDEX </td> 
 <td> <pre><code>CREATE INDEX index_name
ON table_name (column_name)</code></pre> </td> 
 </tr> 
 <tr> 
 <td> CREATE TABLE </td> 
 <td> <pre><code>CREATE TABLE table_name
(
column_name1 data_type,
column_name2 data_type,
.......
)</code></pre> </td> 
 </tr> 
 <tr> 
 <td> CREATE UNIQUE INDEX </td> 
 <td> <pre><code>CREATE UNIQUE INDEX index_name
ON table_name (column_name)</code></pre> </td> 
 </tr> 
 <tr> 
 <td> CREATE VIEW </td> 
 <td> <pre><code>CREATE VIEW view_name AS
SELECT column_name(s)
FROM table_name
WHERE condition</code></pre> </td> 
 </tr> 
 <tr> 
 <td> DELETE FROM </td> 
 <td> <pre><code>DELETE FROM table_name
(Note:&nbsp;Deletes the entire table!!)
or

DELETE FROM table_name
WHERE condition</code></pre> </td> 
 </tr> 
 <tr> 
 <td> DROP DATABASE </td> 
 <td> <pre><code>DROP DATABASE database_name</code></pre> </td> 
 </tr> 
 <tr> 
 <td> DROP INDEX </td> 
 <td> <pre><code>DROP INDEX table_name.index_name</code></pre> </td> 
 </tr> 
 <tr> 
 <td> DROP TABLE </td> 
 <td> <pre><code>DROP TABLE table_name</code></pre> </td> 
 </tr> 
 <tr> 
 <td> GROUP BY </td> 
 <td> <pre><code>SELECT column_name1,SUM(column_name2)
FROM table_name
GROUP BY column_name1</code></pre> </td> 
 </tr> 
 <tr> 
 <td> HAVING </td> 
 <td> <pre><code>SELECT column_name1,SUM(column_name2)
FROM table_name
GROUP BY column_name1
HAVING SUM(column_name2) condition value</code></pre> </td> 
 </tr> 
 <tr> 
 <td> IN </td> 
 <td> <pre><code>SELECT column_name(s)
FROM table_name
WHERE column_name
IN (value1,value2,..)</code></pre> </td> 
 </tr> 
 <tr> 
 <td> INSERT INTO </td> 
 <td> <pre><code>INSERT INTO table_name
VALUES (value1, value2,....)
or

INSERT INTO table_name
(column_name1, column_name2,...)
VALUES (value1, value2,....)</code></pre> </td> 
 </tr> 
 <tr> 
 <td> LIKE </td> 
 <td> <pre><code>SELECT column_name(s)
FROM table_name
WHERE column_name
LIKE pattern</code></pre> </td> 
 </tr> 
 <tr> 
 <td> ORDER BY </td> 
 <td> <pre><code>SELECT column_name(s)
FROM table_name
ORDER BY column_name [ASC|DESC]</code></pre> </td> 
 </tr> 
 <tr> 
 <td> SELECT </td> 
 <td> <pre><code>SELECT column_name(s)
FROM table_name</code></pre> </td> 
 </tr> 
 <tr> 
 <td> SELECT * </td> 
 <td> <pre><code>SELECT *
FROM table_name</code></pre> </td> 
 </tr> 
 <tr> 
 <td> SELECT DISTINCT </td> 
 <td> <pre><code>SELECT DISTINCT column_name(s)
FROM table_name</code></pre> </td> 
 </tr> 
 <tr> 
 <td> SELECT INTO (used to create backup copies of tables) </td> 
 <td> <pre><code>SELECT *
INTO new_table_name
FROM original_table_name
or

SELECT column_name(s)
INTO new_table_name
FROM original_table_name</code></pre> </td> 
 </tr> 
 <tr> 
 <td> TRUNCATE TABLE (deletes only the data inside the table) </td> 
 <td> <pre><code>TRUNCATE TABLE table_name</code></pre> </td> 
 </tr> 
 <tr> 
 <td> UPDATE </td> 
 <td> <pre><code>UPDATE table_name
SET column_name=new_value
[, column_name=new_value]
WHERE column_name=some_value</code></pre> </td> 
 </tr> 
 <tr> 
 <td> WHERE </td> 
 <td> <pre><code>SELECT column_name(s)
FROM table_name
WHERE condition</code></pre> </td> 
 </tr> 
 </tbody> 
</table>

# 附赠技术学习路线图  #

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTcwNjU4_size_16_color_FFFFFF_t_70][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTcwNjU4_size_16_color_FFFFFF_t_70 1][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTcwNjU4_size_16_color_FFFFFF_t_70]: /images/20220829/57a4af2f7f8b48118471bb597a8aca09.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTcwNjU4_size_16_color_FFFFFF_t_70 1]: /images/20220829/6a6bb1515a1d4bf1a328ef3649e8e785.png