📄 sql
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<!-- saved from url=(0061)http://distance.njtu.edu.cn/course/8100062/kejian/web/3-2.htm -->
<HTML><HEAD><TITLE>SQL的数据操作语句</TITLE>
<META content="text/html; charset=gb2312" http-equiv=Content-Type>
<META content="MSHTML 5.00.3502.5390" name=GENERATOR>
<SCRIPT language=JavaScript src="SQL的数据操作语句-北京交大.files/content.js"></SCRIPT>
<SCRIPT>
<!--
InitItem = "elFour";
pageitem = 3;
function abar (st,col) { st.style.backgroundColor = '#C9C9C9'; }
function bbar (st) { st.style.backgroundColor = ''; }
// -->
</SCRIPT>
<STYLE>A {
COLOR: #333366; FONT-SIZE: 10.5pt; TEXT-DECORATION: none
}
A:hover {
COLOR: black; TEXT-DECORATION: none
}
P {
FONT-SIZE: 10.5pt
}
TABLE {
FONT-SIZE: 10.5pt
}
TD {
FONT-SIZE: 10.5pt
}
TR {
FONT-SIZE: 10.5pt
}
.txleft1 {
COLOR: #e76d00; FONT-WEIGHT: bold; PADDING-LEFT: 1px; PADDING-TOP: 3px
}
.txleft2 {
PADDING-LEFT: 15px; PADDING-TOP: 3px
}
</STYLE>
</HEAD>
<BODY bgColor=#ffffff topMargin=0 marginheight="0"><!-- Begin of Header -->
<TABLE align=center border=0 cellPadding=0 cellSpacing=0 width=750>
<TBODY>
<TR vAlign=top><!-- row 1 -->
<TD width=76></TD>
<TD><IMG border=0 height=70 name=titleall_r1_c1
src="SQL的数据操作语句-北京交大.files/titleall_r1_c1.jpg" width=363></TD>
<TD><IMG border=0 height=70 name=titleall_r1_c2
src="SQL的数据操作语句-北京交大.files/titleall_r1_c2.jpg" width=310></TD>
<TD><IMG border=0 height=70 src="" width=1></TD></TR>
<TR bgColor=#f2f2f2 height=22 vAlign=top><!-- row 3 -->
<TD colSpan=2 vAlign=center> <A
href="http://distance.njtu.edu.cn/course/8100062/kejian/index.htm"
target=_top>课程主页</A> <A
href="http://distance.njtu.edu.cn/course/8100062/kejian/web/jxdg.htm"
target=_top>教学大纲</A> <A
href="http://distance.njtu.edu.cn/course/8100062/kejian/web/syzd.htm"
target=_top>实验指导</A> <A
href="http://distance.njtu.edu.cn/course/8100062/kejian/web/xxyd.htm"
target=_top>学习园地</A> <A
href="http://distance.njtu.edu.cn/course/8100062/kejian/test/testframes.htm"
target=_top>网上测试</A> <A
href="http://distance.njtu.edu.cn/course/8100062/kejian/index/kuang.asp"
target=_top>知识点索引</A></TD>
<TD align=right><IMG border=0 height=18 name=titleall_r2_c1
src="SQL的数据操作语句-北京交大.files/titleall_r2_c2.jpg" width=150></TD>
<TD width=1></TD></TR>
<TR height=1>
<TD bgColor=#959595 colSpan=4></TD></TR>
<TR height=2>
<TD></TD></TR></TBODY></TABLE><!-- End of Header -->
<TABLE align=center border=0 cellPadding=0 cellSpacing=0 width=750>
<TBODY>
<TR>
<TD align=left bgColor=#f2f2f2 vAlign=top width=185><!-- Begin of Left -->
<TABLE border=0 cellPadding=0 cellSpacing=0>
<TBODY>
<TR>
<TD bgColor=#cecfce height=1></TD></TR>
<TR>
<TD>
<TABLE border=0 cellPadding=0 cellSpacing=0 width="100%">
<TBODY>
<TR onclick="expandIt('elOne','0'); return false">
<TD rowSpan=2 width=5></TD>
<TD class=txleft1 height=23>
<DIV class=parent id=elOneParent><IMG border=0 height=9
id=elOneImg src="SQL的数据操作语句-北京交大.files/plus.gif"
width=9> <A class=item
href="http://distance.njtu.edu.cn/course/8100062/kejian/web/3-2.htm#">数据库基本理论</A></DIV></TD></TR>
<TR>
<TD>
<DIV class=child id=elOneChild>
<TABLE border=0 borderColor=#c0c0c0 borderColorDark=#ffffff
borderColorLight=#ffffff cellSpacing=1 width="100%">
<TBODY>
<TR>
<TD class=txleft2 onmouseout=bbar(this)
onmouseover=abar(this)><A class=item
href="http://distance.njtu.edu.cn/course/8100062/kejian/web/1-1.htm"
target=_self>基本概念</A></TD></TR>
<TR>
<TD class=txleft2 onmouseout=bbar(this)
onmouseover=abar(this)><A class=item
href="http://distance.njtu.edu.cn/course/8100062/kejian/web/1-2.htm"
target=_self>数据库系统的特征</A></TD></TR>
<TR>
<TD class=txleft2 onmouseout=bbar(this)
onmouseover=abar(this)><A class=item
href="http://distance.njtu.edu.cn/course/8100062/kejian/web/1-3.htm"
target=_self>结构与数据独立性</A></TD></TR>
<TR>
<TD class=txleft2 onmouseout=bbar(this)
onmouseover=abar(this)><A class=item
href="http://distance.njtu.edu.cn/course/8100062/kejian/web/1-4.htm"
target=_self>数据模型</A></TD></TR></TBODY></TABLE></DIV></TD></TR></TBODY></TABLE></TD></TR>
<TR>
<TD bgColor=#cecfce height=1></TD></TR>
<TR>
<TD>
<TABLE border=0 cellPadding=0 cellSpacing=0 width="100%">
<TBODY>
<TR onclick="expandIt('elTwo','0'); return false">
<TD rowSpan=2 width=5></TD>
<TD class=txleft1 height=23>
<DIV class=parent id=elTwoParent><IMG border=0 height=9
id=elTwoImg src="SQL的数据操作语句-北京交大.files/plus.gif"
width=9> <A class=item
href="http://distance.njtu.edu.cn/course/8100062/kejian/web/3-2.htm#">关系数据库</A></DIV></TD></TR>
<TR>
<TD>
<DIV class=child id=elTwoChild>
<TABLE border=0 borderColor=#c0c0c0 borderColorDark=#ffffff
borderColorLight=#ffffff cellSpacing=1 width="100%">
<TBODY>
<TR>
<TD class=txleft2 onmouseout=bbar(this)
onmouseover=abar(this)><A class=item
href="http://distance.njtu.edu.cn/course/8100062/kejian/web/1-1.htm"></A><A
class=item
href="http://distance.njtu.edu.cn/course/8100062/kejian/web/2-1.htm"
target=_self>关系操作</A></TD></TR>
<TR>
<TD class=txleft2 onmouseout=bbar(this)
onmouseover=abar(this)><A class=item
href="http://distance.njtu.edu.cn/course/8100062/kejian/web/1-1.htm"></A><A
class=item
href="http://distance.njtu.edu.cn/course/8100062/kejian/web/2-2.htm"
target=_self>关系模型的完整性</A></TD></TR>
<TR>
<TD class=txleft2 onmouseout=bbar(this)
onmouseover=abar(this)><A class=item
href="http://distance.njtu.edu.cn/course/8100062/kejian/web/1-1.htm"></A><A
class=item
href="http://distance.njtu.edu.cn/course/8100062/kejian/web/2-3.htm"
target=_self>关系数据库设计理论</A></TD></TR></TBODY></TABLE></DIV></TD></TR></TBODY></TABLE></TD></TR>
<TR>
<TD bgColor=#cecfce height=1></TD></TR>
<TR>
<TD>
<TABLE border=0 cellPadding=0 cellSpacing=0 width="100%">
<TBODY>
<TR onclick="expandIt('elFour','0'); return false">
<TD rowSpan=2 width=5></TD>
<TD class=txleft1 height=23>
<DIV class=parent id=elFourParent><IMG border=0 height=9
id=elFourImg src="SQL的数据操作语句-北京交大.files/plus.gif"
width=9> <A class=item
href="http://distance.njtu.edu.cn/course/8100062/kejian/web/3-2.htm#">结构化查询语言SQL</A></DIV></TD></TR>
<TR>
<TD>
<DIV class=child id=elFourChild>
<TABLE border=0 borderColor=#c0c0c0 borderColorDark=#ffffff
borderColorLight=#ffffff cellSpacing=1 width="100%">
<TBODY>
<TR>
<TD class=txleft2 onmouseout=bbar(this)
onmouseover=abar(this)><A class=item
href="http://distance.njtu.edu.cn/course/8100062/kejian/web/3-1.htm"
target=_self>SQL的数据定义语言</A></TD></TR>
<TR>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -