MySQL - CRUD

CRUD

Create

INSERT INTO <table-name> (column1) VALUES (value);

Read

SELECT *(column) FROM <table-name>;


SELECT * FROM <table-name> WHERE column의 조건;
ex) SELECT * FROM cats WHERE age=4;


SELECT column AS new-column FROM <table-name>;
ex) SELECT cat_id AS id FROM cats;

Update

UPDATE <table-name> SET column=new-value WHERE column=origin-value;
ex) UPDATE cats SET breed='Shorthair' WHERE breed='Tabby';

'업데이트하기 전에
SELECT * FROM <table-name> WHERE column=update-value;를 통해
내가 업데이트해야 할 부분이 맞는지 확인하는 습관 들이기'

Delete

DELETE FROM <table-name> WHERE column=value;
ex) DELETE FROM cats WHERE age=4;

'삭제하기 전에
SELECT * FROM <table-name> WHERE column=update-value;를 통해
내가 삭제해야 할 부분이 맞는지 확인하는 습관 들이기'