이전
목록
다음
리자

테이블의 상태를 리스트로 확인하기

관리자
프로필 보기게시판 작성글 보기전체 작성글 보기전체 댓글 보기
 · 2010-10-21 (목) 12:02:22 · 2995
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 |
+-----------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------------+----------+----------------+---------+
| g4_auth | MyISAM | 9 | Dynamic | 0 | 0 | 0 | 4294967295 | 1024 | 0 | NULL | 2010-10-21 11:58:03 | 2010-10-21 11:58:03 | NULL | utf8_general_ci | NULL | | |
| g4_board | MyISAM | 9 | Dynamic | 0 | 0 | 0 | 4294967295 | 1024 | 0 | NULL | 2010-10-21 11:58:03 | 2010-10-21 11:58:03 | NULL | utf8_general_ci | NULL | | |
| g4_board_file | MyISAM | 9 | Dynamic | 0 | 0 | 0 | 4294967295 | 1024 | 0 | NULL | 2010-10-21 11:58:03 | 2010-10-21 11:58:03 | NULL | utf8_general_ci | NULL | | |
| g4_board_good | MyISAM | 9 | Dynamic | 0 | 0 | 0 | 4294967295 | 1024 | 0 | 1 | 2010-10-21 11:58:03 | 2010-10-21 11:58:03 | NULL | utf8_general_ci | NULL | | |
| g4_board_new | MyISAM | 9 | Dynamic | 0 | 0 | 0 | 4294967295 | 1024 | 0 | 1 | 2010-10-21 11:58:03 | 2010-10-21 11:58:03 | NULL | utf8_general_ci | NULL | | |
| g4_config | MyISAM | 9 | Dynamic | 1 | 1568 | 1568 | 4294967295 | 1024 | 0 | NULL | 2010-10-21 11:58:03 | 2010-10-21 11:58:04 | NULL | utf8_general_ci | NULL | | |
| g4_group | MyISAM | 9 | Dynamic | 0 | 0 | 0 | 4294967295 | 1024 | 0 | NULL | 2010-10-21 11:58:03 | 2010-10-21 11:58:03 | NULL | utf8_general_ci | NULL | | |
| g4_group_member | MyISAM | 9 | Dynamic | 0 | 0 | 0 | 4294967295 | 1024 | 0 | 1 | 2010-10-21 11:58:03 | 2010-10-21 11:58:03 | NULL | utf8_general_ci | NULL | | |
| g4_login | MyISAM | 9 | Dynamic | 1 | 64 | 64 | 4294967295 | 5120 | 0 | NULL | 2010-10-21 11:58:03 | 2010-10-21 11:58:10 | NULL | utf8_general_ci | NULL | | |
| g4_mail | MyISAM | 9 | Dynamic | 0 | 0 | 0 | 4294967295 | 1024 | 0 | 1 | 2010-10-21 11:58:03 | 2010-10-21 11:58:03 | NULL | utf8_general_ci | NULL | | |
| g4_member | MyISAM | 9 | Dynamic | 1 | 200 | 200 | 4294967295 | 8192 | 0 | 2 | 2010-10-21 11:58:03 | 2010-10-21 11:58:10 | NULL | utf8_general_ci | NULL | | |
| g4_memo | MyISAM | 9 | Dynamic | 0 | 0 | 0 | 4294967295 | 1024 | 0 | NULL | 2010-10-21 11:58:03 | 2010-10-21 11:58:03 | NULL | utf8_general_ci | NULL | | |
| g4_point | MyISAM | 9 | Dynamic | 1 | 76 | 76 | 4294967295 | 6144 | 0 | 2 | 2010-10-21 11:58:03 | 2010-10-21 11:58:10 | NULL | utf8_general_ci | NULL | | |
| g4_poll | MyISAM | 9 | Dynamic | 0 | 0 | 0 | 4294967295 | 1024 | 0 | 1 | 2010-10-21 11:58:03 | 2010-10-21 11:58:03 | NULL | utf8_general_ci | NULL | | |
| g4_poll_etc | MyISAM | 9 | Dynamic | 0 | 0 | 0 | 4294967295 | 1024 | 0 | NULL | 2010-10-21 11:58:03 | 2010-10-21 11:58:03 | NULL | utf8_general_ci | NULL | | |
| g4_popular | MyISAM | 9 | Dynamic | 0 | 0 | 0 | 4294967295 | 1024 | 0 | 1 | 2010-10-21 11:58:03 | 2010-10-21 11:58:03 | NULL | utf8_general_ci | NULL | | |
| g4_scrap | MyISAM | 9 | Dynamic | 0 | 0 | 0 | 4294967295 | 1024 | 0 | 1 | 2010-10-21 11:58:03 | 2010-10-21 11:58:03 | NULL | utf8_general_ci | NULL | | |
| g4_token | MyISAM | 9 | Dynamic | 0 | 0 | 0 | 4294967295 | 1024 | 0 | NULL | 2010-10-21 11:58:03 | 2010-10-21 11:58:03 | NULL | utf8_general_ci | NULL | | |
| g4_visit | MyISAM | 9 | Dynamic | 0 | 0 | 0 | 4294967295 | 1024 | 0 | NULL | 2010-10-21 11:58:03 | 2010-10-21 11:58:03 | NULL | utf8_general_ci | NULL | | |
| g4_visit_sum | MyISAM | 9 | Fixed | 0 | 0 | 0 | 34359738367 | 1024 | 0 | NULL | 2010-10-21 11:58:03 | 2010-10-21 11:58:03 | NULL | utf8_general_ci | NULL | | |
+-----------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------------+----------+----------------+---------+
20 rows in set (0.00 sec)<div class='small'>[이 게시물은 관리자님에 의해 2011-10-31 17:27:00 MySQL에서 이동 됨]</div>
#개발자팁 #개발자 #팁자료실 #mysql
글쓰기
댓글을 작성하시려면 로그인이 필요합니다.

