Was ist an der SQL Anweisung faslch?
Verfasst: 19.02.2004 10:30
Lann mir jemand erklären was diese SQL Aneisung machen soll und warum Fehler kommt?
SQL-Befehl :
MySQL meldet:
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 'ADD parents_data TEXT NOT NULL AFTER cat_parent,
ADD cat_allow
SQL-Befehl :
Code: Alles auswählen
ALTER TABLE phpbb_pa_cat DROP cat_files. ADD parents_data TEXT NOT NULL AFTER cat_parent,
ADD cat_allow_file TINYINT( 2 ) DEFAULT '0' NOT NULL ,
ADD auth_view TINYINT( 2 ) DEFAULT '0' NOT NULL ,
ADD auth_read TINYINT( 2 ) DEFAULT '0' NOT NULL ,
ADD auth_view_file TINYINT( 2 ) DEFAULT '0' NOT NULL ,
ADD auth_upload TINYINT( 2 ) DEFAULT '0' NOT NULL ,
ADD auth_download TINYINT( 2 ) DEFAULT '0' NOT NULL ,
ADD auth_rate TINYINT( 2 ) DEFAULT '0' NOT NULL ,
ADD auth_email TINYINT( 2 ) DEFAULT '0' NOT NULL ,
ADD auth_view_comment TINYINT( 2 ) DEFAULT '0' NOT NULL ,
ADD auth_post_comment TINYINT( 2 ) DEFAULT '0' NOT NULL ,
ADD auth_edit_comment TINYINT( 2 ) DEFAULT '0' NOT NULL ,
ADD auth_delete_comment TINYINT( 2 ) DEFAULT '0' NOT NULL ,
ADD cat_files MEDIUMINT( 8 ) NOT NULL default '-1' AFTER cat_allow_file,
ADD cat_last_file_id MEDIUMINT( 8 ) UNSIGNEDDEFAULT '0' NOT NULL AFTER cat_files,
ADD cat_last_file_name VARCHAR( 255 ) NOT NULL AFTER cat_last_file_id,
ADD cat_last_file_time INT( 50 ) UNSIGNEDDEFAULT '0' NOT NULL AFTER cat_last_file_name,
DROP cat_1xid 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 'ADD parents_data TEXT NOT NULL AFTER cat_parent,
ADD cat_allow
wo hab ich nur meinen Kopf.. 