<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0">
  <channel>
    <title>生活随笔 - 数据库</title>
    <link>https://bbs.ssssss.site/forum.php?mod=forumdisplay&amp;fid=7</link>
    <description>Latest 20 threads of 数据库</description>
    <copyright>Copyright(C) 生活随笔</copyright>
    <generator>Discuz! Board by Comsenz Inc.</generator>
    <lastBuildDate>Tue, 10 Nov 2026 01:58:03 +0000</lastBuildDate>
    <ttl>60</ttl>
    <image>
      <url>https://bbs.ssssss.site/static/image/common/logo_88_31.gif</url>
      <title>生活随笔</title>
      <link>https://bbs.ssssss.site/</link>
    </image>
    <item>
      <title>alter table 更改表</title>
      <link>https://bbs.ssssss.site/forum.php?mod=viewthread&amp;tid=24</link>
      <description><![CDATA[alter table tb_name add [column] col_definition [first | after some_column];添加新字段

alter table tb_name add index [index_name] (index_col_name,...);
添加索引

alter table tb_name drop index index_name;
删除索引

alter table tb_name add primary ke ...]]></description>
      <category>数据库</category>
      <author>admin</author>
      <pubDate>Thu, 22 Oct 2026 13:23:56 +0000</pubDate>
    </item>
    <item>
      <title>复制表create table删除表drop table</title>
      <link>https://bbs.ssssss.site/forum.php?mod=viewthread&amp;tid=23</link>
      <description><![CDATA[create table [if not exists] tb_name2 like tb_name1;
使用该语法复制数据表时，将创建一个与源数据表相同结构的新表，该数据表的列名、数据类型空指定、索引都将被复制，但表的内容是不会复制的，即新创建的表是一张空表。


create table [if not exists] tb_name2  ...]]></description>
      <category>数据库</category>
      <author>admin</author>
      <pubDate>Thu, 22 Oct 2026 13:23:33 +0000</pubDate>
    </item>
    <item>
      <title>mysql运算符和流程控制</title>
      <link>https://bbs.ssssss.site/forum.php?mod=viewthread&amp;tid=22</link>
      <description><![CDATA[1、算术运算符
+、-、*、/、%、DIV、MOD，DIV和MOD只有2个参数，进行除尘和求余时，后面参数为0时，结果为NULL。


2、比较运算符
=、&gt;、=、]]></description>
      <category>数据库</category>
      <author>admin</author>
      <pubDate>Thu, 22 Oct 2026 13:23:07 +0000</pubDate>
    </item>
    <item>
      <title>load data local infile加载文本文件到表</title>
      <link>https://bbs.ssssss.site/forum.php?mod=viewthread&amp;tid=21</link>
      <description><![CDATA[load data local infile \'file_path\' into table tb_name line terminated by \'\\r\\n\';
文本文件每行一个记录，字段间用TAB隔开，\'\\r\\n\'为导入windows format txtfile时需要]]></description>
      <category>数据库</category>
      <author>admin</author>
      <pubDate>Thu, 22 Oct 2026 13:22:49 +0000</pubDate>
    </item>
    <item>
      <title>character-set-client-handshake=false</title>
      <link>https://bbs.ssssss.site/forum.php?mod=viewthread&amp;tid=20</link>
      <description><![CDATA[[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld un]]></description>
      <category>数据库</category>
      <author>admin</author>
      <pubDate>Thu, 22 Oct 2026 13:22:16 +0000</pubDate>
    </item>
  </channel>
</rss>