-
Notifications
You must be signed in to change notification settings - Fork 0
gakgu edited this page Sep 23, 2018
·
5 revisions
-
CREATE
CREATE DATABASE <database name> CREATE TABLE <table name> CREATE VIEW <view name> AS <SELECT절>
-
DROP
DROP DATABASE <database name> DROP TABLE <table name> DROP VIEW <view name>
-
ALTER
ALTER TABLE <old table name> RENAME TO <new table name>;
-
TRUNCATE
TRUNCATE TABLE;
-
SELECT
SELETE * FROM table;
-
INSERT
INSERT INTO table(name, age) VALUES("gakgu", 29);
-
UPDATE
UPDATE table SET age = 30 WHERE name == "gakgu";
-
DELETE
DELETE FROM table where name = gakgu;
- GRANK
- REVOKE