http://202.127.29.3/~shen/wiki/index.php?action=history&feed=atom&title=Mysql
Mysql - 版本历史
2026-05-09T18:40:06Z
本wiki上该页面的版本历史
MediaWiki 1.38.1
http://202.127.29.3/~shen/wiki/index.php?title=Mysql&diff=3934&oldid=prev
2023年3月19日 (日) 08:32 Shen
2023-03-19T08:32:31Z
<p></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="zh-Hans-CN">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">←上一版本</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">2023年3月19日 (日) 08:32的版本</td>
</tr><tr>
<td colspan="2" class="diff-lineno">第14行：</td>
<td colspan="2" class="diff-lineno">第14行：</td>
</tr>
<tr>
<td class="diff-marker"></td>
<td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div> mysql> quit</div></td>
<td class="diff-marker"></td>
<td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div> mysql> quit</div></td>
</tr>
<tr>
<td class="diff-marker"></td>
<td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br /></td>
<td class="diff-marker"></td>
<td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br /></td>
</tr>
<tr>
<td class="diff-marker" data-marker="−"></td>
<td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>*建立某个数据库db1</div></td>
<td class="diff-marker" data-marker="+"></td>
<td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>*建立某个<ins style="font-weight: bold; text-decoration: none;">[[</ins>数据库<ins style="font-weight: bold; text-decoration: none;">]]</ins>db1</div></td>
</tr>
<tr>
<td class="diff-marker"></td>
<td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>:mysql -u root -p</div></td>
<td class="diff-marker"></td>
<td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>:mysql -u root -p</div></td>
</tr>
<tr>
<td class="diff-marker"></td>
<td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>:password:***</div></td>
<td class="diff-marker"></td>
<td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>:password:***</div></td>
</tr>
<!-- diff cache key wikidb2:diff:wikidiff2:1.12:old-3732:rev-3934:1.14.1 -->
</table>
Shen
http://202.127.29.3/~shen/wiki/index.php?title=Mysql&diff=3732&oldid=prev
Shen：/* sql语言 */
2022-02-07T11:43:51Z
<p><span dir="auto"><span class="autocomment">sql语言</span></span></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="zh-Hans-CN">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">←上一版本</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">2022年2月7日 (一) 11:43的版本</td>
</tr><tr>
<td colspan="2" class="diff-lineno">第53行：</td>
<td colspan="2" class="diff-lineno">第53行：</td>
</tr>
<tr>
<td class="diff-marker"></td>
<td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>:insert into db(col) VALUES (value)</div></td>
<td class="diff-marker"></td>
<td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>:insert into db(col) VALUES (value)</div></td>
</tr>
<tr>
<td class="diff-marker"></td>
<td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>*update db SET cols=newvalue where</div></td>
<td class="diff-marker"></td>
<td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>*update db SET cols=newvalue where</div></td>
</tr>
<tr>
<td colspan="2" class="diff-empty diff-side-deleted"></td>
<td class="diff-marker" data-marker="+"></td>
<td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><br /></td>
</tr>
<tr>
<td colspan="2" class="diff-empty diff-side-deleted"></td>
<td class="diff-marker" data-marker="+"></td>
<td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>===[[Python]]中的sql===</div></td>
</tr>
<tr>
<td colspan="2" class="diff-empty diff-side-deleted"></td>
<td class="diff-marker" data-marker="+"></td>
<td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>*importsqlite3</div></td>
</tr>
<!-- diff cache key wikidb2:diff:wikidiff2:1.12:old-3731:rev-3732:1.14.1 -->
</table>
Shen
http://202.127.29.3/~shen/wiki/index.php?title=Mysql&diff=3731&oldid=prev
Shen：/* sql语言 */
2022-02-07T11:43:07Z
<p><span dir="auto"><span class="autocomment">sql语言</span></span></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="zh-Hans-CN">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">←上一版本</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">2022年2月7日 (一) 11:43的版本</td>
</tr><tr>
<td colspan="2" class="diff-lineno">第48行：</td>
<td colspan="2" class="diff-lineno">第48行：</td>
</tr>
<tr>
<td class="diff-marker"></td>
<td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>*group 处理部分选择的row(distinct的value)</div></td>
<td class="diff-marker"></td>
<td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>*group 处理部分选择的row(distinct的value)</div></td>
</tr>
<tr>
<td class="diff-marker"></td>
<td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>:select [columns] from [table] group by [expression] having [expression]</div></td>
<td class="diff-marker"></td>
<td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>:select [columns] from [table] group by [expression] having [expression]</div></td>
</tr>
<tr>
<td colspan="2" class="diff-empty diff-side-deleted"></td>
<td class="diff-marker" data-marker="+"></td>
<td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>*drop 删除数据库</div></td>
</tr>
<tr>
<td colspan="2" class="diff-empty diff-side-deleted"></td>
<td class="diff-marker" data-marker="+"></td>
<td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>*delete from db where :删除rows</div></td>
</tr>
<tr>
<td colspan="2" class="diff-empty diff-side-deleted"></td>
<td class="diff-marker" data-marker="+"></td>
<td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>*insert into db VALUES 在表中插入colomns</div></td>
</tr>
<tr>
<td colspan="2" class="diff-empty diff-side-deleted"></td>
<td class="diff-marker" data-marker="+"></td>
<td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>:insert into db(col) VALUES (value)</div></td>
</tr>
<tr>
<td colspan="2" class="diff-empty diff-side-deleted"></td>
<td class="diff-marker" data-marker="+"></td>
<td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>*update db SET cols=newvalue where</div></td>
</tr>
</table>
Shen
http://202.127.29.3/~shen/wiki/index.php?title=Mysql&diff=3730&oldid=prev
Shen：/* sql语言 */
2022-02-07T07:22:39Z
<p><span dir="auto"><span class="autocomment">sql语言</span></span></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="zh-Hans-CN">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">←上一版本</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">2022年2月7日 (一) 07:22的版本</td>
</tr><tr>
<td colspan="2" class="diff-lineno">第47行：</td>
<td colspan="2" class="diff-lineno">第47行：</td>
</tr>
<tr>
<td class="diff-marker"></td>
<td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>*有一些命令可以直接处理所有记录，如max，sum等,count,distinct</div></td>
<td class="diff-marker"></td>
<td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>*有一些命令可以直接处理所有记录，如max，sum等,count,distinct</div></td>
</tr>
<tr>
<td class="diff-marker"></td>
<td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>*group 处理部分选择的row(distinct的value)</div></td>
<td class="diff-marker"></td>
<td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>*group 处理部分选择的row(distinct的value)</div></td>
</tr>
<tr>
<td colspan="2" class="diff-empty diff-side-deleted"></td>
<td class="diff-marker" data-marker="+"></td>
<td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>:select [columns] from [table] group by [expression] having [expression]</div></td>
</tr>
<!-- diff cache key wikidb2:diff:wikidiff2:1.12:old-3729:rev-3730:1.14.1 -->
</table>
Shen
http://202.127.29.3/~shen/wiki/index.php?title=Mysql&diff=3729&oldid=prev
Shen：/* sql语言 */
2022-02-07T07:19:01Z
<p><span dir="auto"><span class="autocomment">sql语言</span></span></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="zh-Hans-CN">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">←上一版本</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">2022年2月7日 (一) 07:19的版本</td>
</tr><tr>
<td colspan="2" class="diff-lineno">第46行：</td>
<td colspan="2" class="diff-lineno">第46行：</td>
</tr>
<tr>
<td class="diff-marker"></td>
<td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>*字符串的处理："hello,"|| "world" 就是 hello，world，还有substr(),instr()等命令</div></td>
<td class="diff-marker"></td>
<td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>*字符串的处理："hello,"|| "world" 就是 hello，world，还有substr(),instr()等命令</div></td>
</tr>
<tr>
<td class="diff-marker"></td>
<td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>*有一些命令可以直接处理所有记录，如max，sum等,count,distinct</div></td>
<td class="diff-marker"></td>
<td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>*有一些命令可以直接处理所有记录，如max，sum等,count,distinct</div></td>
</tr>
<tr>
<td class="diff-marker" data-marker="−"></td>
<td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>*group 处理部分选择的row</div></td>
<td class="diff-marker" data-marker="+"></td>
<td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>*group 处理部分选择的row<ins style="font-weight: bold; text-decoration: none;">(distinct的value)</ins></div></td>
</tr>
<!-- diff cache key wikidb2:diff:wikidiff2:1.12:old-3728:rev-3729:1.14.1 -->
</table>
Shen
http://202.127.29.3/~shen/wiki/index.php?title=Mysql&diff=3728&oldid=prev
Shen：/* sql语言 */
2022-02-07T07:15:47Z
<p><span dir="auto"><span class="autocomment">sql语言</span></span></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="zh-Hans-CN">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">←上一版本</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">2022年2月7日 (一) 07:15的版本</td>
</tr><tr>
<td colspan="2" class="diff-lineno">第46行：</td>
<td colspan="2" class="diff-lineno">第46行：</td>
</tr>
<tr>
<td class="diff-marker"></td>
<td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>*字符串的处理："hello,"|| "world" 就是 hello，world，还有substr(),instr()等命令</div></td>
<td class="diff-marker"></td>
<td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>*字符串的处理："hello,"|| "world" 就是 hello，world，还有substr(),instr()等命令</div></td>
</tr>
<tr>
<td class="diff-marker"></td>
<td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>*有一些命令可以直接处理所有记录，如max，sum等,count,distinct</div></td>
<td class="diff-marker"></td>
<td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>*有一些命令可以直接处理所有记录，如max，sum等,count,distinct</div></td>
</tr>
<tr>
<td colspan="2" class="diff-empty diff-side-deleted"></td>
<td class="diff-marker" data-marker="+"></td>
<td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>*group 处理部分选择的row</div></td>
</tr>
<!-- diff cache key wikidb2:diff:wikidiff2:1.12:old-3727:rev-3728:1.14.1 -->
</table>
Shen
http://202.127.29.3/~shen/wiki/index.php?title=Mysql&diff=3727&oldid=prev
Shen：/* sql语言 */
2022-02-07T06:59:02Z
<p><span dir="auto"><span class="autocomment">sql语言</span></span></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="zh-Hans-CN">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">←上一版本</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">2022年2月7日 (一) 06:59的版本</td>
</tr><tr>
<td colspan="2" class="diff-lineno">第45行：</td>
<td colspan="2" class="diff-lineno">第45行：</td>
</tr>
<tr>
<td class="diff-marker"></td>
<td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>*[expression]可以有各种运算符：如+,-,*,/,%,and,or,abs,round,not,<,<=,>,>=,<>,!= 等</div></td>
<td class="diff-marker"></td>
<td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>*[expression]可以有各种运算符：如+,-,*,/,%,and,or,abs,round,not,<,<=,>,>=,<>,!= 等</div></td>
</tr>
<tr>
<td class="diff-marker"></td>
<td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>*字符串的处理："hello,"|| "world" 就是 hello，world，还有substr(),instr()等命令</div></td>
<td class="diff-marker"></td>
<td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>*字符串的处理："hello,"|| "world" 就是 hello，world，还有substr(),instr()等命令</div></td>
</tr>
<tr>
<td class="diff-marker" data-marker="−"></td>
<td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>*有一些命令可以直接处理所有记录，如max，sum等</div></td>
<td class="diff-marker" data-marker="+"></td>
<td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>*有一些命令可以直接处理所有记录，如max，sum等<ins style="font-weight: bold; text-decoration: none;">,count,distinct</ins></div></td>
</tr>
<!-- diff cache key wikidb2:diff:wikidiff2:1.12:old-3726:rev-3727:1.14.1 -->
</table>
Shen
http://202.127.29.3/~shen/wiki/index.php?title=Mysql&diff=3726&oldid=prev
Shen：/* sql语言 */
2022-02-07T06:58:28Z
<p><span dir="auto"><span class="autocomment">sql语言</span></span></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="zh-Hans-CN">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">←上一版本</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">2022年2月7日 (一) 06:58的版本</td>
</tr><tr>
<td colspan="2" class="diff-lineno">第43行：</td>
<td colspan="2" class="diff-lineno">第43行：</td>
</tr>
<tr>
<td class="diff-marker"></td>
<td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>*select [columns] from [table1],[table2]</div></td>
<td class="diff-marker"></td>
<td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>*select [columns] from [table1],[table2]</div></td>
</tr>
<tr>
<td class="diff-marker"></td>
<td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>:自动将两个table结合起来，记录数会变为N1*N2，如果两个表有相同的column名字，那么可以用table.column来区分</div></td>
<td class="diff-marker"></td>
<td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>:自动将两个table结合起来，记录数会变为N1*N2，如果两个表有相同的column名字，那么可以用table.column来区分</div></td>
</tr>
<tr>
<td class="diff-marker" data-marker="−"></td>
<td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>*[expression]可以有各种运算符：如+-*/<del style="font-weight: bold; text-decoration: none;"> </del>%<del style="font-weight: bold; text-decoration: none;"> </del>and<del style="font-weight: bold; text-decoration: none;"> </del>or<del style="font-weight: bold; text-decoration: none;"> </del>abs<del style="font-weight: bold; text-decoration: none;"> </del>round<del style="font-weight: bold; text-decoration: none;"> </del>not<del style="font-weight: bold; text-decoration: none;"> </del><<del style="font-weight: bold; text-decoration: none;"> </del><=<del style="font-weight: bold; text-decoration: none;"> </del>><del style="font-weight: bold; text-decoration: none;"> </del>>=<del style="font-weight: bold; text-decoration: none;"> </del>!= 等</div></td>
<td class="diff-marker" data-marker="+"></td>
<td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>*[expression]可以有各种运算符：如+<ins style="font-weight: bold; text-decoration: none;">,</ins>-<ins style="font-weight: bold; text-decoration: none;">,</ins>*<ins style="font-weight: bold; text-decoration: none;">,</ins>/<ins style="font-weight: bold; text-decoration: none;">,</ins>%<ins style="font-weight: bold; text-decoration: none;">,</ins>and<ins style="font-weight: bold; text-decoration: none;">,</ins>or<ins style="font-weight: bold; text-decoration: none;">,</ins>abs<ins style="font-weight: bold; text-decoration: none;">,</ins>round<ins style="font-weight: bold; text-decoration: none;">,</ins>not<ins style="font-weight: bold; text-decoration: none;">,</ins><<ins style="font-weight: bold; text-decoration: none;">,</ins><=<ins style="font-weight: bold; text-decoration: none;">,</ins>><ins style="font-weight: bold; text-decoration: none;">,</ins>>=<ins style="font-weight: bold; text-decoration: none;">,<>,</ins>!= 等</div></td>
</tr>
<tr>
<td class="diff-marker"></td>
<td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>*字符串的处理："hello,"|| "world" 就是 hello，world，还有substr(),instr()等命令</div></td>
<td class="diff-marker"></td>
<td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>*字符串的处理："hello,"|| "world" 就是 hello，world，还有substr(),instr()等命令</div></td>
</tr>
<tr>
<td class="diff-marker"></td>
<td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>*有一些命令可以直接处理所有记录，如max，sum等</div></td>
<td class="diff-marker"></td>
<td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>*有一些命令可以直接处理所有记录，如max，sum等</div></td>
</tr>
<!-- diff cache key wikidb2:diff:wikidiff2:1.12:old-3725:rev-3726:1.14.1 -->
</table>
Shen
http://202.127.29.3/~shen/wiki/index.php?title=Mysql&diff=3725&oldid=prev
Shen：/* sql语言 */
2022-02-07T06:56:43Z
<p><span dir="auto"><span class="autocomment">sql语言</span></span></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="zh-Hans-CN">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">←上一版本</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">2022年2月7日 (一) 06:56的版本</td>
</tr><tr>
<td colspan="2" class="diff-lineno">第45行：</td>
<td colspan="2" class="diff-lineno">第45行：</td>
</tr>
<tr>
<td class="diff-marker"></td>
<td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>*[expression]可以有各种运算符：如+-*/ % and or abs round not < <= > >= != 等</div></td>
<td class="diff-marker"></td>
<td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>*[expression]可以有各种运算符：如+-*/ % and or abs round not < <= > >= != 等</div></td>
</tr>
<tr>
<td class="diff-marker"></td>
<td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>*字符串的处理："hello,"|| "world" 就是 hello，world，还有substr(),instr()等命令</div></td>
<td class="diff-marker"></td>
<td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>*字符串的处理："hello,"|| "world" 就是 hello，world，还有substr(),instr()等命令</div></td>
</tr>
<tr>
<td colspan="2" class="diff-empty diff-side-deleted"></td>
<td class="diff-marker" data-marker="+"></td>
<td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>*有一些命令可以直接处理所有记录，如max，sum等</div></td>
</tr>
<!-- diff cache key wikidb2:diff:wikidiff2:1.12:old-3724:rev-3725:1.14.1 -->
</table>
Shen
http://202.127.29.3/~shen/wiki/index.php?title=Mysql&diff=3724&oldid=prev
Shen：/* sql语言 */
2022-02-07T06:46:41Z
<p><span dir="auto"><span class="autocomment">sql语言</span></span></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="zh-Hans-CN">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">←上一版本</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">2022年2月7日 (一) 06:46的版本</td>
</tr><tr>
<td colspan="2" class="diff-lineno">第44行：</td>
<td colspan="2" class="diff-lineno">第44行：</td>
</tr>
<tr>
<td class="diff-marker"></td>
<td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>:自动将两个table结合起来，记录数会变为N1*N2，如果两个表有相同的column名字，那么可以用table.column来区分</div></td>
<td class="diff-marker"></td>
<td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>:自动将两个table结合起来，记录数会变为N1*N2，如果两个表有相同的column名字，那么可以用table.column来区分</div></td>
</tr>
<tr>
<td class="diff-marker"></td>
<td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>*[expression]可以有各种运算符：如+-*/ % and or abs round not < <= > >= != 等</div></td>
<td class="diff-marker"></td>
<td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>*[expression]可以有各种运算符：如+-*/ % and or abs round not < <= > >= != 等</div></td>
</tr>
<tr>
<td class="diff-marker" data-marker="−"></td>
<td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>*<del style="font-weight: bold; text-decoration: none;"> </del>"hello,"|| "world" 就是 <del style="font-weight: bold; text-decoration: none;">hello，world</del></div></td>
<td class="diff-marker" data-marker="+"></td>
<td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>*<ins style="font-weight: bold; text-decoration: none;">字符串的处理：</ins>"hello,"|| "world" 就是 <ins style="font-weight: bold; text-decoration: none;">hello，world，还有substr(),instr()等命令</ins></div></td>
</tr>
<!-- diff cache key wikidb2:diff:wikidiff2:1.12:old-3723:rev-3724:1.14.1 -->
</table>
Shen