봉 블로그

# DATE => String DATE_FORMAT(SVC_END_YMD,'%Y-%m-%d %H:%i:%s') # String => Date mysql> SELECT STR_TO_DATE('01,5,2013','%d,%m,%Y'); -> '2013-05-01' # DATE 증감 ADDDATE(NOW(),-1) # 타입 변환 CONVERT(expr,type), CONVERT(expr USING transcoding_name) The CONVERT() and CAST() functions take a value of one type and produce a value of another type. The type can be one of the following values: BINARY[(N)] CHAR[..

CREATE FUNCTION `cloud`.`LAST_INDEXOF`(str VARCHAR(50), substr VARCHAR(50)) RETURNS INT DETERMINISTIC BEGIN RETURN LENGTH(str) - INSTR(REVERSE(str), substr) + 1; END;

SHOW [FULL] COLUMNS {FROM | IN} tbl_name [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] 상세설명 활용예시 > DTO 및 ibatis sql 만들기 쿼리 SELECT COLUMN_NAME ,CONCAT('private String ',LOWER(COLUMN_NAME),';') ,DATA_TYPE ,CONCAT('' ELSE '" />' END ) FROM information_schema.COLUMNS WHERE TABLE_NAME = 'NOTICE_TBL' ORDER BY ORDINAL_POSITION

매뉴얼 : http://dev.mysql.com/doc/refman/5.1/en/index.html [콘솔 로그인] shell> mysql --user=root mysql [계정추가] 중요: 계정@IP주소로 등록해야함. 그리고, xp경우 방화벽에 3306 포트도 추가해줘야 외부에서 접속할수 있음. mysql> CREATE USER 'monty'@'localhost' IDENTIFIED BY 'some_pass'; mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost' -> WITH GRANT OPTION; mysql> CREATE USER 'monty'@'%' IDENTIFIED BY 'some_pass'; mysql> GRANT ALL PRIVILEGES..