1、Learn SQL| Codecademy第一节学习笔记
2、学习记录☞Learn SQL| Codecademy 第二节总结(原文是网站上的总结,翻译是作为英语渣渣自己强行翻译的,注释是自己扩展的知识)
·原文:SELECT is the clause you use every time you want to query information from a database.
·翻译:SELECT 是你每次想要从数据库中查询信息时需要用到的语句。
·原文:WHERE is a popular command that lets you filter the results of the query based on conditions that you specify.
·翻译:WHERE 是一个常用的命令,让你能根据指定的条件筛选查询结果。
·原文: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一同使用,让你能根据两个及以上条件筛选查询结果。
·原文:ORDER BY lets you sort the results of the query in either ascending or descending order.
·翻译:ORDER BY 让你能将查询结果按照升序或者降序排列。
·原文: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 让你明确查询返回的最大行数。这在一些有着几千甚至几百万行的数据表格中特别重要。
——— END ——
2017年09月22日