MySQL useful commands

  • by

Login to mysql:
mysql -u root -p

Show available tables:
SHOW TABLES;

Show how to create the table:
SHOW CREATE TABLE database.table;

Leave a Reply

Your email address will not be published. Required fields are marked *