랩제이

jdbc:mysql://127.0.0.1:3306/mydb1?characterEncoding=euckr jdbc:mysql://127.0.0.1:3306/mydb2?characterEncoding=utf8

CREATE DATABASE spring DEFAULT CHARACTER SET euckr COLLATE euckr_korean_ci; CREATE DATABASE mysample DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

GRANT ALL PRIVILEGES ON *.* TO 'javajigi'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION; GRANT ALL PRIVILEGES ON *.* TO 'javajigi'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;

연결할 서버 : HNAMJU\SQLEXPRESS

select num1, num2, num3, seatno, isnull(max(t1 ),'') as t1 , isnull(max(t2 ),'') as t2 , isnull(max(t3 ),'') as t3 , isnull(max(t4 ),'') as t4 , isnull(max(t5 ),'') as t5 , isnull(max(t6 ),'') as t6 , isnull(max(t7 ),'') as t7 , isnull(max(t8 ),'') as t8 , isnull(max(t9 ),'') as t9 , isnull(max(t10 ),'') as t10 , isnull(max(t11),'') as t11, isnull(max(t12),'') as t12, isnull(max(t13),'') as t13,..