Manipulating Schema with SQL

February 24, 2015

Schema-Aenderungen (DDL) sind riskant: vorher Backup machen und ggf. Maintenance Mode aktivieren.

Tabellen aendern

code

RENAME TABLE movies TO movie_table;
RENAME TABLE movies TO movie_table, actors TO actor_table;

code

DROP TABLE IF EXISTS reviews;

code

TRUNCATE TABLE movie_table;

TRUNCATE loescht alle Daten und erstellt die Tabelle neu.

code

ALTER TABLE movies ADD COLUMN genre VARCHAR(100);
ALTER TABLE actors ADD (pob VARCHAR(100), dob DATE);

code

ALTER TABLE actors CHANGE pob place_of_birth VARCHAR(100);

code

ALTER TABLE movies CHANGE year year_released YEAR;

code

ALTER TABLE actors DROP date_of_birth;

code

ALTER TABLE movies ADD COLUMN name VARCHAR(150) FIRST;
ALTER TABLE movies ADD COLUMN name VARCHAR(150) AFTER id;

code

DROP DATABASE IF EXISTS db_name;

IF EXISTS vermeidet harte Fehler in Skripten.