SQL query problem

[plm]

What's wrong with this?

Code: Select all

CREATE TABLE ip_log (ip varchar, host varchar)

The error message says:

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 ' host varchar)' at line 1

I will be very grateful for any help!
//plm

[DenisF]

When in doubt, use phpMyAdmin

Code: Select all

CREATE TABLE `ip_log` (
`ip` VARCHAR( 20 ) NOT NULL ,
`host` VARCHAR( 20 ) NOT NULL
);


[plm]

Thanks! I am very amazed of your fast response time and your great support! Polarhome sure has the most active and helpful community!
Thank you!!!

[DenisF]

Hehe, thanks for your kind words