Mysql Tips. Useful commands | Drupal 8

Mysql Tips. Useful commands

By editor, 8 August, 2016
Question

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;

Tags

Comments

About text formats

Plain text

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