Unanswered: help me!!!how to write such sql in mysql?
in sql: insert into table select from ...
can select from a remote data base server such as sqlserver using odbc
as 'SELECT * into test01 FROM Fund IN [ODBC] [ODBC;Driver=SQL
Server;UID=admin;PWD=;Server=(lacal);DataBase=CMBX MDM;]'in access.
It sounds to me like you are trying to insert data from an MS-SQL Server database into a MySQL database but your post is really not clear.
If you are using MS-Access to do the job then you can set up two ODBC connections, one to the MS-SQL data and the other to MySQL, then use MS-Access queries to move the data from one source to the other.
sorry,my problem is not be expressed clearly.indeed ,I am trying to insert data from an MS-SQL Server database into a MySQL database ,MS-SQL use odbc or ado
but Mysql I use embedded mysql so i don't if i can insert data from a remote MS-SQL Server database into a embedded MySQL database in batch.
samely like 'insert into test01 selcct FROM Fund IN [ODBC] [ODBC;Driver=SQL Server;UID=admin;PWD=;Server=lacal);DataBase=CMBX
MDM;]' can i realize it ? thanks!