MySQL is a database product, not an ODBC front-end product. You need to use the tool you manipulate data with (ALpha, Access, Visual Basic, PHP etc.) to move the actual data between databases such as QuickBooks (via QODBC) and MySQL.
MySQL Server doesn't support the SELECT ... INTO TABLE Sybase SQL extension. Instead, MySQL Server supports the INSERT INTO ... SELECT standard SQL syntax, which is basically the same thing. For example:
INSERT INTO tbl_temp2 (fld_id) SELECT tbl_temp1.fld_order_id FROM tbl_temp1 WHERE tbl_temp1.fld_order_id > 100;
Alternatively, you can use SELECT ... INTO OUTFILE or CREATE TABLE ... SELECT. As of MySQL 5.0, you can use SELECT ... INTO with user-defined variables. The same syntax can also be used inside stored routines using cursors and local variables.
You can't use VB Demo to do this because VB Demo only supports a single ODBC connection. |