- MySQL 컬럼 자료형 확인
1 방법 1: SHOW COLUMNS[ | ]
Console
Copy
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[ | ]
Console
Copy
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)
Console
Copy
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[ | ]
PHP
Copy
$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'];
PHP
Copy
$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 참고[ | ]
편집자 Jmnote Jmnote bot
로그인하시면 댓글을 쓸 수 있습니다.