<< database

MySQL Command

  1. List all database. show databases

  2. Select databse. use [database_name]

  3. List tables. show tables

  4. List columns. describe [table_name]

  5. Create database. create database [database_name]

  6. Load sql file [in shell]. mysql -uroot [database_name] < [filename.sql]