Multiple Tables From Query Method

[Néo]

Well, I was about to ask the same question !

Additionally, if there where any feature to schedule this import, my replication problems would be totally rid off.

C'mon guys ! you're just so close to the ultimate replication solution !

[mbrown]

a point of clarification:

it executes all of the statements, but only returns the first resultset.

for example:

Code:

declare @field int;
set @field = 'value';
select * from table1 where field1 = @field;
select * from table2 where field1 = @field;

it will declare the variable and set it equal to the value and excute the queries, but only the results from table1 will be returned.

[Shadow]

Neo: scheduling ODBC import is planned for SQLyog MAX.

[Ritesh]

mbrown wrote on Apr 15 2004, 02:30 PM:

When doing an ODBC import is there a way to get the results of more than one query? When I select “Copy table(s) from the data source” I get the option to select multiple tables. When I select “Use a query to select the data to transfer” I only get the results from the first query I type in the window.

For example if I enter this in the query window:

Code:

select * from table1 where field1 = 'a';
select * from table2 where field1 = 'b';

It will return one table called “Result” that has the results of the first query only.

Is there a way to get both of the queries to execute?

SQLyog imports data from the first query only.

This is a nice feature request. I have forwarded it to my development team. Thanks for the suggestion 😀

[Author]

Posts