SQL query problem

Web page creation, programs, scripts, PHP, SQL?

Moderator: Moderators

SQL query problem

Postby plm » Sun Dec 19, 2004 4:18 pm

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
plm
Junior Member
 
Posts: 15
Joined: Thu Dec 16, 2004 9:18 pm
Location: Sweden

Postby DenisF » Sun Dec 19, 2004 4:33 pm

When in doubt, use phpMyAdmin :)

Code: Select all
CREATE TABLE `ip_log` (
`ip` VARCHAR( 20 ) NOT NULL ,
`host` VARCHAR( 20 ) NOT NULL
);
Image
[ FAQ ] :: [ Policy ] :: [ Port Forwarding Guide ] :: [ Search ]
User avatar
DenisF
Forum Admin
Forum Admin
 
Posts: 679
Joined: Mon Dec 16, 2002 9:09 pm
Location: Israhell

Postby plm » Sun Dec 19, 2004 5:50 pm

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!!! :D
plm
Junior Member
 
Posts: 15
Joined: Thu Dec 16, 2004 9:18 pm
Location: Sweden

Postby DenisF » Sun Dec 19, 2004 6:21 pm

Hehe, thanks for your kind words :oops: :)
Image
[ FAQ ] :: [ Policy ] :: [ Port Forwarding Guide ] :: [ Search ]
User avatar
DenisF
Forum Admin
Forum Admin
 
Posts: 679
Joined: Mon Dec 16, 2002 9:09 pm
Location: Israhell


Return to Web development

Who is online

Users browsing this forum: No registered users and 14 guests