SQL 教程

你的名字 2021-09-21 00:42 480阅读 0赞

## SQL 视频教程 ##

[SQL视频教程][SQL]

--------------------

## 本节内容 ##

<table> 
 <tbody> 
  <tr> 
   <td><a href="http://codingdict.com/article/6946" rel="nofollow">SQL 教程</a></td> 
   <td><a href="http://codingdict.com/article/6947" rel="nofollow">SQL 简介</a></td> 
   <td><a href="http://codingdict.com/article/6948" rel="nofollow">SQL 语法</a></td> 
   <td><a href="http://codingdict.com/article/6949" rel="nofollow">SQL Select选择</a></td> 
   <td><a href="http://codingdict.com/article/6950" rel="nofollow">SQL SELECT DISTINCT</a></td> 
  </tr> 
  <tr> 
   <td><a href="http://codingdict.com/article/6951" rel="nofollow">SQL 查询子句</a></td> 
   <td><a href="http://codingdict.com/article/6952" rel="nofollow">SQL 与，或，非</a></td> 
   <td><a href="http://codingdict.com/article/6953" rel="nofollow">SQL 按关键字排序</a></td> 
   <td><a href="http://codingdict.com/article/6954" rel="nofollow">SQL 在表中插入</a></td> 
   <td><a href="http://codingdict.com/article/6955" rel="nofollow">SQL 空值</a></td> 
  </tr> 
  <tr> 
   <td><a href="http://codingdict.com/article/6956" rel="nofollow">SQL 更新</a></td> 
   <td><a href="http://codingdict.com/article/6957" rel="nofollow">SQL 删除</a></td> 
   <td><a href="http://codingdict.com/article/6959" rel="nofollow">SQL SELECT TOP, LIMIT, ROWNUM</a></td> 
   <td><a href="http://codingdict.com/article/6960" rel="nofollow">SQL LIKE 运算符</a></td> 
   <td><a href="http://codingdict.com/article/6961" rel="nofollow">SQL Wildcards 通配符</a></td> 
  </tr> 
  <tr> 
   <td><a href="http://codingdict.com/article/6962" rel="nofollow">SQL IN 运算符</a></td> 
   <td><a href="http://codingdict.com/article/6963" rel="nofollow">SQL BETWEEN运算符</a></td> 
   <td><a href="http://codingdict.com/article/6964" rel="nofollow">SQL 通用数据类型</a></td> 
   <td><a href="http://codingdict.com/article/6965" rel="nofollow">SQL 语句快速参考</a></td> 
   <td><a href="http://codingdict.com/article/6966" rel="nofollow">SQL Join连接</a></td> 
  </tr> 
  <tr> 
   <td><a href="http://codingdict.com/article/6967" rel="nofollow">SQL 内部连接</a></td> 
   <td><a href="http://codingdict.com/article/6968" rel="nofollow">SQL 左连接</a></td> 
   <td><a href="http://codingdict.com/article/6969" rel="nofollow">SQL 右连接</a></td> 
   <td><a href="http://codingdict.com/article/6970" rel="nofollow">SQL 完整外部连接</a></td> 
   <td><a href="http://codingdict.com/article/6971" rel="nofollow">SQL 自连接</a></td> 
  </tr> 
  <tr> 
   <td><a href="http://codingdict.com/article/6972" rel="nofollow">SQL UNION 运算符</a></td> 
   <td><a href="http://codingdict.com/article/6973" rel="nofollow">SQL SELECT INTO 语句</a></td> 
   <td><a href="http://codingdict.com/article/6974" rel="nofollow">SQL INSERT INTO SELECT 语句</a></td> 
   <td><a href="http://codingdict.com/article/6975" rel="nofollow">SQL 撤销索引、表以及数据库</a></td> 
   <td><a href="http://codingdict.com/article/6976" rel="nofollow">SQL CREATE DATABASE 语句</a></td> 
  </tr> 
  <tr> 
   <td><a href="http://codingdict.com/article/6977" rel="nofollow">SQL CREATE TABLE 语句</a></td> 
   <td><a href="http://codingdict.com/article/6978" rel="nofollow">SQL ALTER TABLE 语句</a></td> 
   <td><a href="http://codingdict.com/article/6979" rel="nofollow">SQL AUTO INCREMENT 字段</a></td> 
   <td><a href="http://codingdict.com/article/6980" rel="nofollow">SQL CREATE VIEW、REPLACE VIEW、 DROP VIEW 语句</a></td> 
   <td><a href="http://codingdict.com/article/6981" rel="nofollow">SQL Server 和 MySQL 中的 Date 函数</a></td> 
  </tr> 
  <tr> 
   <td><a href="http://codingdict.com/article/6982" rel="nofollow">SQL NULL 值 – IS NULL 和 IS NOT NULL</a></td> 
   <td><a href="http://codingdict.com/article/6984" rel="nofollow">SQL Aliases 别名</a></td> 
   <td><a href="http://codingdict.com/article/6985" rel="nofollow">SQL 约束</a></td> 
   <td><a href="http://codingdict.com/article/6986" rel="nofollow">SQL NOT NULL 约束</a></td> 
   <td><a href="http://codingdict.com/article/6987" rel="nofollow">SQL UNIQUE 约束</a></td> 
  </tr> 
  <tr> 
   <td><a href="http://codingdict.com/article/6988" rel="nofollow">SQL PRIMARY KEY 约束</a></td> 
   <td><a href="http://codingdict.com/article/6989" rel="nofollow">SQL FOREIGN KEY 约束</a></td> 
   <td><a href="http://codingdict.com/article/6990" rel="nofollow">SQL DEFAULT 约束</a></td> 
   <td><a href="http://codingdict.com/article/6991" rel="nofollow">SQL CHECK 约束</a></td> 
   <td><a href="http://codingdict.com/article/6992" rel="nofollow">SQL JOIN 连接</a></td> 
  </tr> 
  <tr> 
   <td><a href="http://codingdict.com/article/6993" rel="nofollow">SQL UNION 子句</a></td> 
   <td><a href="http://codingdict.com/article/6994" rel="nofollow">SQL 克隆数据表</a></td> 
   <td><a href="http://codingdict.com/article/6995" rel="nofollow">SQL 索引</a></td> 
   <td><a href="http://codingdict.com/article/6996" rel="nofollow">SQL 子查询</a></td> 
   <td><a href="http://codingdict.com/article/6997" rel="nofollow">SQL ALTER TABLE 命令</a></td> 
  </tr> 
  <tr> 
   <td><a href="http://codingdict.com/article/6998" rel="nofollow">SQL TRUNCATE TABLE 命令</a></td> 
   <td><a href="http://codingdict.com/article/6999" rel="nofollow">SQL 处理重复数据</a></td> 
   <td><a href="http://codingdict.com/article/7000" rel="nofollow">SQL 使用视图</a></td> 
   <td><a href="http://codingdict.com/article/7001" rel="nofollow">SQL 注入</a></td> 
   <td><a href="http://codingdict.com/article/7002" rel="nofollow">SQL HAVING 子句</a></td> 
  </tr> 
  <tr> 
   <td><a href="http://codingdict.com/article/7003" rel="nofollow">SQL 事务</a></td> 
   <td><a href="http://codingdict.com/article/7004" rel="nofollow">SQL 使用序列</a></td> 
   <td><a href="http://codingdict.com/article/7005" rel="nofollow">SQL 通配符</a></td> 
   <td><a href="http://codingdict.com/article/7006" rel="nofollow">SQL 临时表</a></td> 
   <td><a href="http://codingdict.com/article/7007" rel="nofollow">SQL MS Access、MySQL 和 SQL Server 数据类型</a></td> 
  </tr> 
  <tr> 
   <td><a href="http://codingdict.com/article/7009" rel="nofollow">SQL MAX() 函数</a></td> 
   <td><a href="http://codingdict.com/article/7010" rel="nofollow">SQL MIN() 函数</a></td> 
   <td><a href="http://codingdict.com/article/7011" rel="nofollow">SQL COUNT() 函数</a></td> 
   <td><a href="http://codingdict.com/article/7012" rel="nofollow">SQL AVG() 函数</a></td> 
   <td><a href="http://codingdict.com/article/7013" rel="nofollow">SQL SUM() 函数</a></td> 
  </tr> 
  <tr> 
   <td><a href="http://codingdict.com/article/7014" rel="nofollow">SQL 日期函数</a></td> 
   <td><a href="http://codingdict.com/article/7015" rel="nofollow">SQL 函数</a></td> 
   <td><a href="http://codingdict.com/article/7016" rel="nofollow">SQL FIELD()函数</a></td> 
   <td><a href="http://codingdict.com/article/7017" rel="nofollow">SQL FIRST() 函数</a></td> 
   <td><a href="http://codingdict.com/article/7018" rel="nofollow">SQL LAST() 函数</a></td> 
  </tr> 
  <tr> 
   <td><a href="http://codingdict.com/article/7019" rel="nofollow">SQL GROUP BY 语句</a></td> 
   <td><a href="http://codingdict.com/article/7020" rel="nofollow">SQL HAVING 子句</a></td> 
   <td><a href="http://codingdict.com/article/7021" rel="nofollow">SQL UPPER(),LOWER()函数</a></td> 
   <td><a href="http://codingdict.com/article/7022" rel="nofollow">SQL UPPER()函数</a></td> 
   <td><a href="http://codingdict.com/article/7023" rel="nofollow">SQL LOWER()函数</a></td> 
  </tr> 
  <tr> 
   <td><a href="http://codingdict.com/article/7024" rel="nofollow">SQL UCASE() 函数</a></td> 
   <td><a href="http://codingdict.com/article/7025" rel="nofollow">SQL LCASE() 函数</a></td> 
   <td><a href="http://codingdict.com/article/7026" rel="nofollow">SQL MID() 函数</a></td> 
   <td><a href="http://codingdict.com/article/7027" rel="nofollow">SQL LEN() 函数</a></td> 
   <td><a href="http://codingdict.com/article/7028" rel="nofollow">SQL ROUND() 函数</a></td> 
  </tr> 
  <tr> 
   <td><a href="http://codingdict.com/article/7029" rel="nofollow">SQL NOW() 函数</a></td> 
   <td><a href="http://codingdict.com/article/7030" rel="nofollow">SQL FORMAT() 函数</a></td> 
   <td><a href="http://codingdict.com/article/7031" rel="nofollow">SQL SQRT() 函数</a></td> 
   <td><a href="http://codingdict.com/article/7032" rel="nofollow">SQL RAND() 函数</a></td> 
   <td><a href="http://codingdict.com/article/7033" rel="nofollow">SQL CONCAT() 函数</a></td> 
  </tr> 
  <tr> 
   <td><a href="http://codingdict.com/article/7034" rel="nofollow">SQL ISNULL()、NVL()、IFNULL() 和 COALESCE() 函数</a></td> 
   <td><a href="http://codingdict.com/article/7035" rel="nofollow">SQL REPLACE()函数</a></td> 
   <td><a href="http://codingdict.com/article/7036" rel="nofollow">SQL TRIM()函数</a></td> 
   <td><a href="http://codingdict.com/article/21225" rel="nofollow">MySQL NOW() 函数</a></td> 
   <td><a href="http://codingdict.com/article/21226" rel="nofollow">MySQL CURDATE() 函数</a></td> 
  </tr> 
  <tr> 
   <td><a href="http://codingdict.com/article/21227" rel="nofollow">MySQL CURTIME() 函数</a></td> 
   <td><a href="http://codingdict.com/article/21228" rel="nofollow">MySQL DATE() 函数</a></td> 
   <td><a href="http://codingdict.com/article/21229" rel="nofollow">MySQL EXTRACT() 函数</a></td> 
   <td><a href="http://codingdict.com/article/21230" rel="nofollow">MySQL DATE_ADD() 函数</a></td> 
   <td><a href="http://codingdict.com/article/21231" rel="nofollow">MySQL DATE_SUB() 函数</a></td> 
  </tr> 
  <tr> 
   <td><a href="http://codingdict.com/article/21232" rel="nofollow">MySQL DATEDIFF() 函数</a></td> 
   <td><a href="http://codingdict.com/article/21233" rel="nofollow">MySQL DATE_FORMAT() 函数</a></td> 
   <td><a href="http://codingdict.com/article/21234" rel="nofollow">SQL Server GETDATE() 函数</a></td> 
   <td><a href="http://codingdict.com/article/21235" rel="nofollow">SQL Server DATEPART() 函数</a></td> 
   <td><a href="http://codingdict.com/article/21236" rel="nofollow">SQL Server DATEADD() 函数</a></td> 
  </tr> 
  <tr> 
   <td><a href="http://codingdict.com/article/21237" rel="nofollow">SQL Server DATEDIFF() 函数</a></td> 
   <td><a href="http://codingdict.com/article/21238" rel="nofollow">SQL Server CONVERT() 函数</a></td> 
  </tr> 
 </tbody> 
</table>

[SQL]: http://codingdict.com/video/1161