Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Inserting results from previous query not possible #247

Closed
prkwcz opened this issue Jan 2, 2020 · 0 comments
Closed

Inserting results from previous query not possible #247

prkwcz opened this issue Jan 2, 2020 · 0 comments

Comments

@prkwcz
Copy link

@prkwcz prkwcz commented Jan 2, 2020

I have a script that collects data from different sources and imports it into a MariaDB database.
Practically it looks like this:

// Getting all the necessary import sets
$db1Result = $db1->fetchAll("SELECT A, B, C FROM XYZ");

//Importing to the new database
$db2->query("INSERT INTO ZYX", $db1Result);

But then I always get the following error message:
Automaticaly detected multi-insert, but values aren't array. If you need try to change mode like "?[and|or|set|values|order]". Mode "values" was used.

In fact, this seems to be a bug in version 3. Here it seems that no ResultSet is accepted as input for the insert anymore.

@dg dg closed this as completed in ce231f5 Jan 2, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Development

No branches or pull requests

1 participant