[TIL] 220630 MySQL 문법

📌MySQL

show databases;

create table 테이블명 select * from db명.테이블명; 테이블과 값 전체 들고오기
create table 테이블명 select * from db명.테이블명 where 1=2; 테이블만 들고오기

drop table 테이블명;
alter table 테이블명 change no no int not null primary key auto_increment;
insert into select_userinfo (name, age) values ('aa',11),('bb',22),('cc',33);
-- 주석입니다

set character set euckr;
-> 한글 안 나올때 설정하기
mysql> select no as '번호' from select_userinfo;
select no as 번호, name as 이름 from select_userinfo;
select no 번호, name 이름 from select_userinfo;
-- as생략가능

select no as `int`,name as `String` from select_userinfo;
-- syntax를 사용하고 싶을 때는 `자료형`

select distinct name from select_userinfo;
-- name에서 중복제거 distinct

select * from select_userinfo where no=1 and no=3;
select * from select_userinfo where no in (1,3);
select * from select_userinfo where age is null;
select * from select_userinfo where age between 20 and 40;
select * from select_userinfo where name like '%f';
select * from select_userinfo where name like '%f%';
select * from select_userinfo where name like 'f%';
select * from select_userinfo where name like '_f%';