Mysql Tips. Useful commands | Drupal 8

Mysql Tips. Useful commands

Submitted by editor on Mon, 08/08/2016 - 12:03

Few useful mysql commands

Show all columns of a table.

Syntax: SHOW COLUMNS FROM the_table_name;
Example: Show all columns of the mysql user table.
mysql> SHOW COLUMNS FROM mysql.user;

Add new comment

Plain text

  • No HTML tags allowed.
  • Lines and paragraphs break automatically.
  • Web page addresses and email addresses turn into links automatically.