MySQL INSERT - 데이터 삽입하기

[주인장]

-- 데이터 입력하기

insert into cats (name, age) values ("Jetson", 7);

INSERT INTO cats (name, age)

VALUES ('Blue Steele', 5);

INSERT INTO cats (name, age)

VALUES ('Jenkins', 7);

-- 다른 순서로 데이터 입력하기

insert into cats(age, name) values (9, 'Tom');

-- 여러 내용 입력하기

insert into cats(name, age)

values ("Meatball", 5),

("Turkey", 1),

("Potato Face", 15);

-- 테이블 내용 확인하기

select * from cats;

==============================================================

create table people (

first_name varchar(20),

last_name varchar(20),

age int

);

insert into people values ("Tina", "Belcher", 13);

insert into people values

('Linda', 'Belcher', 45),

('Phillip', 'Frond', 38),

('Calvin', 'Fischoeder', 70);

select * from people p ;

drop table people;

show tables;