Category Archives: MySQL

MSSQL OPENQUERY

MSSQL OPENQUERY

SELECT * FROM OPENQUERY(L_TESTDB, 'SELECT * FROM LinkedServerTestTable');

INSERT OPENQUERY(L_TESTDB, 'SELECT NO, NAME 
더보기

MySQL bulk insert

MySQL bulk insert

bulk insert 실행하기

--local-infile=1 를 붙여서 접속한다.

mysql -u testuser -p db_test 
더보기