<MYSQL> 기본 문법 !

👉 Add field

ALTER TABLE [table name] ADD [column name][datatype];

mysql> ALTER TABLE Product ADD price DECIMAL(1,1);

👉 Change datatype

ALTER TABLE [table name] MODIFY COLUMN [column name][datatype];

mysql> ALTER TABLE Product MODIFY price INT;

👉 Drop column

ALTER TABLE [table name] DROP [column name];

mysql> ALTER TABLE Product DROP image;

 

👉 Select

UPDATE [table] SET [column]=[value] WHERE [condition];

mysql> select * from images WHERE price < 1000.00;

ORM > Product.objects.filter(price__lte = 1000.00)

👉 Add row

INSERT INTO [table name] VALUES (value1, value2, value3…);

mysql> INSERT INTO Product(id, korean_name, price) VALUES(1, '자이언트 떡볶이', 2700);

ORM > Product.objects.create(id=1, korean_name='자이언트 떡볶이', price=2700)

👉 update value

UPDATE [table] SET [column]=[value] WHERE [condition];

mysql> UPDATE products SET price=1400.00 WHERE korean_name='빙그레)졸음사냥';

ORM > Product.obje

cts.filter(korean_name='빙그레)졸음사냥', price=1400.00)

👉 Delete value

DELETE FROM [table] WHERE [condition];

DELETE FROM products WHERE korean_name = '빙그레)졸음사냥';

---