search
LoginSignup
55
Help us understand the problem. What are the problem?

More than 3 years have passed since last update.

posted at

MySQLでカラム一覧を取得

カラム一覧を取得

$ DESCRIBE テーブル名;

or

$ show columns from テーブル名;

どちらも、Field,Type,Null,Key,Default,Extraが取得できる。

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
What you can do with signing up
55
Help us understand the problem. What are the problem?