sql cookbook

Create and Alter user

CREATE USER '<USER_NAME>'@'localhost' IDENTIFIED BY 'password'; --CREATE USER WITH PASSWORD--
GRANT ALL ON *.* TO '<USER_NAME>'@'%' WITH GRANT OPTION; --GRANT USER PERMISSION--

ALTER TABLE

ALTER TABLE <TABLE_NAME> CHANGE <COLUMN1> <COLUMN2> <DATATYPE> --change column name--
ALTER TABLE <TABLE_NAME> DROP <COLUMN_NAME>
ALTER TABLE <TABLE_NAME> MODIFY <COLUMN_NAME> <DATA_TYPE> NOT NULL PRIMARY KEY

INSERT STATEMENT

존재하지 않는 것만 추가하기

INSERT INTO <TABLE> (<COLUMN1>, <COLUMN2>) 
	VALUES (<VALUE1>, <VALUE2>) 
	WHERE NOT EXISTS (
		SELECT <COLUMN> FROM <TABLE2> WHERE id=<value>
  )