DB/database

[DB] CLI 명령어

샛별KIM 2021. 6. 9. 17:41
create database joongang;
show databases;
show tables;

create table member(
number INT,
name VARCHAR(10),
tel VARCHAR(15)
);

explain member;

insert into member value(1, '홍길동', '010-1234-5678');
또는 insert into member (number, name) values(1, '홍길동');
또는 insert into member values(1, 'maria');

select * from member;

drop database joongang;