SQL - CREATE / INSERT / UPDATE / REPLACE / DELETE / ALTER / DROP

CREATE TABLE mytable (id INT, name VARCHAR(255), debut DATE);

 

CREATE TABLE mytable2 (id INTEGER PRIMARY KEY AUTOINCREMENT, name VARCHAR(255),  debut DATE);

 

-- INSERT

INSERT INTO mytable2 (name, debut) VALUES ('Kim', '2020-05-21');

 

-- INSERT OR IGNORE

-- MySQL INSERT IGNORE

-- IGNORE 안 한 경우 id 값이 이미 있기 때문에 에러값이 뜸

INSERT OR IGNORE INTO mytable2 (id, name, debut) VALUES (1, 'Lee', '2010-10-10');

 

-- UPDATE

UPDATE mytable2 SET debut = '2010-01-01' WHERE id=1;

 

-- REPLACE

REPLACE INTO mytable2 (id, name, debut) VALUES (8, 'John', '2020-01-01');

 

-- DELETE

DELETE FROM mytable2 WHERE id=1;

 

-- ALTER

ALTER TABLE mytable2 RENAME TO player2;

ALTER TABLE player2 ADD COLUMN DOB date;

 

-- DROP

DROP TABLE mytable