목록DB/MySQL (35)

develog

[MySql] SQLException, Column 'COL_NM' not found

에러)Exception in thread "main" java.sql.SQLException: Column 'COL_NM' not found. 해결)JDBC 커넥션 맺을때 아래 옵션 추가useOldAliasMetadataBehavior=true
DB/MySQL 2014. 4. 5. 17:18
MySql, SQL Error (1267): Illegal mix of collations

위 에러 발생시 아래 처럼 사용CONVERT(COL_NM USING UTF8)
DB/MySQL 2014. 4. 5. 15:49
MySql CharSet 관련

SHOW CHARACTER SET; SHOW CHARACTER SET LIKE '%euc%'; SHOW CHARACTER SET LIKE '%utf%'; SHOW CHARACTER SET WHERE CHARSET LIKE '%euc%' OR CHARSET LIKE '%utf%'; SHOW COLLATION; SHOW COLLATION LIKE '%euc%'; SHOW COLLATION LIKE '%utf%'; SHOW COLLATION WHERE CHARSET LIKE '%euc%' OR CHARSET LIKE '%utf%';
DB/MySQL 2014. 4. 5. 15:04
iBatis, MySQL insert 후 insert Id 가져오기

- TEST1 테이블의 Primary Key 컬럼명은 SEQ- SEQ 컬럼은 AUTO_INCREMENT 사용중 - iBatis INSERT INTO TEST1 (TITLE) VALUES (#TITLE#) SELECT LAST_INSERT_ID() - JavaMap map = new HashMap();map.put("TITLE", title); int insertId = (Integer) sqlMapClient.insert("TestMap.insTest", map);System.out.println("insertId : " + insertId);
DB/MySQL 2013. 12. 13. 11:51
[MySql] Transaction Test

CREATE TABLE TEST1 ( SEQ INTEGER PRIMARY KEY AUTO_INCREMENT , TITLE VARCHAR(100) ) ENGINE INNODB ; CREATE TABLE TEST2 ( SEQ INTEGER PRIMARY KEY AUTO_INCREMENT , TITLE VARCHAR(100) ) ENGINE INNODB ; ALTER TABLE TEST1 ENGINE INNODB; ALTER TABLE TEST2 ENGINE INNODB; START TRANSACTION; INSERT INTO TEST1 (TITLE) VALUES ('11'); INSERT INTO TEST1 (TITLE) VALUES ('22'); INSERT INTO TEST2 (TITLE) VALUES ..
DB/MySQL 2013. 12. 12. 21:13
[MySql] CREATE TABLE ENGINE

CREATE TABLE TEST3 ( SEQ INTEGER PRIMARY KEY AUTO_INCREMENT , TITLE VARCHAR(100) ) ENGINE MYISAM; ALTER TABLE TEST3 ENGINE INNODB;
DB/MySQL 2013. 12. 12. 20:59
Prev 1 2 3 4 5 6 Next