프로그램

8,188건
태그 필터 (최대 3개) 전체 개발자 소스 기타 mysql 팁자료실 javascript php linux flash 정규표현식 jquery node.js mobile 웹서버 os 프로그램 강좌 썸네일 이미지관련 도로명주소 그누보드5 기획자 견적서 계약서 기획서 마케팅 제안서 seo 통계 서식 통계자료 퍼블리셔 html css 반응형 웹접근성 퍼블리싱 표준화 반응형웹 홈페이지기초 부트스트랩 angularjs 포럼 스크린리더 센스리더 개발자톡 개발자팁 퍼블리셔톡 퍼블리셔팁 기획자톡 기획자팁 프로그램강좌 퍼블리싱강좌
+
제목 글쓴이 날짜 조회
10-05-18 조회 2,993
10-05-15 조회 4,265
10-05-10 조회 2,947
10-04-29 조회 5,645
10-04-28 조회 3,851
10-04-17 조회 4,787
10-04-15 조회 3,241
10-04-04 조회 3,474
10-04-02 조회 2,763
10-03-23 조회 5,952
10-03-19 조회 5,493
10-03-05 조회 5,253
10-03-01 조회 6,916
10-02-27 조회 5,083
10-02-26 조회 3,478
10-02-23 조회 3,428
10-02-23 조회 3,583
10-02-19 조회 3,279
10-02-17 조회 5,695
10-02-17 조회 4,429
10-02-17 조회 3,848
10-02-12 조회 3,177
10-02-12 조회 3,514
10-02-12 조회 3,836
10-02-11 조회 2,967
10-02-11 조회 4,046
10-02-09 조회 3,337
10-02-09 조회 3,458
10-02-09 조회 3,170
10-02-09 조회 3,821
10-02-09 조회 3,097
10-02-09 조회 3,436
10-01-26 조회 3,556
10-01-25 조회 2,683
10-01-25 조회 2,786
10-01-23 조회 3,393
10-01-23 조회 6,899
10-01-20 조회 3,120
10-01-19 조회 3,597
10-01-13 조회 3,796
10-01-07 조회 2,989
10-01-07 조회 2,780
10-01-07 조회 3,736
10-01-07 조회 6,436
09-12-31 조회 3,743
09-12-27 조회 4,418
09-12-18 조회 3,218
09-12-14 조회 5,244
09-12-14 조회 6,126
09-12-06 조회 4,823
09-11-26 조회 3,746
09-11-24 조회 3,879
09-11-24 조회 4,297
09-11-23 조회 3,642
09-11-21 조회 7,005
09-11-20 조회 4,888
09-11-19 조회 2,804
09-11-19 조회 3,157
09-11-13 조회 6,636
09-11-11 조회 3,758
09-11-09 조회 4,783
09-11-09 조회 4,065
09-11-09 조회 2,954
09-11-04 조회 6,788
09-10-26 조회 3,922
09-10-10 조회 7,414
09-10-09 조회 3,432
09-10-08 조회 5,390
09-09-19 조회 4,463
09-09-15 조회 3,594
09-09-14 조회 3,625
09-09-11 조회 5,817
09-09-04 조회 4,862
09-08-31 조회 4,214
09-08-31 조회 4,412
09-08-30 조회 3,488
09-08-30 조회 3,240
09-08-30 조회 3,076
09-08-30 조회 2,759
09-08-30 조회 3,071
09-08-30 조회 3,302
09-08-30 조회 2,998
09-08-16 조회 6,335
09-08-14 조회 5,309
09-08-12 조회 3,253
09-08-12 조회 3,041
09-08-12 조회 3,756
09-07-24 조회 6,007
09-07-23 조회 5,063
09-07-22 조회 4,097
09-07-22 조회 5,725
09-07-22 조회 4,755
09-07-22 조회 2,891
09-07-21 조회 2,778
09-07-21 조회 3,410
09-07-19 조회 3,292
09-07-17 조회 4,018
09-07-17 조회 3,553
09-07-17 조회 2,823
09-07-15 조회 5,913
글쓰기