中文亚洲精品无码_熟女乱子伦免费_人人超碰人人爱国产_亚洲熟妇女综合网

當(dāng)前位置： 首頁 > news >正文

東莞做網(wǎng)站制作珠海網(wǎng)站建設(shè)

news 2025/7/13 13:16:33
東莞做網(wǎng)站制作,珠海網(wǎng)站建設(shè),網(wǎng)站雙鏈接怎么做,公司網(wǎng)站數(shù)據(jù)庫表設(shè)計(jì)MySQL查詢1 MySQL查詢2 表管理 #1. 建庫#1）庫名命名規(guī)則僅可以使用數(shù)字、字母、下劃線、不能純數(shù)字，區(qū)分字母大小寫，具有唯一性，不可使用MySQL命令或特殊字符#創(chuàng)建數(shù)據(jù)表時(shí)可以查看一下默認(rèn)的字符集，8.0后創(chuàng)建數(shù)據(jù)庫…

MySQL查詢1 MySQL查詢2

表管理

#1. 建庫#1）庫名命名規(guī)則僅可以使用數(shù)字、字母、下劃線、不能純數(shù)字，區(qū)分字母大小寫，具有唯一性，不可使用MySQL命令或特殊字符#創(chuàng)建數(shù)據(jù)表時(shí)可以查看一下默認(rèn)的字符集，8.0后創(chuàng)建數(shù)據(jù)庫和表時(shí)默認(rèn)字符集utf8mb4,5.7之前使用的是latin1，數(shù)據(jù)庫默認(rèn)編碼不設(shè)置的話會(huì)使用server的字符集，
mysql> show variables like '%char%';
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8mb4                    |
| character_set_connection | utf8mb4                    |
| character_set_database   | utf8mb4                    |
| character_set_filesystem | binary                     |
| character_set_results    | utf8mb4                    |
| character_set_server     | utf8mb4                    |
| character_set_system     | utf8mb3                    |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)//庫名區(qū)分字母大小寫
mysql> create database gamedb ;
Query OK, 1 row affected (0.14 sec)
mysql> create database GAMEDB ;
Query OK, 1 row affected (0.08 sec)
mysql> create database GAMEDB ;  
ERROR 1007 (HY000): Can't create database 'GAMEDB'; database exists //重名報(bào)錯(cuò)
//加if not exists 命令避免重名報(bào)錯(cuò)
mysql> create database  if not exists  gamedb ;  
Query OK, 1 row affected, 1 warning (0.03 sec) //正常
mysql> show  databases; //查看創(chuàng)建的庫
+--------------------+
| Database           |
+--------------------+
| GAMEDB             |
| gamedb             |
| information_schema |
| mysql              |
| performance_schema |
| sys                |
| tarena             |
+--------------------+
7 rows in set (0.00 sec)
mysql> drop database gamedb;  //刪除庫
Query OK, 0 rows affected (0.11 sec)
mysql> drop database gamedb; // 刪除沒有的庫報(bào)錯(cuò)
ERROR 1008 (HY000): Can’t drop database ‘gamedb’; database doesn’t exist
//加if exists 刪除沒有的庫，也不報(bào)錯(cuò)
mysql> drop database if exists gamedb;
Query OK, 0 rows affected, 1 warning (0.00 sec)
# 查看建庫語句
mysql> create database studb;
Query OK, 1 row affected (0.10 sec)mysql> use studb;
Database changed
mysql> show create database studb;
+----------+-----------------------------------------------------------------------------------------------------------------------------------+
| Database | Create Database                                                                                                                   |
+----------+-----------------------------------------------------------------------------------------------------------------------------------+
| student  | CREATE DATABASE `studb` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */ |
+----------+-----------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
#2. 建表
mysql> create table stuinfo(name char(10),grade char(9),sex char(4),age int);
Query OK, 0 rows affected (0.94 sec)
#查看建表語句，COLLATE表示排序規(guī)則
mysql> show create table stuinfo;
+---------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table   | Create Table                                                                                                                                                                                                       |
+---------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| stuinfo | CREATE TABLE `stuinfo` (`name` char(10) DEFAULT NULL,`grade` char(9) DEFAULT NULL,`sex` char(4) DEFAULT NULL,`age` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
+---------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
# 查看表結(jié)構(gòu)信息
mysql> desc stuinfo;
+-------+----------+------+-----+---------+-------+
| Field | Type     | Null | Key | Default | Extra |
+-------+----------+------+-----+---------+-------+
| name  | char(10) | YES  |     | NULL    |       |
| grade | char(9)  | YES  |     | NULL    |       |
| sex   | char(4)  | YES  |     | NULL    |       |
| age   | int      | YES  |     | NULL    |       |
+-------+----------+------+-----+---------+-------+
4 rows in set (0.00 sec)
# 刪除表
mysql> drop table stuinfo;
Query OK, 0 rows affected (0.37 sec)
# 刪除庫
mysql> drop database student;
Query OK, 0 rows affected (0.18 sec)
#3. 修改表# 修改表名
mysql> alter table studb.stuinfo rename studb.student;
Query OK, 0 rows affected (0.31 sec)
# 查看數(shù)據(jù)庫中包含哪些表
mysql> show tables;
+-----------------+
| Tables_in_studb |
+-----------------+
| student         |
+-----------------+
1 row in set (0.00 sec)
# 刪除age表頭
mysql> alter table studb.student drop age;
Query OK, 0 rows affected (0.84 sec)
Records: 0  Duplicates: 0  Warnings: 0mysql> desc studb.student;
+-------+----------+------+-----+---------+-------+
| Field | Type     | Null | Key | Default | Extra |
+-------+----------+------+-----+---------+-------+
| name  | char(10) | YES  |     | NULL    |       |
| grade | char(9)  | YES  |     | NULL    |       |
| sex   | char(4)  | YES  |     | NULL    |       |
+-------+----------+------+-----+---------+-------+
3 rows in set (0.00 sec)
# 添加表頭，默認(rèn)添加在末尾
mysql> alter table studb.student add mail char(30);
Query OK, 0 rows affected (0.30 sec)
Records: 0  Duplicates: 0  Warnings: 0mysql> desc studb.student;
+-------+----------+------+-----+---------+-------+
| Field | Type     | Null | Key | Default | Extra |
+-------+----------+------+-----+---------+-------+
| name  | char(10) | YES  |     | NULL    |       |
| grade | char(9)  | YES  |     | NULL    |       |
| sex   | char(4)  | YES  |     | NULL    |       |
| mail  | char(30) | YES  |     | NULL    |       |
+-------+----------+------+-----+---------+-------+
4 rows in set (0.00 sec)
# first指定添加列到行首，after 添加至指定表頭名的下方
mysql> alter table studb.student add number char(30) first ;
Query OK, 0 rows affected (0.79 sec)
Records: 0  Duplicates: 0  Warnings: 0mysql> desc studb.student;
+--------+----------+------+-----+---------+-------+
| Field  | Type     | Null | Key | Default | Extra |
+--------+----------+------+-----+---------+-------+
| number | char(30) | YES  |     | NULL    |       |
| name   | char(10) | YES  |     | NULL    |       |
| grade  | char(9)  | YES  |     | NULL    |       |
| sex    | char(4)  | YES  |     | NULL    |       |
| mail   | char(30) | YES  |     | NULL    |       |
+--------+----------+------+-----+---------+-------+
5 rows in set (0.00 sec)
mysql> alter table studb.student add num1 char(30) after sex ;
Query OK, 0 rows affected (1.21 sec)
Records: 0  Duplicates: 0  Warnings: 0mysql> desc studb.student;
+--------+----------+------+-----+---------+-------+
| Field  | Type     | Null | Key | Default | Extra |
+--------+----------+------+-----+---------+-------+
| number | char(30) | YES  |     | NULL    |       |
| name   | char(10) | YES  |     | NULL    |       |
| grade  | char(9)  | YES  |     | NULL    |       |
| sex    | char(4)  | YES  |     | NULL    |       |
| num1   | char(30) | YES  |     | NULL    |       |
| mail   | char(30) | YES  |     | NULL    |       |
+--------+----------+------+-----+---------+-------+
6 rows in set (0.00 sec)
# 修改表頭數(shù)據(jù)類型
mysql> alter table studb.student modify mail char(50);
Query OK, 0 rows affected (1.91 sec)
Records: 0  Duplicates: 0  Warnings: 0mysql> desc studb.student;
+--------+----------+------+-----+---------+-------+
| Field  | Type     | Null | Key | Default | Extra |
+--------+----------+------+-----+---------+-------+
| number | char(30) | YES  |     | NULL    |       |
| name   | char(10) | YES  |     | NULL    |       |
| grade  | char(9)  | YES  |     | NULL    |       |
| sex    | char(4)  | YES  |     | NULL    |       |
| num1   | char(30) | YES  |     | NULL    |       |
| mail   | char(50) | YES  |     | NULL    |       |
+--------+----------+------+-----+---------+-------+
6 rows in set (0.00 sec)
# 修改表頭名
mysql> alter table studb.student change mail 郵箱 char(50);
Query OK, 0 rows affected (0.19 sec)
Records: 0  Duplicates: 0  Warnings: 0mysql> desc studb.student;
+--------+----------+------+-----+---------+-------+
| Field  | Type     | Null | Key | Default | Extra |
+--------+----------+------+-----+---------+-------+
| number | char(30) | YES  |     | NULL    |       |
| name   | char(10) | YES  |     | NULL    |       |
| grade  | char(9)  | YES  |     | NULL    |       |
| sex    | char(4)  | YES  |     | NULL    |       |
| num1   | char(30) | YES  |     | NULL    |       |
| 郵箱   | char(50) | YES  |     | NULL    |       |
+--------+----------+------+-----+---------+-------+
6 rows in set (0.00 sec)
#刪除多個(gè)表頭
mysql> alter table studb.student drop num1,drop grade;
Query OK, 0 rows affected (0.86 sec)
Records: 0  Duplicates: 0  Warnings: 0mysql> desc studb.student;
+--------+----------+------+-----+---------+-------+
| Field  | Type     | Null | Key | Default | Extra |
+--------+----------+------+-----+---------+-------+
| number | char(30) | YES  |     | NULL    |       |
| name   | char(10) | YES  |     | NULL    |       |
| sex    | char(4)  | YES  |     | NULL    |       |
| 郵箱   | char(50) | YES  |     | NULL    |       |
+--------+----------+------+-----+---------+-------+
4 rows in set (0.00 sec)
# 通過modify修改表頭位置
mysql> alter table studb.student modify sex char(4) after number;
Query OK, 0 rows affected (1.53 sec)
Records: 0  Duplicates: 0  Warnings: 0mysql> desc studb.student;
+--------+----------+------+-----+---------+-------+
| Field  | Type     | Null | Key | Default | Extra |
+--------+----------+------+-----+---------+-------+
| number | char(30) | YES  |     | NULL    |       |
| sex    | char(4)  | YES  |     | NULL    |       |
| name   | char(10) | YES  |     | NULL    |       |
| 郵箱   | char(50) | YES  |     | NULL    |       |
+--------+----------+------+-----+---------+-------+
4 rows in set (0.00 sec)
# 復(fù)制表并將表內(nèi)數(shù)據(jù)復(fù)制過來
mysql> create table studb.departments select * from tarena.departments;
Query OK, 11 rows affected (0.73 sec)
Records: 11  Duplicates: 0  Warnings: 0mysql> desc studb.departments;
+-----------+-------------+------+-----+---------+-------+
| Field     | Type        | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| dept_id   | int         | NO   |     | 0       |       |
| dept_name | varchar(10) | YES  |     | NULL    |       |
+-----------+-------------+------+-----+---------+-------+
2 rows in set (0.00 sec)mysql> select count(*) from studb.departments;
+----------+
| count(*) |
+----------+
|       11 |
+----------+
1 row in set (0.00 sec)mysql> select count(*) from tarena.departments;
+----------+
| count(*) |
+----------+
|       11 |
+----------+
1 row in set (0.00 sec)

數(shù)據(jù)類型

# 1. 字符類型
mysql> create table studb.t2(name char(3),address varchar(5));
Query OK, 0 rows affected (0.68 sec)mysql> desc studb.t2;
+---------+------------+------+-----+---------+-------+
| Field   | Type       | Null | Key | Default | Extra |
+---------+------------+------+-----+---------+-------+
| name    | char(3)    | YES  |     | NULL    |       |
| address | varchar(5) | YES  |     | NULL    |       |
+---------+------------+------+-----+---------+-------+
2 rows in set (0.01 sec)
mysql> insert into studb.t2 values('a','a');
Query OK, 1 row affected (0.12 sec)
mysql> insert into studb.t2 values('abc','abc');
Query OK, 1 row affected (0.10 sec)
# name定義為char(3),只能存儲(chǔ)3個(gè)[字符]，所以報(bào)錯(cuò)數(shù)據(jù)太長了
mysql> insert into studb.t2 values('abcd','abcd');
ERROR 1406 (22001): Data too long for column 'name' at row 1
#mysql8.0使用了utf8mb4字符集，默認(rèn)支持中文
mysql> insert into studb.t2 values("張無忌","武當(dāng)山");
Query OK, 1 row affected (0.10 sec)
mysql> select * from studb.t2;
+-----------+-----------+
| name      | address   |
+-----------+-----------+
| a         | a         |
| ab        | ab        |
| abc       | abc       |
| 張無忌    | 武當(dāng)山    |
+-----------+-----------+
4 rows in set (0.00 sec)
# 2. 數(shù)值類型
mysql> create table studb.t1(name char(10),level tinyint unsigned,money double);
Query OK, 0 rows affected (0.59 sec)mysql> desc studb.t1;
+-------+------------------+------+-----+---------+-------+
| Field | Type             | Null | Key | Default | Extra |
+-------+------------------+------+-----+---------+-------+
| name  | char(10)         | YES  |     | NULL    |       |
| level | tinyint unsigned | YES  |     | NULL    |       |
| money | double           | YES  |     | NULL    |       |
+-------+------------------+------+-----+---------+-------+
3 rows in set (0.00 sec)
# tinyint unsigned表示無符號短整型，占用1個(gè)字節(jié)，只能存儲(chǔ)0-255的數(shù)字
mysql> insert into studb.t1 values("戰(zhàn)士",301,1.292);
ERROR 1264 (22003): Out of range value for column 'level' at row 1
mysql> insert into studb.t1 values("戰(zhàn)士",255,1.292);
Query OK, 1 row affected (0.10 sec)
#整型不能存儲(chǔ)不數(shù)，直接對小數(shù)進(jìn)行四舍五入
mysql> insert into studb.t1 values("英雄",1.222,1.292);
Query OK, 1 row affected (0.08 sec)mysql> select * from studb.t1;
+--------+-------+-------+
| name   | level | money |
+--------+-------+-------+
| 法師   |    80 |    88 |
| 戰(zhàn)士   |   255 | 1.292 |
| 英雄   |     1 | 1.292 |
+--------+-------+-------+
3 rows in set (0.00 sec)
# 3. 枚舉類型
mysql> create table studb.t8( name char(10),sex enum("男","女","保密"),hobby set("美女","吃","睡"));
Query OK, 0 rows affected (0.60 sec)mysql> desc studb.t8;
+-------+----------------------------+------+-----+---------+-------+
| Field | Type                       | Null | Key | Default | Extra |
+-------+----------------------------+------+-----+---------+-------+
| name  | char(10)                   | YES  |     | NULL    |       |
| sex   | enum('男','女','保密')     | YES  |     | NULL    |       |
| hobby | set('美女','吃','睡')      | YES  |     | NULL    |       |
+-------+----------------------------+------+-----+---------+-------+
3 rows in set (0.00 sec)
# enum類型的數(shù)據(jù)只能選擇其中一項(xiàng)，set類型的數(shù)據(jù)可以選擇其中多項(xiàng)
mysql> insert into studb.t8 values("小迪總","男人","美女,睡,金錢");
ERROR 1265 (01000): Data truncated for column 'sex' at row 1
mysql> insert into studb.t8 values("小迪總","男","美女,睡,金錢");
ERROR 1265 (01000): Data truncated for column 'hobby' at row 1
mysql> insert into studb.t8 values("小迪總","男","美女,睡,吃");
Query OK, 1 row affected (0.12 sec)
mysql> select * from studb.t8;
+-----------+------+----------------+
| name      | sex  | hobby          |
+-----------+------+----------------+
| 小迪總    | 男   | 美女,吃,睡     |
+-----------+------+----------------+
1 row in set (0.00 sec)
# 4. 日期時(shí)間
mysql> create table studb.t6(name char(10),birth date,year_birth year,homeparty datetime,partyaddress varchar(15),worktime time);
Query OK, 0 rows affected (1.22 sec)mysql> desc studb.t6;
+--------------+-------------+------+-----+---------+-------+
| Field        | Type        | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+-------+
| name         | char(10)    | YES  |     | NULL    |       |
| birth        | date        | YES  |     | NULL    |       |
| year_birth   | year        | YES  |     | NULL    |       |
| homeparty    | datetime    | YES  |     | NULL    |       |
| partyaddress | varchar(15) | YES  |     | NULL    |       |
| worktime     | time        | YES  |     | NULL    |       |
+--------------+-------------+------+-----+---------+-------+
6 rows in set (0.00 sec)
mysql> insert into studb.t6 values("小崔",19900101,1990,20230909090000,"鄭州",100000);
Query OK, 1 row affected (0.11 sec)mysql> select * from studb.t6;
+--------+------------+------------+---------------------+--------------+----------+
| name   | birth      | year_birth | homeparty           | partyaddress | worktime |
+--------+------------+------------+---------------------+--------------+----------+
| 小崔   | 1990-01-01 |       1990 | 2023-09-09 09:00:00 | 鄭州         | 10:00:00 |
+--------+------------+------------+---------------------+--------------+----------+
1 row in set (0.00 sec)

數(shù)據(jù)批量處理

# 1.修改檢索目錄為/myload
# 查看默認(rèn)檢索目錄
mysql> show variables like 'secure_file_priv';
+------------------+-----------------------+
| Variable_name    | Value                 |
+------------------+-----------------------+
| secure_file_priv | /var/lib/mysql-files/ |
+------------------+-----------------------+
1 row in set (0.00 sec)
# 此變量是只讀變量，只能修改mysql配置文件，在mysqld下面添加一行secure_file_priv=/myload,并創(chuàng)建/myload目錄，修改目錄屬主和屬組為mysql,否則重啟mysql服務(wù)時(shí)會(huì)報(bào)錯(cuò)
[root@mysql50 ~]# cat /etc/my.cnf.d/mysql-server.cnf 
[mysqld]
...
secure_file_priv=/myload
[root@mysql50 ~]# mkdir /myload
[root@mysql50 ~]# chown mysql.mysql /myload
[root@mysql50 ~]# systemctl restart mysqld
# 2.將/etc/passwd文件導(dǎo)入db1庫的user3表里，并添加行號字段
#創(chuàng)建庫和表
mysql> create database db1;
Query OK, 1 row affected (0.14 sec)
mysql> create table db1.user3(name varchar(30),password char(1),uid int ,gid int,comment varchar(200),homedir varchar(50),shell varchar(30));
Query OK, 0 rows affected (0.80 sec)mysql> desc db1.user3;
+----------+--------------+------+-----+---------+-------+
| Field    | Type         | Null | Key | Default | Extra |
+----------+--------------+------+-----+---------+-------+
| name     | varchar(30)  | YES  |     | NULL    |       |
| password | char(1)      | YES  |     | NULL    |       |
| uid      | int          | YES  |     | NULL    |       |
| gid      | int          | YES  |     | NULL    |       |
| comment  | varchar(200) | YES  |     | NULL    |       |
| homedir  | varchar(50)  | YES  |     | NULL    |       |
| shell    | varchar(30)  | YES  |     | NULL    |       |
+----------+--------------+------+-----+---------+-------+
7 rows in set (0.01 sec)
# 拷貝文件到檢索目錄 system 在MySQL里執(zhí)行系統(tǒng)命令
mysql> system cp /etc/passwd /myload/
mysql> system ls /myload
passwd
# 導(dǎo)入數(shù)據(jù)
mysql> load data infile "/myload/passwd" into table db1.user3 fields terminated by ":" lines terminated by "\n";
Query OK, 25 rows affected (0.13 sec)
Records: 25  Deleted: 0  Skipped: 0  Warnings: 0mysql> select * from db1.user3;
+------------------+----------+-------+-------+-----------------------------+------------------+----------------+
| name             | password | uid   | gid   | comment                     | homedir          | shell          |
+------------------+----------+-------+-------+-----------------------------+------------------+----------------+
| root             | x        |     0 |     0 | root                        | /root            | /bin/bash      |
| bin              | x        |     1 |     1 | bin                         | /bin             | /sbin/nologin  |
| daemon           | x        |     2 |     2 | daemon                      | /sbin            | /sbin/nologin  |
| adm              | x        |     3 |     4 | adm                         | /var/adm         | /sbin/nologin  |
| lp               | x        |     4 |     7 | lp                          | /var/spool/lpd   | /sbin/nologin  |
| sync             | x        |     5 |     0 | sync                        | /sbin            | /bin/sync      |
| shutdown         | x        |     6 |     0 | shutdown                    | /sbin            | /sbin/shutdown |
| halt             | x        |     7 |     0 | halt                        | /sbin            | /sbin/halt     |
| mail             | x        |     8 |    12 | mail                        | /var/spool/mail  | /sbin/nologin  |
| operator         | x        |    11 |     0 | operator                    | /root            | /sbin/nologin  |
| games            | x        |    12 |   100 | games                       | /usr/games       | /sbin/nologin  |
| ftp              | x        |    14 |    50 | FTP User                    | /var/ftp         | /sbin/nologin  |
| nobody           | x        | 65534 | 65534 | Kernel Overflow User        | /                | /sbin/nologin  |
| dbus             | x        |    81 |    81 | System message bus          | /                | /sbin/nologin  |
| systemd-coredump | x        |   999 |   997 | systemd Core Dumper         | /                | /sbin/nologin  |
| systemd-resolve  | x        |   193 |   193 | systemd Resolver            | /                | /sbin/nologin  |
| polkitd          | x        |   998 |   995 | User for polkitd            | /                | /sbin/nologin  |
| unbound          | x        |   997 |   994 | Unbound DNS resolver        | /etc/unbound     | /sbin/nologin  |
| tss              | x        |    59 |    59 | Account used for TPM access | /dev/null        | /sbin/nologin  |
| chrony           | x        |   996 |   993 |                             | /var/lib/chrony  | /sbin/nologin  |
| sshd             | x        |    74 |    74 | Privilege-separated SSH     | /var/empty/sshd  | /sbin/nologin  |
| tcpdump          | x        |    72 |    72 |                             | /                | /sbin/nologin  |
| mysql            | x        |    27 |    27 | MySQL Server                | /var/lib/mysql   | /sbin/nologin  |
| apache           | x        |    48 |    48 | Apache                      | /usr/share/httpd | /sbin/nologin  |
| nginx            | x        |   995 |   992 | Nginx web server            | /var/lib/nginx   | /sbin/nologin  |
+------------------+----------+-------+-------+-----------------------------+------------------+----------------+
25 rows in set (0.00 sec)
# 3.將db1庫user3表中所有記錄導(dǎo)出，存到/myload/user.txt中
mysql> select * from db1.user3 into outfile "/myload/user.txt";
Query OK, 25 rows affected (0.00 sec)mysql> system ls /myload
passwd  user.txt
mysql> system cat /myload/user.txt
root    x       0       0       root    /root   /bin/bash
bin     x       1       1       bin     /bin    /sbin/nologin
daemon  x       2       2       daemon  /sbin   /sbin/nologin
adm     x       3       4       adm     /var/adm        /sbin/nologin
lp      x       4       7       lp      /var/spool/lpd  /sbin/nologin
sync    x       5       0       sync    /sbin   /bin/sync
shutdown        x       6       0       shutdown        /sbin   /sbin/shutdown
halt    x       7       0       halt    /sbin   /sbin/halt
mail    x       8       12      mail    /var/spool/mail /sbin/nologin
operator        x       11      0       operator        /root   /sbin/nologin
games   x       12      100     games   /usr/games      /sbin/nologin
ftp     x       14      50      FTP User        /var/ftp        /sbin/nologin
nobody  x       65534   65534   Kernel Overflow User    /       /sbin/nologin
dbus    x       81      81      System message bus      /       /sbin/nologin
systemd-coredump        x       999     997     systemd Core Dumper     /       /sbin/nologin
systemd-resolve x       193     193     systemd Resolver        /       /sbin/nologin
polkitd x       998     995     User for polkitd        /       /sbin/nologin
unbound x       997     994     Unbound DNS resolver    /etc/unbound    /sbin/nologin
tss     x       59      59      Account used for TPM access     /dev/null       /sbin/nologin
chrony  x       996     993             /var/lib/chrony /sbin/nologin
sshd    x       74      74      Privilege-separated SSH /var/empty/sshd /sbin/nologin
tcpdump x       72      72              /       /sbin/nologin
mysql   x       27      27      MySQL Server    /var/lib/mysql  /sbin/nologin
apache  x       48      48      Apache  /usr/share/httpd        /sbin/nologin
nginx   x       995     992     Nginx web server        /var/lib/nginx  /sbin/nologin

表頭基本約束

約束是一種限制，設(shè)置在表頭上，用來控制表頭的賦值
- NOT NULL：非空，用于保證該字段的值不能為空
- DEFAULT：默認(rèn)值，用于保證該字段有默認(rèn)值
- UNIQUE：唯一索引，用于保證該字段的值具有唯一性，可為空
- PRIMARY KEY：主鍵，用于保證字段的值具有唯一性且非空
- FOREIGN KEY：外鍵，用于限制兩個(gè)表的關(guān)系，用于保證該字段的值必須來自于主表的關(guān)聯(lián)列的值，在從表中添加外鍵約束，用于引用主表中的某些的值# 1.表頭不允許賦空值練習(xí)
mysql> create table db1.t33(name char(10) not null,grade char(7) default "nsd",likes set("money","game","film","music") not null default "film,music");
Query OK, 0 rows affected (0.64 sec)mysql> desc db1.t33;
+-------+------------------------------------+------+-----+------------+-------+
| Field | Type                               | Null | Key | Default    | Extra |
+-------+------------------------------------+------+-----+------------+-------+
| name  | char(10)                           | NO   |     | NULL       |       |
| grade | char(7)                            | YES  |     | nsd        |       |
| likes | set('money','game','film','music') | NO   |     | film,music |       |
+-------+------------------------------------+------+-----+------------+-------+
3 rows in set (0.00 sec)# 驗(yàn)證默認(rèn)值和不允許為null
mysql> insert into db1.t33 values(null,null,null);
ERROR 1048 (23000): Column 'name' cannot be null
# 表頭likes賦null值，報(bào)錯(cuò)
mysql> insert into db1.t33 values("bob",null,null);
ERROR 1048 (23000): Column 'likes' cannot be null
# 符合約束條件不報(bào)錯(cuò)
mysql> insert into db1.t33 values("bob",null,"money,game,film");
Query OK, 1 row affected (0.09 sec)
mysql> insert into db1.t33(name) values("lucy");
Query OK, 1 row affected (0.12 sec)
mysql> insert into db1.t33 values("jim","nsd2018","game,film");
Query OK, 1 row affected (0.17 sec)
mysql> select * from db1.t33;
+------+---------+-----------------+
| name | grade   | likes           |
+------+---------+-----------------+
| bob  | NULL    | money,game,film |
| lucy | nsd     | film,music      |
| jim  | nsd2018 | game,film       |
+------+---------+-----------------+
3 rows in set (0.00 sec)
# 2.表頭加唯一索引練習(xí)
mysql> create table db1.t44(name char(10),passport char(18) unique);
Query OK, 0 rows affected (1.14 sec)mysql> desc db1.t44;
+----------+----------+------+-----+---------+-------+
| Field    | Type     | Null | Key | Default | Extra |
+----------+----------+------+-----+---------+-------+
| name     | char(10) | YES  |     | NULL    |       |
| passport | char(18) | YES  | UNI | NULL    |       |
+----------+----------+------+-----+---------+-------+
2 rows in set (0.01 sec)mysql> insert into db1.t44 values("bob",null);
Query OK, 1 row affected (0.13 sec)mysql> insert into db1.t44 values("tom","666888");
Query OK, 1 row affected (0.08 sec)
# 表頭值不可以重復(fù)
mysql> insert into db1.t44 values("jim","666888");
ERROR 1062 (23000): Duplicate entry '666888' for key 't44.passport'
mysql> insert into db1.t44 values("jim","766888");
Query OK, 1 row affected (0.16 sec)mysql> select * from db1.t44;
+------+----------+
| name | passport |
+------+----------+
| bob  | NULL     |
| tom  | 666888   |
| jim  | 766888   |
+------+----------+
3 rows in set (0.00 sec)
http://m.risenshineclean.com/news/61284.html

相關(guān)文章：

  • 綿陽做網(wǎng)站的有哪些百度指數(shù)支持?jǐn)?shù)據(jù)下載嗎
  • 高明網(wǎng)站建設(shè)最近一周新聞熱點(diǎn)回顧
  • 湖北網(wǎng)站開發(fā)網(wǎng)站多少錢
  • 門戶網(wǎng)站html模板參考網(wǎng)是合法網(wǎng)站嗎?
  • wordpress批量修改圖片標(biāo)題seo中文意思是
  • 網(wǎng)站都有什么費(fèi)用千鋒教育培訓(xùn)怎么樣
  • wordpress的文章分類班級優(yōu)化大師下載
  • 網(wǎng)站域名包括菏澤資深seo報(bào)價(jià)
  • 軟件界面設(shè)計(jì)工具下載刷seo快速排名
  • wordpress 插件太多seo長尾快速排名
  • 做畫冊好的國外網(wǎng)站推薦如何關(guān)閉2345網(wǎng)址導(dǎo)航
  • 現(xiàn)在的網(wǎng)站設(shè)計(jì)前端seo主要優(yōu)化哪些
  • 圖書館網(wǎng)站建設(shè)優(yōu)化合作平臺
  • 工業(yè)皮帶怎么做免費(fèi)的網(wǎng)站情感式軟文廣告
  • 天津房地產(chǎn)集團(tuán)網(wǎng)站建設(shè)地推接單正規(guī)平臺
  • 品牌網(wǎng)站建站公司如何推廣我的網(wǎng)站
  • 做poster的網(wǎng)站提升seo排名的方法
  • 做網(wǎng)站流量錢誰給深圳網(wǎng)絡(luò)優(yōu)化公司
  • 網(wǎng)站seo博客西安seo霸屏
  • wordpress如何設(shè)置網(wǎng)站描述小程序免費(fèi)制作平臺
  • 網(wǎng)站制作網(wǎng)站建設(shè)競價(jià)開戶
  • 手機(jī)做推廣比較好的網(wǎng)站關(guān)鍵詞排名怎么做上首頁
  • 找工作網(wǎng)站谷歌在線瀏覽入口
  • 自己做網(wǎng)站的過程搜索引擎seo是什么意思
  • 做商城網(wǎng)站需要備案嗎鄒平縣seo網(wǎng)頁優(yōu)化外包
  • 中山網(wǎng)站建設(shè)找丁生商城推廣軟文范文
  • 有效的網(wǎng)站建設(shè)百度怎么發(fā)布短視頻
  • 東營建筑信息網(wǎng)北京網(wǎng)絡(luò)seo經(jīng)理
  • wordpress 強(qiáng)制換行網(wǎng)站seo軟件
  • 學(xué)做課件的網(wǎng)站新媒體營銷推廣公司