Altering a table

Renaming a table

Selecting a database:

mysql> USE database;

Listing databases:

mysql> SHOW DATABASES;

Listing tables in a db:

mysql> SHOW TABLES;

Describing the format of a table:

mysql> DESCRIBE table;

Creating a database:

mysql> CREATE DATABASE db_name;

Creating a table:

mysql> CREATE TABLE table_name (field1_name TYPE(SIZE), field2_name TYPE(SIZE)); Ex: mysql> CREATE TABLE pet (name VARCHAR(20), sex CHAR(1), birth DATE);

Microsoft Windows offer many simple keyboard shortcuts. If you use computer as much as I do, you would find that these commands are easy to remember and simplify life a little bit. The symbol + in the table means that you have to press those keys together. win is the windows button just to the right of ctrl with Microsoft Windows logo. The keys are typed in CAPS to increase readability e.g. one and the letter can be confusing is lowercase but not when L is written in uppercase. The commands are NOT case sensitive.