위키
포럼
도구
바뀐글
랜덤

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

잔글 (봇: 자동으로 텍스트 교체 (-== 참고 자료 == +==참고==))
 
(사용자 2명의 중간 판 5개는 보이지 않습니다)
2번째 줄: 2번째 줄:


==방법 1: SHOW COLUMNS==
==방법 1: SHOW COLUMNS==
<source lang='cli'>
<source lang='console'>
mysql> SHOW COLUMNS FROM `user` LIKE 'user_id';
mysql> SHOW COLUMNS FROM `user` LIKE 'user_id';
+---------+------------------+------+-----+---------+----------------+
+---------+------------------+------+-----+---------+----------------+
13번째 줄: 13번째 줄:


==방법 2: information_schema==
==방법 2: information_schema==
<source lang='cli'>
<source lang='console'>
mysql> SELECT DATA_TYPE FROM information_schema.COLUMNS WHERE TABLE_NAME='user' AND COLUMN_NAME='user_id';
mysql> SELECT DATA_TYPE FROM information_schema.COLUMNS WHERE TABLE_NAME='user' AND COLUMN_NAME='user_id';
+-----------+
+-----------+
23번째 줄: 23번째 줄:


</source>
</source>
<source lang='cli'>
<source lang='console'>
mysql> SELECT COLUMN_TYPE FROM information_schema.COLUMNS WHERE TABLE_NAME='user' AND COLUMN_NAME='user_id';
mysql> SELECT COLUMN_TYPE FROM information_schema.COLUMNS WHERE TABLE_NAME='user' AND COLUMN_NAME='user_id';
+------------------+
+------------------+
31번째 줄: 31번째 줄:
+------------------+
+------------------+
1 row in set (0.00 sec)
1 row in set (0.00 sec)
</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>
</source>


36번째 줄: 51번째 줄:
*[[MySQL 컬럼 있는지 확인]]
*[[MySQL 컬럼 있는지 확인]]


==참고 자료==
==참고==
*https://social.msdn.microsoft.com/Forums/sqlserver/en-US/eed0fc85-f1c2-452b-a882-64e2f031d070/how-to-get-datatype-a-column-in-sqlserver-
*https://social.msdn.microsoft.com/Forums/sqlserver/en-US/eed0fc85-f1c2-452b-a882-64e2f031d070/how-to-get-datatype-a-column-in-sqlserver-


[[분류: MySQL]]
[[분류: 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 }}