hmmm...

[Anon]

this is making me mad, what is wrong with this, it says there is an error in the first line after i create the table, but it seems ok to me:

mysql> CREATE TABLE news(
-> id MEDIUMINT(10) DEFAULT'0' NOT NULL auto_increment,
-> title VARCHAR(80),
-> description TEXT,
-> author VARCHAR(40),
-> submitted DATE,
-> url VARCHAR(80),
-> PRIMART KEY (id));

[jhonrputra]

Hi.

Why don't you try fix last line:

-> PRIMART KEY (id));

to

PRIMARY KEY (id));

Check again... P R I M A R Y
not P R I M A R T :-)

Get smile!

[Anon]

I didn't experiment with it, but having a DEFAULT '0' and auto_increment looks strange in two ways to me.

First, an integer column shouldn't have a string for the default. And second, an auto_increment shouldn't have a DEFAULT.

[Anon]

thanks guys, ill change my terrible spelling!, and then take a look at that.

thanks again.