[MySql] 기본 문법

create database library;

show databases;

drop database library;

use library;

show tables;

create table fruit
(
    id           bigint auto_increment,
    name         varchar(20),
    price        int,
    stocked_date date,
    primary key (id)
);

drop table fruit;

select * from fruit;

#DML Data Manipulation Language
insert into fruit (name, price, stocked_date) values('사과', 1000, '2023-01-01'); #생성 

update fruit set price = 1500 where name = '사과'; #수정

delete from fruit where name = '사과'; #삭제

 

 

 

MySql 타입  종류 정리

 

https://inpa.tistory.com/entry/MYSQL-%F0%9F%93%9A-%EC%9E%90%EB%A3%8C%ED%98%95-%ED%83%80%EC%9E%85-%EC%A2%85%EB%A5%98-%EC%A0%95%EB%A6%AC

[MYSQL] 📚 자료형 타입 종류 정리