Database Programming Notes
Pages
Home
Resources
Saturday, July 9, 2011
MySql Commands
Command to show all database schema in your application
show databases;
Command to switch to a particular database
use bookshop;
Command to show all the tables in a databse (you will have to issue an appropriate 'use' command to switch to that database)
show tables;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment