MySQL Quick Guide

1
MySQL Quick Guide
2
Start and End MySQL

• MySQL is installed as a service.
• To start MySQL
• Control Panel/Administrative Tools/Services/MySQL/
  start
• MySQL Administrator
• MySQL Query Browser
• MySQL Command Line Client
• To stop MySQL
• Control Panel/Administrative Tools/Services/MySQL/
  Stop Or
• MySQL Administrator/Services Control/Stop

3
Creating and Use a Database

• CREATE DATABASE mydb
• USE mydb

4
Show

• SHOW DATABASES
• Show all databases
• SHOW TABLES
• List all tables in the default database
• SHOW COLUMNS FROM tableName
• List all columns in a given table.

5
Editing SQL Commands

• MySQL stores the most recent command. We can
  edit the command as follow
• Use the Up, Down arrow key to select and correct
  the command, then press Enter.

6
Creating Command Files

• Use a text editor to create a file with SQL
  commands and save it with extension .txt
• To run the command file
• SOURCE commandFileName.txt
• Ex mysqlgt source c\MySQLCommand.txt

7
MySQL Query Browser

• Schemata
• Select a database schema to be the default
  database
• To create/delete a schema
• Point to any schema and right click, then choose
  create/delete schema
• To create a new script
• File/New Script Tab
• To open a script
• File/New Script