위키
포럼
도구
바뀐글
랜덤

"MySQL 컬럼 자료형 확인"의 두 판 사이의 차이

(새 문서: ;MySQL 컬럼 자료형 확인 ==방법: INFORMATION_SCHEMA== <source lang='cli'> mysql> SELECT DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='nt_user' AND COLU +------...)
 
잔글 (봇: 자동으로 텍스트 교체 (-== 참고 자료 == +==참고==))
 
(사용자 2명의 중간 판 11개는 보이지 않습니다)
1번째 줄: 1번째 줄:
;MySQL 컬럼 자료형 확인
;MySQL 컬럼 자료형 확인


==방법 1: SHOW COLUMNS==
<source lang='console'>
mysql> SHOW COLUMNS FROM `user` LIKE 'user_id';
+---------+------------------+------+-----+---------+----------------+
| Field  | Type            | Null | Key | Default | Extra          |
+---------+------------------+------+-----+---------+----------------+
| user_id | int(10) unsigned | NO  | PRI | NULL    | auto_increment |
+---------+------------------+------+-----+---------+----------------+
1 row in set (0.00 sec)
</source>


==방법: INFORMATION_SCHEMA==
==방법 2: information_schema==
<source lang='cli'>
<source lang='console'>
mysql> SELECT DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='nt_user' AND COLU
mysql> SELECT DATA_TYPE FROM information_schema.COLUMNS WHERE TABLE_NAME='user' AND COLUMN_NAME='user_id';
+-----------+
+-----------+
| DATA_TYPE |
| DATA_TYPE |
11번째 줄: 21번째 줄:
+-----------+
+-----------+
1 row in set (0.00 sec)
1 row in set (0.00 sec)
</source>
</source>
<source lang='cli'>
<source lang='console'>
mysql> SELECT COLUMN_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='nt_user' AND CO
mysql> SELECT COLUMN_TYPE FROM information_schema.COLUMNS WHERE TABLE_NAME='user' AND COLUMN_NAME='user_id';
+------------------+
+------------------+
| COLUMN_TYPE      |
| COLUMN_TYPE      |
21번째 줄: 32번째 줄:
1 row in set (0.00 sec)
1 row in set (0.00 sec)
</source>
</source>
==방법 3: PHP==
<source lang='php'>
$mysqli = new mysqli('localhost','my_user','my_password','world');
$result = $mysqli->query("SHOW COLUMNS FROM `user` LIKE 'user_id'");
$row = mysqli_fetch_assoc($result);
$column_type = $row['Type'];
</source>
<source lang='php'>
$mysqli = new mysqli('localhost','my_user','my_password','world');
$result = $mysqli->query("SELECT COLUMN_TYPE FROM information_schema.COLUMNS WHERE TABLE_NAME='user' AND COLUMN_NAME='user_id'");
$row = mysqli_fetch_assoc($result);
$column_type = $row['COLUMN_TYPE'];
echo $column_type;
</source>
==같이 보기==
*[[MySQL 컬럼 있는지 확인]]
==참고==
*https://social.msdn.microsoft.com/Forums/sqlserver/en-US/eed0fc85-f1c2-452b-a882-64e2f031d070/how-to-get-datatype-a-column-in-sqlserver-
[[분류: MySQL]]

2017년 6월 27일 (화) 11:36 기준 최신판

MySQL 컬럼 자료형 확인

1 방법 1: SHOW COLUMNS[ | ]

mysql> SHOW COLUMNS FROM `user` LIKE 'user_id';
+---------+------------------+------+-----+---------+----------------+
| Field   | Type             | Null | Key | Default | Extra          |
+---------+------------------+------+-----+---------+----------------+
| user_id | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
+---------+------------------+------+-----+---------+----------------+
1 row in set (0.00 sec)

2 방법 2: information_schema[ | ]

mysql> SELECT DATA_TYPE FROM information_schema.COLUMNS WHERE TABLE_NAME='user' AND COLUMN_NAME='user_id';
+-----------+
| DATA_TYPE |
+-----------+
| int       |
+-----------+
1 row in set (0.00 sec)

mysql> SELECT COLUMN_TYPE FROM information_schema.COLUMNS WHERE TABLE_NAME='user' AND COLUMN_NAME='user_id';
+------------------+
| COLUMN_TYPE      |
+------------------+
| int(10) unsigned |
+------------------+
1 row in set (0.00 sec)

3 방법 3: PHP[ | ]

$mysqli = new mysqli('localhost','my_user','my_password','world');
$result = $mysqli->query("SHOW COLUMNS FROM `user` LIKE 'user_id'");
$row = mysqli_fetch_assoc($result);
$column_type = $row['Type'];

$mysqli = new mysqli('localhost','my_user','my_password','world');
$result = $mysqli->query("SELECT COLUMN_TYPE FROM information_schema.COLUMNS WHERE TABLE_NAME='user' AND COLUMN_NAME='user_id'");
$row = mysqli_fetch_assoc($result);
$column_type = $row['COLUMN_TYPE'];
echo $column_type;

4 같이 보기[ | ]

5 참고[ | ]

원본 주소 "https://zetawiki.com/w/index.php?title=MySQL_컬럼_자료형_확인&oldid=268635"
문서 댓글 ({{ doc_comments.length }})
{{ comment.name }} {{ comment.created | snstime }}