溫馨提示×

溫馨提示×

您好,登錄后才能下訂單哦!

密碼登錄×
登錄注冊×
其他方式登錄
點擊 登錄注冊 即表示同意《億速云用戶服務條款》

mysql舉例分析

發布時間:2020-04-26 15:27:58 來源:億速云 閱讀:247 作者:三月 欄目:MySQL數據庫

下文內容主要給大家帶來mysql舉例分析,這里所講到的知識,與書籍略有不同,都是億速云專業技術人員在與用戶接觸過程中,總結出來的,具有一定的經驗分享價值,希望給廣大讀者帶來幫助。 

mysql安裝不介紹,mysql -uroot -p
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| test               |
+--------------------+
4 rows in set (0.02 sec)
創建表
mysql> create database publications;
Query OK, 1 row affected (0.00 sec)
查看表并使用
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| publications       |
| test               |
+--------------------+
5 rows in set (0.00 sec)

mysql> use publications;
Database changed
創建數據庫管理用戶
mysql> *grant all on publications. to 'huang'@'localhost' identified by "123456";
Query OK, 0 rows affected (0.00 sec)
更新權限
mysql>
flush privileges;
Query OK, 0 rows affected (0.00 sec)
創建表 查看表

mysql舉例分析

mysql> create table classics(author varchar(128), title varchar(128), type varchar(16), year char(4));**
Query OK, 0 rows affected (0.01 sec)

mysql> desc classics;
+--------+--------------+------+-----+---------+-------+
| Field  | Type         | Null | Key | Default | Extra |
+--------+--------------+------+-----+---------+-------+
| author | varchar(128) | YES  |     | NULL    |       |
| title  | varchar(128) | YES  |     | NULL    |       |
| type   | varchar(16)  | YES  |     | NULL    |       |
| year   | char(4)      | YES  |     | NULL    |       |
+--------+--------------+------+-----+---------+-------+
4 rows in set (0.00 sec)
刪除表
mysql> drop table classics;
Query OK, 0 rows affected (0.00 sec)

再次創建表,增加id選項
mysql> create table classics(author varchar(128), title varchar(128), type varchar(16), year char(4),id INT unsigned not null auto_increment key)ENGINE MyISAM;
Query OK, 0 rows affected (0.01 sec)
刪除id選項
mysql> alter table classics drop id;
Query OK, 0 rows affected (0.00 sec)
Records: 0  Duplicates: 0  Warnings: 0

表中插入數據
mysql> insert into classics(author,title,type,year)
-> values("mark twain","muguangzhicheng",'fiction',"1876");

Query OK, 1 row affected (0.00 sec)

mysql> insert into classics(author,title,type,year) values("frank hello","xianglongshibazhang",'fiction',"1856");
Query OK, 1 row affected (0.00 sec)

mysql> insert into classics(author,title,type,year) values("world go","shgendiaoxialv",'play',"1841");
Query OK, 1 row affected (0.00 sec)

mysql> insert into classics(author,title,type,year) values("nale","xiakexing",'play',"1541");
Query OK, 1 row affected (0.00 sec)

mysql> select * from classics;
+-------------+---------------------+---------+------+
| author      | title               | type    | year |
+-------------+---------------------+---------+------+
| mark twain  | muguangzhicheng     | fiction | 1876 |
| frank hello | xianglongshibazhang | fiction | 1856 |
| world go    | shgendiaoxialv      | play    | 1841 |
| nale        | xiakexing           | play    | 1541 |
+-------------+---------------------+---------+------+
4 rows in set (0.00 sec)

更改表名稱
mysql> alter table classics rename pre1900;
Query OK, 0 rows affected (0.00 sec)

mysql> show tables;
+------------------------+
| Tables_in_publications |
+------------------------+
| pre1900                |
+------------------------+
1 row in set (0.00 sec)

對于以上關于mysql舉例分析,如果大家還有更多需要了解的可以持續關注我們億速云的行業推新,如需獲取專業解答,可在官網聯系售前售后的,希望該文章可給大家帶來一定的知識更新。

向AI問一下細節

免責聲明:本站發布的內容(圖片、視頻和文字)以原創、轉載和分享為主,文章觀點不代表本網站立場,如果涉及侵權請聯系站長郵箱:is@yisu.com進行舉報,并提供相關證據,一經查實,將立刻刪除涉嫌侵權內容。

AI

亚洲午夜精品一区二区_中文无码日韩欧免_久久香蕉精品视频_欧美主播一区二区三区美女