27 lines
627 B
SQL
27 lines
627 B
SQL
USE luna2_innodb;
|
|
|
|
SELECT * FROM tblabteilung;
|
|
|
|
INSERT INTO tblabteilung (A_Nr, A_Name, A_Stadt) VALUES ('a4', 'IT', 'Würzburg');
|
|
|
|
SELECT * FROM tblabteilung;
|
|
|
|
INSERT INTO tblabteilung (A_Nr, A_Name) VALUES ('a5', 'Marketing');
|
|
|
|
SELECT * FROM tblabteilung;
|
|
|
|
UPDATE tblabteilung SET A_Stadt='Schweinfurt' WHERE A_Nr='a5';
|
|
|
|
SELECT * FROM tblabteilung;
|
|
|
|
DELETE FROM tblabteilung WHERE A_nr='a4';
|
|
|
|
SELECT * FROM tblabteilung;
|
|
|
|
ALTER TABLE tblabteilung ADD Motivationsspruch VARCHAR(128) DEFAULT 'You are the best!';
|
|
|
|
SELECT * FROM tblabteilung;
|
|
|
|
ALTER TABLE tblabteilung DROP COLUMN Motivationsspruch;
|
|
|
|
SELECT * FROM tblabteilung; |