목록DB/MySQL (35)

develog

[MySQL] 프로시서 소스 보기

SHOW CREATE PROCEDURE MY_PROC_NAME;
DB/MySQL 2016. 12. 13. 17:49
[MySQL] information_schema

http://dev.mysql.com/doc/refman/5.7/en/information-schema.html information_schema.ENGINESinformation_schema.CHARACTER_SETSinformation_schema.EVENTSinformation_schema.GLOBAL_STATUSinformation_schema.GLOBAL_VARIABLESinformation_schema.PARAMETERSinformation_schema.TABLESPACESinformation_schema.TRIGGERSinformation_schema.USER_PRIVILEGES information_schema.TABLESinformation_schema.TABLE_CONSTRAINTSin..
DB/MySQL 2016. 12. 13. 17:39
[MySql] Procedure 생성

생성 DELIMITER $$ DROP PROCEDURE IF EXISTS PR_TEST$$ CREATE PROCEDURE PR_TEST(STR VARCHAR(10)) BEGIN SELECT 1; END $$ DELIMITER ;
DB/MySQL 2015. 6. 8. 10:55
[MySql] Function 생성, 사용

생성 DELIMITER $$ DROP FUNCTION IF EXISTS FN_TEST$$ CREATE FUNCTION FN_TEST(STR VARCHAR(10)) RETURNS VARCHAR(20) BEGIN DECLARE STR2 VARCHAR(10); SET STR2 = '123'; RETURN CONCAT(STR, STR2); END $$ DELIMITER ; 사용 SELECT FN_TEST('ABC');
DB/MySQL 2015. 6. 8. 10:50
[MySql] 버전 확인

SELECT VERSION();
DB/MySQL 2015. 6. 8. 10:26
[MySql] 날짜검색

AND REG_DT >= STR_TO_DATE('20141031', '%Y%m%d')AND REG_DT < ADDDATE(STR_TO_DATE('20141031', '%Y%m%d'), 1)
DB/MySQL 2014. 11. 3. 21:06
Prev 1 2 3 4 5 6 Next