목록DB/MySQL (35)

develog

MySQL ROWNUM

SELECT (@RNUM := @RNUM + 1) AS RNUM , B.* FROM (SELECT @RNUM := 0) A, 'TABLE_NAME' B LIMIT 25 OFFSET 0
DB/MySQL 2013. 12. 3. 18:42
[MySQL] 프로시저 만들기

# 프로시저 만들기DELIMITER $$DROP PROCEDURE IF EXISTS 'dbname'.PR_TEST; CREATE PROCEDURE 'dbname'.PR_TEST() DETERMINISTIC BEGIN SELECT 'AA'; END $$ DELIMITER ;
DB/MySQL 2013. 12. 3. 14:59
[MySQL] 함수 만들기

# 함수 만들기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')
DB/MySQL 2013. 12. 1. 17:38
[MySQL] 프로시저 소스, information_schema.ROUTINES

프로시저 소스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' ;
DB/MySQL 2013. 12. 1. 17:24
[MySql] 날짜 연산

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..
DB/MySQL 2013. 11. 28. 18:11
HeidiSQL

HeidiSQL : MySQL, MSSQL 클라이언트 프로그램http://www.heidisql.com/
DB/MySQL 2013. 3. 7. 13:20
Prev 1 2 3 4 5 6 Next