Einträge in der Datenbank entfernen

[Dave]

hi Ich möchte folgendes aus der Datenbank entfernen. Wie muß der Befehl dafür lauten? Eingetragen habe ich folgendes:

ALTER TABLE phpbb_themes ADD fontcolor5 VARCHAR (6) DEFAULT 'FE00FE' NOT NULL;
ALTER TABLE phpbb_themes ADD fontcolor6 VARCHAR (6) DEFAULT 'FF0000' NOT NULL;
ALTER TABLE phpbb_themes_name ADD fontcolor5_name CHAR (50) DEFAULT 'Founder color' NOT NULL;
ALTER TABLE phpbb_themes_name ADD fontcolor6_name CHAR (50) DEFAULT 'Founder color (hover' NOT NULL;
ALTER TABLE phpbb_themes ADD fontcolor7 VARCHAR (6) DEFAULT 'FFA34F' NOT NULL;
ALTER TABLE phpbb_themes ADD fontcolor8 VARCHAR (6) DEFAULT 'FF0000' NOT NULL;
ALTER TABLE phpbb_themes_name ADD fontcolor7_name CHAR (50) DEFAULT 'Admin color' NOT NULL;
ALTER TABLE phpbb_themes_name ADD fontcolor8_name CHAR (50) DEFAULT 'Admin color (hover)' NOT NULL;
ALTER TABLE phpbb_themes ADD fontcolor9 VARCHAR (6) DEFAULT '006600' NOT NULL;
ALTER TABLE phpbb_themes ADD fontcolor10 VARCHAR (6) DEFAULT '008000' NOT NULL;
ALTER TABLE phpbb_themes_name ADD fontcolor9_name CHAR (50) DEFAULT 'Moderator color' NOT NULL;
ALTER TABLE phpbb_themes_name ADD fontcolor10_name CHAR (50) DEFAULT 'Moderator color (hover)' NOT NULL;
ALTER TABLE phpbb_themes ADD fontcolor11 VARCHAR (6) DEFAULT '000000' NOT NULL;
ALTER TABLE phpbb_themes ADD fontcolor12 VARCHAR (6) DEFAULT 'DD6900' NOT NULL;
ALTER TABLE phpbb_themes_name ADD fontcolor11_name CHAR (50) DEFAULT 'User color' NOT NULL;
ALTER TABLE phpbb_themes_name ADD fontcolor12_name CHAR (50) DEFAULT 'User color (hover)' NOT NULL;

[frederic]

Code: Alles auswählen

DELETE phpbb_themes WHERE blabla

[Pyramide]

Code: Alles auswählen

ALTER TABLE phpbb_themes DROP fontcolor5;
ALTER TABLE phpbb_themes DROP fontcolor6;
ALTER TABLE phpbb_themes DROP fontcolor7;
ALTER TABLE phpbb_themes DROP fontcolor8;
ALTER TABLE phpbb_themes DROP fontcolor9;
ALTER TABLE phpbb_themes DROP fontcolor10;
ALTER TABLE phpbb_themes DROP fontcolor11;
ALTER TABLE phpbb_themes DROP fontcolor12;

ALTER TABLE phpbb_themes_name DROP fontcolor5_name;
ALTER TABLE phpbb_themes_name DROP fontcolor6_name;
ALTER TABLE phpbb_themes_name DROP fontcolor7_name;
ALTER TABLE phpbb_themes_name DROP fontcolor8_name;
ALTER TABLE phpbb_themes_name DROP fontcolor9_name;
ALTER TABLE phpbb_themes_name DROP fontcolor10_name;
ALTER TABLE phpbb_themes_name DROP fontcolor11_name;
ALTER TABLE phpbb_themes_name DROP fontcolor12_name;

[Dave]

danke