View Issue Details

IDProjectCategoryView StatusLast Update
0008357New Feature Requests[All Projects] Generalpublic2017-06-18 20:56
ReporterasturelAssigned To 
PrioritynormalSeverityfeatureReproducibilityalways
Status newResolutionopen 
Summary0008357: [Request] Multiple query statements support in dbExec
Description

It would be great that we could execute many query in one 'query'. When the resource is stopping (e.g. saving lot of thing) the dbExec 'blocks' (it waits until the query queue isnt done), truncating it into one query reduces more than 10x the wait time. Currently the only way is to use set field = case .. when ... statement (http://blog.bubble.ro/how-to-make-multiple-updates-using-a-single-query-in-mysql/), which is hard when we want to update more than one field.

Additional Information

http://dev.mysql.com/doc/refman/5.0/en/c-api-multiple-queries.html

TagsNo tags attached.

Activities

lil_Toady

2014-07-14 21:04

administrator   ~~0021340

This is more prone to sql injection

asturel

2014-07-14 21:34

reporter   ~~0021341

Well the current state of dbExec gives ability to sql injection too if you didnt escape it properly.. (it just didnt let you to use multiple queries..) so I dont rly understand why this is worser.. since you still can escape the strings properly

Issue History

Date Modified Username Field Change