Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE Users(
- id INTEGER,
- name VARCHAR(255),
- nickname VARCHAR(255),
- created DATETIME,
- CONSTRAINT u_nickname UNIQUE(nickname),
- CONSTRAINT fk_id FOREIGEN KEY(id) REFERENCE Kunde(user_id),
- PEIMARYKEY(id)
- );
- INSERT INTO Users VALUES(1,'Peter','Pet','YYY.MMM.DDD hh:mm:ss);
- INSERT INTO Users(id,name)VALUES(2,'KLAUS');
- ALTER TABLE Users DROP COLUMN created;
- ALTER TABLE Users ADD passwort VARCHAR(255);
- UPDATE Users SET name='Kai' WHERE ud=2;
- DELETE FROM users WHERE id=2;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement