mySQL table creation help

[xWastedMindx]

What are the different data types for mySQL databases?

example, I'm making a database of my DVD collection. The database is named DVDLIST and the table is Kenny (my name).
The table will hold columns for DVD Name, length, who borrowed it last etc.

I just need to figure out which data types to associate with these, but knowing the data types would help me out the most.
Thanks in advance.

 

[QatQat]

Tinyint
smallint
mediumint
int
float
double
decimal
date
datetime
timestamp
time
year
char
varchar
tiniyblob
tinytext
blob
mediumblob
mediumtext
longblob
longtext
enum
set

I suggest that you read these pages

http://www.mysql.com/doc/en/Numeric_types.html

http://www.mysql.com/doc/en/Date_and_time_types.html

http://www.mysql.com/doc/en/String_types.html

Bye


Qatqat The reason why my girlfriend can read my thoughts is because mine are properly written! (G.Lepore)