hi,
i wrote this
CREATE TABLE users(
id int( 11 ) PRIMARY KEY AUTO_INCREMENT ,
username varchar( 25 ) ,
password varchar( 25 ) ,
email varchar( 25 ) .
)
to create table but it shows an error
#1064 - 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 ‘. )’ at line 5
help me to solve that one
Remove that dot before closing )
don it
tnx
CREATE TABLE contents(
id int( 11 ) PRIMARY KEY AUTO_INCREMENT ,
cll text( unlimited ) ,
cll1 text( unlimited ) ,
cll2 text( unlimited )
)
now what
#1064 - 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 ‘unlimited), cll1 text(unlimited), cll2 text(unlimited) )’ at line 2
In your first code there were no those ‘unlimited’. You may want to check MySQL create table syntax.