일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
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 |
- context
- Eclipse
- find
- tomcat
- profile
- Quartz
- lsof
- 네트워크
- Windows 10
- Windows
- import
- GIT
- ssh
- Source
- maVen
- vscode
- xargs
- grep
- Mac
- port
- web.xml
- IntelliJ
- plugin
- JavaScript
- resource
- 단축키
- 줄바꿈 문자
- netsh
- VirtualBox
- bash
- Today
- Total
목록DB/MySQL (35)
develog
SELECT (@RNUM := @RNUM + 1) AS RNUM , B.* FROM (SELECT @RNUM := 0) A, 'TABLE_NAME' B LIMIT 25 OFFSET 0
# 프로시저 만들기DELIMITER $$DROP PROCEDURE IF EXISTS 'dbname'.PR_TEST; CREATE PROCEDURE 'dbname'.PR_TEST() DETERMINISTIC BEGIN SELECT 'AA'; END $$ DELIMITER ;
# 함수 만들기DELIMITER $$DROP FUNCTION IF EXISTS 'dbname'.FN_TEST; CREATE FUNCTION 'dbname'.FN_TEST(STR VARCHAR(20)) RETURNS VARCHAR(20) DETERMINISTIC BEGIN RETURN CONCAT('OK', STR); END$$DELIMITER ; # 함수 사용 SELECT FN_TEST('haha')
프로시저 소스information_schema.ROUTINES SELECT * FROM information_schema.ROUTINES ; SELECT * FROM information_schema.ROUTINES WHERE ROUTINE_TYPE = 'FUNCTION' ; SELECT * FROM information_schema.ROUTINES WHERE ROUTINE_TYPE = 'PROCEDURE' ;
SELECT NOW() AS DATE현재, DATE_ADD(NOW(), INTERVAL -1 DAY) AS DATE현재_1일전, DATE_ADD(NOW(), INTERVAL -1 WEEK) AS DATE현재_일주일전, DATE_ADD(NOW(), INTERVAL -1 MONTH) AS DATE현재_1달전, DATE_ADD(NOW(), INTERVAL -1 YEAR) AS DATE현재_1년전 ; SELECT DATE_FORMAT(NOW(), '%Y-%m-%d') AS DATE현재, DATE_ADD(DATE_FORMAT(NOW(), '%Y-%m-%d'), INTERVAL -1 DAY) AS DATE현재_1일전, DATE_ADD(DATE_FORMAT(NOW(), '%Y-%m-%d'), INTERVAL -1 W..
HeidiSQL : MySQL, MSSQL 클라이언트 프로그램http://www.heidisql.com/