MySQL Error

[Daniel]

When I try to execute this query:

CREATE TABLE `ipalert` ('
        . ' `ip` VARCHAR(20) NOT NULL, '
        . ' `message` VARCHAR(255) NOT NULL, '
        . ' `djname` VARCHAR(50) NOT NULL'
        . ' )'
        . ' TYPE = myisam';

I get this error

An error occurred while attempting to execute your query. The following information was returned. 
error number: 1064 
error desc: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''
        . ' `ip` VARCHAR(20) NOT NULL, '
        . ' `messa

Can someone help me out? Thanks in advance! :nervous:

[filburt1]

Specify a default value when a column isn't null.

[Xenon]

i think it's because of th ' . ' in the query string...

[Daniel]

Thanks guys, I tried both of your suggestions and it works now.