creating table

[slighltywhacked]

Im using this in telnet to make a table

create news (id tinyint(11) DEFAULT '0' NOT NULL AUTO_INCREMENT, date TEXT, user TEXT, header TEXT, news BLOB, PRIMARY KEY (id), UNIQUE id (id));
but for some reasson it isnt working.


Also can someone tell me what a BLOB is?

[Skunk]

BLOB = Binary Large OBject - it's a field that can store binary data (normal mySQL fields store ASCII encoded text).

Not sure why it isn't working though - my advice is to install phpMyAdmin from www.phpwizards.net instead as it's much easier to use

[freddydoesphp]

The problem with this is, in addition to not needing a BLOB field for news, is your create table syntax is not create and:

create news (id tinyint(11) DEFAULT '0' NOT NULL AUTO_INCREMENT, date TEXT, user TEXT, header TEXT, news BLOB, PRIMARY KEY (id), UNIQUE id (id));


should actually be

create table news (id tinyint(11) DEFAULT '0' NOT NULL AUTO_INCREMENT, date TEXT, user TEXT, header TEXT, news BLOB, PRIMARY KEY (id), UNIQUE id (id));

See the missing word 'table' right after create.

[Alarion]

While Freddy answered the question I would just like to ask:

why are you using a "default '0'" on your id column? You have it set to auto_increment, and I would NEVER reccomend setting a "default" value for your primary key unless you are in Postgres and referencing a sequence or something... It probably doesn't matter, but it is just not needed AFAIK

[slighltywhacked]

ah..thanx