Mysql Tips. Useful commands | Drupal 8

Mysql Tips. Useful commands

Submitted by editor on Mon, 08/08/2016 - 12:03
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;

Add new comment

CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.
Image CAPTCHA
Enter the characters shown in the image.