07-18-2008, 04:41 PM
|
#1 (permalink)
|
|
The Contributor
Join Date: Apr 2008
Location: Tampa, FL
Posts: 65
Thanks: 6
|
query synatx
Code:
CREATE TABLE IF NOT EXISTS users (
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
username VARCHAR(255) NOT NULL ,
password VARCHAR(255) NOT NULL ,
email TEXT NOT NULL ,
ip VARCHAR(16) NOT NULL ,
group INT(1) NOT NULL DEFAULT 1 ,
banned VARCHAR(5) NOT NULL DEFAULT 'n'
);";
produces this error...
Quote:
|
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 'group INT(1) NOT NULL DEFAULT 1 , banned VARCHAR(5) NOT NULL DEFAULT 'n' at line 7
|
why? i've used this exact query string in the past, but now it doesn't work?
__________________
"Knowledge is power. Abuse it."~Evulness
My portfolio: www.evularts.com
|
|
|
Join the friendly bunch on IRC...
Threaded Mode
