MySQL (GPL (free))

MySql is a GPL free database system that is easy to use and great for small to medium sized web projects.

Basic Mysql Commands that you need to know

These are the four core commands that you should know with these commands you can create powerful applications and websites.

Select

Insert

Update

Delete

Extra Commands:

ALTER Table

Commit

Create Index

Create Procedure

Create Table

Create View

Drop

Insert Select

RollBack

Keywords

Limit

DSC

ASC

SQL DataTypes:

Strings:

CHAR - Fixed length string that is has a length of 1 to 255 characters.

NCHAR - Same as char but supports Unicode.

TEXT or LONG or MEMO or VARCHAR - variable length string

NVARCHAR - same as text but support Unicode.

Numbers:

BIT - holds either 0 or 1can be used like a boolean datatype.

DECIMAL or NUMERIC -holds floating point or fixed numbers

FLOAT or Number - holds floating point numbers

INT or INTEGER - holds a 4 byte value from -2147483648 to 2147483647

REAL - holds a float byte floating point number.

SMALLINT - holds a two byte value from  - 32768 to 32767

TINYINT - holds a single value from 0 to 255.

Additional Information:

If you do not like command line of MySql and have a  PHP server I suggest you install phpMyAdmin which makes administrating your databases a lot easier.

The latest information about MySQL can be found at:
http://www.mysql.com