資料結構
網路
RDBMS
作業系統
Java
MS Excel
iOS
HTML
CSS
Android
Python
C 程式設計
C++
C#
MongoDB
MySQL
Javascript
PHP
物理
化學
生物
數學
英語
經濟學
心理學
社會學
時尚研究
法律研究如何獲取 MySQL 中表的建立和更新日期？
利用 MySQL 中的 create_time 或 update_time 獲得表的準確建立和更新日期。
首先，使用 SHOW 命令。語法如下：
SHOW TABLE STATUS;
我們考慮使用我們的資料庫“test3”，該資料庫已經有一些表
mysql> use test3; Database changed
現在使用以下查詢顯示資料庫 test3 中的所有表
mysql> show tables;
以下是輸出
+-------------------------+ | Tables_in_test3 | +-------------------------+ | add6hour | | deletedemo | | differentdatetime | | fieldlessthan5chars | | lastrecordbeforelastone | | mostrecentdatedemo | | nullcasedemo | | order | | orderbydatethentimedemo | | posts | | productdemo | | radiansdemo | | siglequotesdemo | | studentinformation | | updatestringdemo | +-------------------------+ 15 rows in set (0.00 sec)
以下查詢是為了確定日期。這顯示了表格狀態
mysql> show table status;
以下輸出顯示錶格的全部狀態。藉助於此，我們還可以檢視我們需要的資訊，例如，表的建立和更新日期
+-------------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+--------------------+----------+----------------+---------+ | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length |Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment | +-------------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+--------------------+----------+----------------+---------+ | add6hour | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 0 |1 | 2019-02-14 18:33:27 | NULL | NULL | utf8mb4_0900_ai_ci | NULL | | | | deletedemo | InnoDB | 10 | Dynamic | 6 | 2730 | 16384 | 0 | 0 | 0 |NULL | 2019-02-13 19:20:04 | NULL | NULL | utf8mb4_0900_ai_ci | NULL | | | | differentdatetime | InnoDB | 10 | Dynamic | 4 | 4096 | 16384 | 0 | 0 | 0 |5 | 2019-02-14 10:26:28 | NULL | NULL | utf8mb4_0900_ai_ci | NULL | | | | fieldlessthan5chars | InnoDB | 10 | Dynamic | 8 | 2048 | 16384 | 0 | 0 | 0 |8 | 2019-02-13 19:03:05 | NULL | NULL | utf8mb4_0900_ai_ci | NULL | | | | lastrecordbeforelastone | InnoDB | 10 | Dynamic | 8 | 2048 | 16384 | 0 | 0 | 0 | 10 | 2019-02-14 17:31:59 | NULL | NULL | utf8mb4_0900_ai_ci | NULL | | | | mostrecentdatedemo | InnoDB | 10 | Dynamic | 6 | 2730 | 16384 | 0 | 0 |0 | 6 | 2019-02-14 17:15:53 | NULL | NULL | utf8mb4_0900_ai_ci | NULL | | | | nullcasedemo | InnoDB | 10 | Dynamic | 6 | 2730 | 16384 | 0 | 0 | 0 |NULL | 2019-02-14 17:55:39 | NULL | NULL | utf8mb4_0900_ai_ci | NULL | | | | order | InnoDB | 10 | Dynamic | 8 | 2048 | 16384 | 0 | 0 | 0 |NULL | 2019-02-14 14:23:38 | NULL | NULL | utf8mb4_0900_ai_ci | NULL | | | | orderbydatethentimedemo | InnoDB | 10 | Dynamic | 4 | 4096 | 16384 | 0 | 0 |0 | 5 | 2019-02-14 18:05:36 | NULL | NULL | utf8mb4_0900_ai_ci | NULL | | | | posts | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 32768 | 0 |NULL | 2019-02-13 18:19:06 | NULL | NULL | utf8mb4_0900_ai_ci | NULL | | | | productdemo | InnoDB | 10 | Dynamic | 4 | 4096 | 16384 | 0 | 0 | 0 |NULL | 2019-02-13 20:06:36 | NULL | NULL | utf8mb4_0900_ai_ci | NULL | | | | radiansdemo | InnoDB | 10 | Dynamic | 2 | 8192 | 16384 | 0 | 0 | 0 |3 | 2019-02-14 14:33:24 | NULL | NULL | utf8mb4_0900_ai_ci | NULL | | | | siglequotesdemo | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 0 |NULL | 2019-02-14 10:41:23 | NULL | NULL | utf8mb4_0900_ai_ci | NULL | | | | studentinformation | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 0 |NULL | 2019-02-14 17:06:07 | NULL | NULL | utf8mb4_0900_ai_ci | NULL | | | | updatestringdemo | InnoDB | 10 | Dynamic | 2 | 8192 | 16384 | 0 | 0 | 0 |3 | 2019-02-13 18:25:59 | NULL | NULL | utf8mb4_0900_ai_ci | NULL | | | +-------------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+--------------------+----------+----------------+---------+ 15 rows in set (0.72 sec)
更新日期：30-Jul-2019
168 次瀏覽
廣告