MySQL 기본 쿼리 모음집

database 생성

create database bow

 

database 삭제

drop database bow

 

query를 보낼 database 설정

use bow;

---

table 생성

create table bow
(
    id int primary key auto_increment,
    name varchar(20),
    rarity varchar(20)
);

 

table 삭제

drop table bow;

---

attribute 추가

alter table bow
add column damage int;

 

attribute 삭제

alter table bow
drop column damage;

---

tuple 추가

insert into bow (name, rarity) values ('Wooden Bow', 'Common');

 

tuple 삭제

delete from bow
where id = 3;

 

---

읽어주셔서 감사합니다!