How to use MySQL 5.0!

	MySQL Data Backup Tool BitDaddys Corp. $12.00 More Info Free Trial Buy Now!
Unique and Easy to use MySQL Database backups. Powerful Hourly Rotations. more ...

MySQL Tutorials Table Of Contents

This article and tutorial describes and demonstrates how you can:

Steps To Start the MySQL Command Line Client	Visual Demonstration
Click on "Start " Click on "Programs" Click on "MySQL" Click on "MySQL Server 5.0 " Click on "MySQL Command Line Client "

How do I create a new Database in MySQL 5.0?

Steps to Create and use a new MySQL Database	Visual Demonstration
Enter your password Type 'create database databasename;' Type 'use database databasename;'

CREATE DATABASE IF NOT EXISTS db_name

Steps to Create a new table in MySQL

Visual Demonstration

Type 'drop table if exists mytable;' to remove old table
Type 'create table if not exists mytable' to begin the create table statement
Type '(id int not null auto_increment,' to begin the column definitions and specify a controlled primary key
Type ' x varchar(80),' to specify column name and type .. repeat until all columns are defined
Type 'primary key (id));' to complete the table creation syntax and specify your primary key

CREATE TABLE IF NOT EXISTS tbl_name ( column definitions,..., primary key(idcolumn)) ;

where ( column definitions,..., primary key(idcolumn)) describes a list of columns and the primary key

Type	Description	Example
AUTO_INCREMENT	Automatically increments when new records added, use only with numeric types like INT	id int auto_increment
INT	Numeric Integer data type	customer_no int
DOUBLE	Numeric double precision floating point data type, includes total number of numbers and number of numbers to the right of the decimal point. The example represents 7.2 or seven numbers to the left and two numbers to the right of the decimal .. for a total of nine numbers.	dollars_spent double(9,2)
VARCHAR	Text data type, includes length of text in parens. This is a variable length string that can be up to 65,535 in length!	customer_note varchar(64000)