위키
포럼
도구
바뀐글
랜덤

MySQL 테이블 갱신일시 확인

MySQL 테이블 갱신일시 확인
MySQL 테이블 최근수정일시 확인
MySQL 테이블 업데이트 시간 확인

1 방법 1: information_schema.tables[ | ]

MySQL
Copy
SELECT UPDATE_TIME FROM INFORMATION_SCHEMA.TABLES
WHERE table_name='테이블명';
MySQL
Copy
SELECT UPDATE_TIME FROM INFORMATION_SCHEMA.TABLES
WHERE table_schema='디비명' AND table_name='테이블명';
Console
Copy
mysql> SELECT UPDATE_TIME FROM information_schema.tables WHERE TABLE_SCHEMA='zetadb' AND TABLE_NAME='wp_posts';
+---------------------+
| UPDATE_TIME         |
+---------------------+
| 2014-12-13 03:51:28 |
+---------------------+
1 row in set (0.00 sec)

2 방법 2: SHOW TABLE STATUS[ | ]

MySQL
Copy
SHOW TABLE STATUS LIKE '테이블명';
Console
Copy
mysql> SHOW TABLE STATUS LIKE 'wp_posts' \G
*************************** 1. row ***************************
           Name: wp_posts
         Engine: MyISAM
        Version: 10
     Row_format: Dynamic
           Rows: 4036
 Avg_row_length: 3754
    Data_length: 15154796
Max_data_length: 281474976710655
   Index_length: 428032
      Data_free: 0
 Auto_increment: NULL
    Create_time: 2014-12-13 03:51:26
    Update_time: 2014-12-13 03:51:28
     Check_time: 2015-07-02 15:52:18
      Collation: utf8_general_ci
       Checksum: NULL
 Create_options: 
        Comment: 
1 row in set (0.00 sec)

3 같이 보기[ | ]

4 참고[ | ]

원본 주소 "https://zetawiki.com/w/index.php?title=MySQL_테이블_갱신일시_확인&oldid=446314"