일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
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 |
- xargs
- lsof
- ssh
- GIT
- netsh
- IntelliJ
- Source
- copy-dependencies
- Windows
- resource
- Windows 10
- VirtualBox
- context
- tomcat
- Quartz
- Mac
- 네트워크
- bash
- grep
- find
- 공통표준용어
- web.xml
- import
- JavaScript
- DB 도메인
- port
- Eclipse
- maVen
- profile
- 단축키
- Today
- Total
목록DB/MySQL (35)
develog
SHOW CREATE PROCEDURE MY_PROC_NAME;
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..
생성 DELIMITER $$ DROP PROCEDURE IF EXISTS PR_TEST$$ CREATE PROCEDURE PR_TEST(STR VARCHAR(10)) BEGIN SELECT 1; END $$ DELIMITER ;
생성 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');
SELECT VERSION();