Data

Insert

INSERT INTO <table | view> (<column>, <column>, ...)
    VALUES (<value>, <value>, ...), (<value>, <value>, ...), ...; -- insert values

INSERT INTO <table | view> (<column>, <column>, ...)
    <select statement>;                                           -- insert table

Update

UPDATE <table | view>
    SET <column> = <value>, <column> = <value>, ...
    WHERE <condition>;

Delete

DELETE FROM <table | view>
    WHERE <condition>;                                            -- delete data

TRUNCATE TABLE <table | view>;                                    -- delete all

Show

DESC <table | view>;                                              -- 정보를 보여줌

SHOW CREATE <TABLE | VIEW> <table | view>;                        -- 소스코드를 보여줌

CHECK TABLE <table | view>;                                       -- 상태를 확인