리자

테이블의 컬럼을 상세하게 조회하기 show full columns from table;

show full columns from table;

mysql 5.x 에서는 Collation (charset) 이 나온다 필드별로...

mysql> show full columns from g4_member;
+-------------------+--------------+-----------------+------+-----+---------------------+----------------+---------------------------------+---------+
| Field             | Type         | Collation       | Null | Key | Default             | Extra          | Privileges                      | Comment |
+-------------------+--------------+-----------------+------+-----+---------------------+----------------+---------------------------------+---------+
| mb_no             | int(11)      | NULL            |      | PRI | NULL                | auto_increment | select,insert,update,references |         |
| mb_id             | varchar(255) | utf8_general_ci |      | UNI |                     |                | select,insert,update,references |         |
| mb_password       | varchar(255) | utf8_general_ci |      |     |                     |                | select,insert,update,references |         |
| mb_name           | varchar(255) | utf8_general_ci |      |     |                     |                | select,insert,update,references |         |
| mb_nick           | varchar(255) | utf8_general_ci |      |     |                     |                | select,insert,update,references |         |
| mb_nick_date      | date         | NULL            |      |     | 0000-00-00          |                | select,insert,update,references |         |
| mb_email          | varchar(255) | utf8_general_ci |      |     |                     |                | select,insert,update,references |         |
| mb_homepage       | varchar(255) | utf8_general_ci |      |     |                     |                | select,insert,update,references |         |
| mb_password_q     | varchar(255) | utf8_general_ci |      |     |                     |                | select,insert,update,references |         |
| mb_password_a     | varchar(255) | utf8_general_ci |      |     |                     |                | select,insert,update,references |         |
| mb_level          | tinyint(4)   | NULL            |      |     | 0                   |                | select,insert,update,references |         |
| mb_jumin          | varchar(255) | utf8_general_ci |      |     |                     |                | select,insert,update,references |         |
| mb_sex            | char(1)      | utf8_general_ci |      |     |                     |                | select,insert,update,references |         |
| mb_birth          | varchar(255) | utf8_general_ci |      |     |                     |                | select,insert,update,references |         |
| mb_tel            | varchar(255) | utf8_general_ci |      |     |                     |                | select,insert,update,references |         |
| mb_hp             | varchar(255) | utf8_general_ci |      |     |                     |                | select,insert,update,references |         |
| mb_zip1           | varchar(3)   | utf8_general_ci |      |     |                     |                | select,insert,update,references |         |
| mb_zip2           | varchar(3)   | utf8_general_ci |      |     |                     |                | select,insert,update,references |         |
| mb_addr1          | varchar(255) | utf8_general_ci |      |     |                     |                | select,insert,update,references |         |
| mb_addr2          | varchar(255) | utf8_general_ci |      |     |                     |                | select,insert,update,references |         |
| mb_signature      | text         | utf8_general_ci |      |     |                     |                | select,insert,update,references |         |
| mb_recommend      | varchar(255) | utf8_general_ci |      |     |                     |                | select,insert,update,references |         |
| mb_point          | int(11)      | NULL            |      |     | 0                   |                | select,insert,update,references |         |
| mb_today_login    | datetime     | NULL            |      | MUL | 0000-00-00 00:00:00 |                | select,insert,update,references |         |
| mb_login_ip       | varchar(255) | utf8_general_ci |      |     |                     |                | select,insert,update,references |         |
| mb_datetime       | datetime     | NULL            |      | MUL | 0000-00-00 00:00:00 |                | select,insert,update,references |         |
| mb_ip             | varchar(255) | utf8_general_ci |      |     |                     |                | select,insert,update,references |         |
| mb_leave_date     | varchar(8)   | utf8_general_ci |      |     |                     |                | select,insert,update,references |         |
| mb_intercept_date | varchar(8)   | utf8_general_ci |      |     |                     |                | select,insert,update,references |         |
| mb_email_certify  | datetime     | NULL            |      |     | 0000-00-00 00:00:00 |                | select,insert,update,references |         |
| mb_memo           | text         | utf8_general_ci |      |     |                     |                | select,insert,update,references |         |
| mb_mailling       | tinyint(4)   | NULL            |      |     | 0                   |                | select,insert,update,references |         |
| mb_sms            | tinyint(4)   | NULL            |      |     | 0                   |                | select,insert,update,references |         |
| mb_open           | tinyint(4)   | NULL            |      |     | 0                   |                | select,insert,update,references |         |
| mb_open_date      | date         | NULL            |      |     | 0000-00-00          |                | select,insert,update,references |         |
| mb_profile        | text         | utf8_general_ci |      |     |                     |                | select,insert,update,references |         |
| mb_memo_call      | varchar(255) | utf8_general_ci |      |     |                     |                | select,insert,update,references |         |
| mb_1              | varchar(255) | utf8_general_ci |      |     |                     |                | select,insert,update,references |         |
| mb_2              | varchar(255) | utf8_general_ci |      |     |                     |                | select,insert,update,references |         |
| mb_3              | varchar(255) | utf8_general_ci |      |     |                     |                | select,insert,update,references |         |
| mb_4              | varchar(255) | utf8_general_ci |      |     |                     |                | select,insert,update,references |         |
| mb_5              | varchar(255) | utf8_general_ci |      |     |                     |                | select,insert,update,references |         |
| mb_6              | varchar(255) | utf8_general_ci |      |     |                     |                | select,insert,update,references |         |
| mb_7              | varchar(255) | utf8_general_ci |      |     |                     |                | select,insert,update,references |         |
| mb_8              | varchar(255) | utf8_general_ci |      |     |                     |                | select,insert,update,references |         |
| mb_9              | varchar(255) | utf8_general_ci |      |     |                     |                | select,insert,update,references |         |
| mb_10             | varchar(255) | utf8_general_ci |      |     |                     |                | select,insert,update,references |         |
+-------------------+--------------+-----------------+------+-----+---------------------+----------------+---------------------------------+---------+
47 rows in set (0.00 sec)

