Finding all column name of table

Suppose we have a table user and we want to fetch all its column name.
For this we use INFORMATION_SCHEMA.

we will use following query to fetch all column name of table

 

Above query will fetch all columns of user table available in social database.

Read More

  1. Setting innodb_lock_wait_timeout
  2. Set time zone in mysql
  3. Granting Privileges to users
  4. Show engine innodb status
  5. Finding all column name of table