1、Learn SQL| Codecademy第一節(jié)學(xué)習(xí)筆記
2誉裆、學(xué)習(xí)記錄?Learn SQL| Codecademy 第二節(jié)總結(jié)(原文是網(wǎng)站上的總結(jié),翻譯是作為英語渣渣自己強行翻譯的葛圃,注釋是自己擴展的知識)
·原文:SELECT is the clause you use every time you want to query information from a database.
·翻譯:SELECT 是你每次想要從數(shù)據(jù)庫中查詢信息時需要用到的語句。
·原文:WHERE is a popular command that lets you filter the results of the query based on conditions that you specify.
·翻譯:WHERE 是一個常用的命令砸烦,讓你能根據(jù)指定的條件篩選查詢結(jié)果。
·原文:LIKE and BETWEEN are special operators that can be used in a WHERE clause
·翻譯:LIKE 和 BETWEEN 是可以用在?WHERE 子句中的指定模式绞吁。
·原文:AND and OR are special operators that you can use with WHERE to filter the query on two or more conditions.
·翻譯:AND 和 OR 可以與WHERE一同使用幢痘,讓你能根據(jù)兩個及以上條件篩選查詢結(jié)果。
·原文:ORDER BY lets you sort the results of the query in either ascending or descending order.
·翻譯:ORDER BY 讓你能將查詢結(jié)果按照升序或者降序排列家破。
·原文:LIMIT lets you specify the maximum number of rows that the query will return. This is especially important in large tables that have thousands or even millions of rows.
·翻譯:LIMIT 讓你明確查詢返回的最大行數(shù)颜说。這在一些有著幾千甚至幾百萬行的數(shù)據(jù)表格中特別重要。
——— END ——
2017年09月22日