#014320: support insert with multiple rows at once

Description:

In MySQL I can create multiple rows with one insert statement.

BTW. The example on
http://ezcomponents.org/docs/api/trunk/Database/ezcQueryInsert.htmlurl

gives the impression that exactly this is possible:


1.  $q = ezcDbInstance::get()->createInsertQuery();
2.  $q->insertInto( 'legends' )
3.         ->set( 'Gretzky', 99 )
4.         ->set( 'Lindros', 88 );
5.  $stmt = $q->prepare();
6.  $stmt->execute();

Looks like I'd insert one row Name => Gretzky, Age => 99 and another one Name => Lindros, Age => 88.


Environment:

Operating System:
PHP Version: (please be specific, like '4.4.3' or '5.1.5')
Database and version:
Browser (and version):


- Attachments

No attachments for this issue.


- Comments

As only MySQL does this, we can't support this for other databases and it doesn't make a whole lot of sense to support it then. Running it with bound variables is more efficient as well. I fixed the examples in rev. 9775.

#259909 by Derick Rethans on January 22nd, 2009 [Permanent Link]

- History
Properties
Type Enhancement
Priority Medium
Components Components » Database
Documentation
Affects Unknown
Fix Version -
Reporter Thomas Koch
Responsible -
Status 0 Closed
Resolution Won't Implement
Created January 22nd, 2009
Updated January 22nd, 2009
Resolved January 22nd, 2009
 
Navigation [Permanent Link]
Previous Issue
Back to Issues List
Next Issue: #015537
  Graph shows to small and truncated rotated axis labels