Wednesday, 2 May 2012

MySQL commands



List all databases on the sql server.

mysql> show databases;



Creating a database:

mysql> CREATE DATABASE magento;



Deleting a database:

mysql> drop database magento;



To see all the tables in the db.


mysql> show tables;








No comments:

Post a Comment