blob problem

[Anon]

I'm trying to set up a table in a database using this

create table videos(
id int(5),
description blob,

primary key(id));

I get an error starting with the description line. What am I doing wrong?

[crusty_php]

How are you trying to run this query, through the command line, phpMyAdmin, php script?
If script, can you show the code.

[[deleted]]

which database type, and does it even have an int(5) and blob type?
(and are you sure you need the blob type? blobs can sometimes go upto Gigabytes, which is a little large for a description...

[Anon]

Doesn't the primary key have to be "not null"?