목록분류 전체보기 (1764)

develog

CAST

CAST('COLUMN_NAME' AS SIGNED) CAST('COLUMN_NAME' AS UNSIGNED)
DB/MySQL 2013. 12. 3. 19:49
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
[Java] log4sql, jdbc driverClass

http://log4sql.sourceforge.net/ ORACLE oracle.jdbc.driver.OracleDriver core.log.jdbc.driver.OracleDriver MYSQL com.mysql.jdbc.Driver core.log.jdbc.driver.MysqlDriver MSSQL 2000 com.microsoft.jdbc.sqlserver.SQLServerDriver core.log.jdbc.driver.MssqlDriver MSSQL 2005 com.microsoft.sqlserver.jdbc.SQLServerDriver core.log.jdbc.driver.Mssql2005Driver
Dev/Java 2013. 12. 3. 17:46
[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
Prev 1 ··· 251 252 253 254 255 256 257 ··· 294 Next