SQL教程
422
125页
4次
2019-09-10
25墨值下载
SQL 教程 .............................................................................................................................................. 12
SQL 简介 .......................................................................................................................................... 12
什么是
SQL
.............................................................................................................................. 12
SQL
能做什么?
.......................................................................................................................... 12
SQL
是一种标准
-
但是
... ......................................................................................................... 12
在您的网站中使用
SQL .............................................................................................................. 12
RDBMS ......................................................................................................................................... 13
SQL 语法 .......................................................................................................................................... 14
数据库表
........................................................................................................................................ 14
SQL
语句
..................................................................................................................................... 14
重要事项
........................................................................................................................................ 14
SQL
语句后面的分号?
.............................................................................................................. 14
SQL DML
DDL ...................................................................................................................... 15
SQL SELECT 语句 ......................................................................................................................... 16
SQL SELECT
语句
..................................................................................................................... 16
SQL SELECT
实例
..................................................................................................................... 16
SQL SELECT *
实例
.................................................................................................................. 16
在结果集(
result-set
)中导航
.................................................................................................. 17
SQL SELECT DISTINCT 语句 ...................................................................................................... 18
SQL SELECT DISTINCT
语句
................................................................................................. 18
使用
DISTINCT
关键词
............................................................................................................. 18
SQL WHERE 子句 .......................................................................................................................... 20
WHERE
子句
............................................................................................................................... 20
使用
WHERE
子句
..................................................................................................................... 20
引号的使用
.................................................................................................................................... 21
SQL AND & OR 运算符 .................................................................................................................. 22
AND
OR
运算符
................................................................................................................... 22
原始的表
(
用在例子中的
)
....................................................................................................... 22
AND
运算符实例
......................................................................................................................... 22
OR
运算符实例
............................................................................................................................ 22
结合
AND
OR
运算符
......................................................................................................... 23
SQL ORDER BY 子句 .................................................................................................................... 24
ORDER BY
语句
......................................................................................................................... 24
原始的表
(
用在例子中的
)
....................................................................................................... 24
实例
1 ........................................................................................................................................... 24
实例
2 ........................................................................................................................................... 24
实例
3 ........................................................................................................................................... 25
实例
4 ........................................................................................................................................... 25
SQL INSERT INTO 语句 ................................................................................................................ 27
INSERT INTO
语句
.................................................................................................................... 27
插入新的行
.................................................................................................................................... 27
在指定的列中插入数据
................................................................................................................ 27
SQL UPDATE 语句 ......................................................................................................................... 29
Update
语句
................................................................................................................................ 29
更新某一行中的一个列
................................................................................................................ 29
更新某一行中的若干列
................................................................................................................ 29
SQL DELETE 语句 ......................................................................................................................... 30
DELETE
语句
.............................................................................................................................. 30
of 125
25墨值下载
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文档的来源(墨天轮),文档链接,文档作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论

关注
最新上传
暂无内容,敬请期待...
下载排行榜
Top250 周榜 月榜