Hej
Jeg kører i ring med et problem jeg ikke kan løse - og jeg kan ikke se
der er nogen fejl.
Jeg bruger MySQL ver 4.1.0
Jeg får fejlen
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 'NOT NULL, interpersonal TEXT NOT NULL, intrapersonal TEXT NOT N
når jeg forsøger at danne nedenstående tabel
CREATE TABLE nuke_zpers_ads
(
ad_id SMALLINT UNSIGNED NOT NULL auto_increment,
cat_id SMALLINT UNSIGNED NOT NULL,
user_name VARCHAR(20) NOT NULL,
email VARCHAR(50) NOT NULL,
subject TEXT NOT NULL,
descript TEXT NOT NULL,
age VARCHAR(2) NOT NULL,
height VARCHAR(20) NOT NULL,
weight TEXT NOT NULL,
hair VARCHAR(10) NOT NULL,
eyes VARCHAR(10) NOT NULL,
city VARCHAR(20) NOT NULL,
state VARCHAR(20) NOT NULL,
country VARCHAR(20) NOT NULL,
zip VARCHAR(10) NOT NULL,
intention VARCHAR(20) NOT NULL,
ideal_date TEXT NOT NULL,
turn_ons TEXT NOT NULL,
turn_offs TEXT NOT NULL,
url TEXT NOT NULL,
exercise TEXT NOT NULL,
diet TEXT NOT NULL,
smoking TEXT NOT NULL,
drinking TEXT NOT NULL,
employment TEXT NOT NULL,
income TEXT NOT NULL,
education TEXT NOT NULL,
creligion TEXT NOT NULL,
preligion TEXT NOT NULL,
fav_books TEXT NOT NULL,
role_mods TEXT NOT NULL,
pers_type TEXT NOT NULL,
worldview TEXT NOT NULL,
conciousness TEXT NOT NULL,
languages TEXT NOT NULL,
passion TEXT NOT NULL,
quotes TEXT NOT NULL,
musical TEXT NOT NULL,
bodily TEXT NOT NULL,
linguistic TEXT NOT NULL,
spatial TEXT NOT NULL,
interpersonal TEXT NOT NULL,
intrapersonal TEXT NOT NULL,
naturalist TEXT NOT NULL,
logical TEXT NOT NULL,
midealmate TEXT NOT NULL,
mdiet TEXT NOT NULL,
magef TEXT NOT NULL,
maget TEXT NOT NULL,
mweight TEXT NOT NULL,
mexercise TEXT NOT NULL,
msmoking TEXT NOT NULL,
mdrinking TEXT NOT NULL,
memployment TEXT NOT NULL,
mcreligion TEXT NOT NULL,
mpers_type TEXT NOT NULL,
mworldview TEXT NOT NULL,
mconciousness TEXT NOT NULL,
lastup_date INT NOT NULL,
views INT NOT NULL DEFAULT '0',
add_date INT NOT NULL,
exp_date INT NOT NULL,
approved TEXT NOT NULL,
PRIMARY KEY(ad_id)
)TYPE=MyISAM;
|