MySQL Command List

27Jul08

This is a list of the most common used mySQL Commands

General Commands

USE database_name

Change to this database. You need to change to some database when you first connect to MySQL.

SHOW DATABASES

Lists all MySQL databases on the system.

SHOW TABLES [FROM database_name]

Lists all tables from the current database or from the database given in the command.

DESCRIBE table_name

SHOW [...]

Filed under: apache, php, programming   |  Leave a Comment