using one SQL query

[The Little Guy]

instead of looping and using a mysql INSERT, UPDATE or DELETE, is it possible to insert using one command?

 

so... say I want to delete,insert, or update rows where the unique id numbers are 1,23,54,77,200

 

how would I do that in one sql query?

[phpSensei]

I don't think you can do this in one COMMAND, if you mean like ONE QUERY doing it all for you.

[The Little Guy]

what if they are all in an array?

 

I know someone on here posted that you can do it... I don't know who, or what thread it was.

[killsite]

I'm not sure of exactly what type of database you have but based on the calls I've received as a webhost tech rep, MsSQL - yes you can write multiple lines and run it in a single db call. If using MySQL 5 db engine, you can by using PHP's exec() function in the PHP5 object model.

 

 

With that, you should be able to pass one string for your queries. The only thing is you'll need command line root access in MySQL5. Be careful with coding this because the script will be prone to SQL injection hacks.. Yea, really really bad.

 

Not 100% if this helps you. Hopefully someone else can elaborate or point you in the right direction here.