mysql>

[이 게시물은 관리자님에 의해 2011-10-31 17:27:00 MySQL에서 이동 됨]

댓글 1개

혹시 이거를

$result= sql_query("show full columns from g4_member");

while(($rows = mysql_fetch_array($result)) == true){

eco $rows['field'].'<br>';
}

가능할까요??? ㅋㅋ;;;

작업하고 나서 디비스키마 달래거나, 디비구조도 달래면 항상 엑셀로 작업하는데 하루죙일 걸리는데,

이거는 디비구조도 나타낼때 좋겠네요.
댓글을 작성하시려면 로그인이 필요합니다.

프로그램

8,187건
+
제목 글쓴이 날짜 조회
07-07-16 조회 3,129
07-07-06 조회 3,022
07-07-06 조회 3,460
07-06-23 조회 3,283
07-06-16 조회 2,791
07-05-20 조회 4,308
07-05-09 조회 3,483
07-05-09 조회 6,129
07-05-04 조회 2,720
07-04-30 조회 9,857
07-04-27 조회 4,353
07-04-26 조회 3,470
07-04-25 조회 5,318
07-04-18 조회 7,808
07-04-13 조회 3,147
07-04-12 조회 6,654
07-04-12 조회 5,071
07-04-12 조회 3,385
07-04-11 조회 5,738
07-04-05 조회 6,379
07-03-24 조회 4,443
07-03-20 조회 3,764
07-03-18 조회 4,004
07-03-18 조회 4,750
07-03-17 조회 4,250
07-03-16 조회 4,150
07-03-15 조회 5,318
07-03-13 조회 5,418
07-03-13 조회 3,599
07-03-08 조회 4,516
07-03-08 조회 4,009
07-03-08 조회 3,315
07-03-08 조회 4,204
07-03-05 조회 4,459
07-03-04 조회 2,932
07-03-01 조회 5,961
07-02-28 조회 3,249
07-02-27 조회 4,433
07-02-26 조회 3,353
07-02-26 조회 3,064
07-02-23 조회 3,691
07-02-23 조회 3,660
07-02-22 조회 4,037
07-02-22 조회 3,858
07-02-19 조회 3,865
07-02-17 조회 4,885
07-02-14 조회 8,195
07-02-12 조회 3,958
07-02-10 조회 3,591
07-02-02 조회 3,828
07-01-31 조회 3,514
07-01-29 조회 3,370
07-01-25 조회 5,137
07-01-21 조회 3,281
07-01-19 조회 3,074
06-12-15 조회 4,091
06-12-15 조회 4,486
06-12-15 조회 2,979
06-12-15 조회 4,529
06-12-15 조회 3,407
06-12-15 조회 4,115
06-12-15 조회 3,072
06-12-15 조회 2,795
06-12-15 조회 4,648
06-12-15 조회 3,201
06-12-15 조회 3,308
06-12-07 조회 4,755
06-12-07 조회 4,034
06-12-04 조회 4,687
06-11-27 조회 3,726
06-11-21 조회 4,026
06-11-15 조회 3,466
06-11-04 조회 3,360
06-10-29 조회 4,014
06-10-13 조회 3,879
06-10-13 조회 4,241
06-10-13 조회 4,200
06-10-12 조회 5,391
06-10-12 조회 4,311
06-10-04 조회 3,803
06-10-02 조회 4,578
06-09-29 조회 3,065
06-09-26 조회 3,415
06-09-26 조회 3,673
06-09-26 조회 3,312
06-09-26 조회 3,464
06-09-26 조회 4,377
06-09-25 조회 4,670
06-09-22 조회 5,014
06-09-22 조회 3,577
06-09-21 조회 4,356
06-09-21 조회 4,359
06-09-21 조회 3,562
06-09-21 조회 5,215
06-09-21 조회 3,742
06-09-21 조회 3,474
06-09-20 조회 3,060
06-09-15 조회 3,187
06-09-13 조회 3,496
06-09-11 조회 3,299