Mysql and PHP - Reading multiple insert queries from a file and executing at runtime

Posted by SpikETidE on Stack Overflow See other posts from Stack Overflow or by SpikETidE
Published on 2010-04-27T04:40:20Z Indexed on 2010/04/27 4:43 UTC
Read the original article Hit count: 263

Filed under:

mysql-query

|

multiple

|

insert

Hi everyone...

I am trying out a back-up and restore system. Basically, what i try to do is, when creating the back up i make a file which looks like

DELETE FROM bank_account; INSERT INTO bank_account VALUES('1', 'IB6872', 'Indian Bank', 'Indian Bank', '2', '1', '0', '0000-00-00 00:00:00', '1', '2010-04-13 17:09:05');INSERT INTO bank_account VALUES('2', 'IB7391', 'Indian Bank', 'Indian Bank', '3', '1', '0', '0000-00-00 00:00:00', '1', '2010-04-13 17:09:32');

and so on and so forth.

When i restore the db i just read the query from the file, save it to a string and then execute it over the DB using mysql_query();

The problem is, when i run the query through mysql_query(), the execution stops after the delete query with the error

'Error in syntax near '; INSERT INTO bank_account VALUES('1', 'IB6872', 'Indian Bank', 'Indian Bank', '2',' at line 1.

But when i run the queries directly over the Db, using phpmyadmin it executes without any errors.

As far as i can see, i can't notice any syntax error in the query. Can anyone point out where there might be a glitch...?

Thanks and regards....

© Stack Overflow or respective owner

Related posts about mysql-query

MySQL query returns different set of results on two identical databases

as seen on Stack Overflow - Search for 'Stack Overflow'
I exported a live MySQL database (running mysql 5.0.45) to a local copy (running mysql 5.1.33) with no errors upon import. There is a view in the database, that when executed locally, returns a different set of data than when executed remotely. It's returning 32 results instead of 63. When I execute… >>> More
What's wrong with my MySql query ?!

as seen on Stack Overflow - Search for 'Stack Overflow'
This is a query I am doing with mysql using PHP This is the query line <?php $query = "SELECT * FROM node WHERE type = 'student_report' AND uid = '{$uid}' LIMIT 1 ORDER BY created DESC"; ?> I get the following error You have an error in your SQL syntax; check the manual that corresponds… >>> More
Optimizing the MySQL Query Cache

as seen on Internet.com - Search for 'Internet.com'
MySQL's query cache is an impressive piece of engineering if sometimes misunderstood. Keeping it optimized and used efficiently can make a big difference in the overall throughput of your application, so it's worth taking a look under the hood, understanding it, and then keeping it tuned optimally. >>> More
index help for a MySQL query using greater-than operator and ORDER BY

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a table with at least a couple million rows and a schema of all integers that looks roughly like this: start stop first_user_id second_user_id The rows get pulled using the following queries: SELECT * FROM tbl_name WHERE stop >= M AND first_user_id=N AND second_user_id=N… >>> More
mysql query using jdbc

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi all, I have the following table: Service_ID feedback 31 1 32 1 33 1 1 I have the sample code to find the sum: ResultSet res = st.executeQuery("SELECT Service_ID,SUM(consumer_feedback)… >>> More

Related posts about multiple

Multiple Base Addresses and Multiple Endpoints in WCF

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm using two bindings TCP and HTTP. I want to give mex data on both bindings. What I want is that the mexHttpBinding only exposes the HTTP services while the mexTcpBinding exposes TCP services only. Or is this possible that I access stats service only from HTTP binding and the eventLogging service… >>> More
LINQ Query using Multiple From and Multiple Collections

as seen on Microsoft .NET Support Team - Search for 'Microsoft .NET Support Team'
1: using System; 2: using System.Collections.Generic; 3: using System.Linq; 4: using System.Text; 5: 6: namespace ConsoleApplication2 7: { 8: class Program 9: { 10: static void Main(string[] args) 11: { 12:… >>> More
How to avoid LinearAlloc Exceeded Capacity error android

as seen on Stack Overflow - Search for 'Stack Overflow'
The application gets crashing every-time, when am running eclipse saying LinearAlloc exceeded capacity (5242880), last=208 This is happening, when am creating AsyncTask, thats strange this is happening everytime . when am commenting and running its running. Logcat is: 02-09 04:02:23.374:… >>> More
Run MySQL INSERT Query multiple times (insert values into multiple tables)

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, basically, I have 3 tables; users and projects (which is a many-to-many relationship), then I have 'usersprojects' to allow the one-to-many formation. When a user adds a project, I need the project information stored and then the 'userid' and 'projectid' stored in the usersprojects table. It sounds… >>> More
Selecting multiple fields into multiple variables in a MySQL stored procedure

as seen on Stack Overflow - Search for 'Stack Overflow'
I am a little new to store procedures in MySQL and was wondering if I can SELECT multiple columns into multiple variables within the same select query. for example (iName is the input to the function): DECLARE iId INT(20); DECLARE dCreate DATETIME; SELECT Id INTO iId, dateCreated INTO dCreate… >>> More