LoginSignup
2
2

More than 5 years have passed since last update.

MySQLのテーブルから定義情報を表示する方法

Last updated at Posted at 2012-05-09

以下のどれか

mysql> SHOW FULL COLUMNS FROM dbname.tablename;
mysql> DESC dbname.tablename;
mysql> SHOW CREATE TABLE dbname.tablename;

http://d.hatena.ne.jp/narusase/20090915/p1
thanx!

2
2
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
2
2