|
Hi all
Anyone know which would be quicker on a huge
(couple of million records) on mySQL?
UPDATE
table_name
SET
field1 = <cfqueryparam
value="W" cfsqltype="CF_SQL_CHAR">
WHERE
primary_key of table IN (<cfqueryparam value="#some_list#" cfsqltype="CF_SQL_NUMERIC" list="Yes">) OR
UPDATE
table_name
SET
field1 = <cfqueryparam
value="W" cfsqltype="CF_SQL_CHAR">
WHERE
1=1
<cfloop list="#some_list#" index="i">
AND field1 = <cfqueryparam value="#i#" cfsqltype="CF_SQL_NUMERIC"> </cfloop> Thanks for your help
Gavin You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ |
