반응형
Notice
Recent Posts
Recent Comments
Link
«   2025/12   »
일 월 화 수 목 금 토
1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30 31
Tags more
Archives
Today
Total
관리 메뉴

목록분류 전체보기 (690)

bro's coding

AVG(평균)

[IT]/MySQL 2020. 3. 19. 11:25
count()

[IT]/MySQL 2020. 3. 19. 11:18
REGEXP_LIKE

http://regexstorm.net/tester
[IT]/MySQL 2020. 3. 19. 11:14
like(조건)

[IT]/MySQL 2020. 3. 19. 11:06
is not null /in null (null 다루기)

[IT]/MySQL 2020. 3. 19. 10:43
insert into values(data 입력)

[IT]/MySQL 2020. 3. 19. 10:42
별칭

[IT]/MySQL 2020. 3. 19. 10:23
month(datetime/date)(날짜 다루기)

[IT]/MySQL 2020. 3. 19. 10:19
order by(정렬)

내림차순 : desc mysql> select ename, sal -> from emp -> order by sal; +--------+------+ | ename | sal | +--------+------+ | SMITH | 800 | | JAMES | 950 | | ADAMS | 1100 | | WARD | 1250 | | MARTIN | 1250 | | MILLER | 1300 | | TURNER | 1500 | | ALLEN | 1600 | | CLARK | 2450 | | BLAKE | 2850 | | JONES | 2975 | | SCOTT | 3000 | | FORD | 3000 | | KING | 9999 | +--------+------+ 14 rows in set (0.00 sec) ..
[IT]/MySQL 2020. 3. 19. 09:50
distinct(원소 종류 보기)

[IT]/MySQL 2020. 3. 19. 09:40
Prev 1 ··· 63 64 65 66 67 68 69 Next