Mysql insert more than one row in one query

Top sites by search query "mysql insert more than one row in one query"

  http://php.net/manual/en/function.mysql-affected-rows.php
If the last query was a DELETE query with no WHERE clause, all of the records will have been deleted from the table but this function will return zero with MySQL versions prior to 4.1.2. If a series of queries were run as a transaction and one query failed, the logic in the foreach loop of the transaction() method in class MySQLDB will not issue a ROLLBACK

  http://blog.sqlauthority.com/2008/07/02/sql-server-2008-insert-multiple-records-using-one-insert-statement-use-of-row-constructor/
Fill in your details below or click an icon to log in: Email (required) (Address never made public) Name (required) Website You are commenting using your WordPress.com account

MySQL :: MySQL 5.1 Reference Manual :: 13.2.5 INSERT Syntax

  http://dev.mysql.com/doc/refman/5.1/en/insert.html
The columns for which the statement provides values can be specified as follows: You can provide a comma-separated list of column names following the table name. SELECT, the statement returns an information string in this format: Records: 100 Duplicates: 0 Warnings: 0 Records indicates the number of rows processed by the statement

MySQL :: MySQL 5.0 Reference Manual :: 13.2.5.1 INSERT ... SELECT Syntax

  http://dev.mysql.com/doc/refman/5.0/en/insert-select.html
To avoid ambiguous column reference problems when the SELECT and the INSERT refer to the same table, provide a unique alias for each table used in the SELECT part, and qualify column names in that part with the appropriate alias. This means that, when using replication, there is no guarantee that such a SELECT returns rows in the same order on the master and the slave; this can lead to inconsistencies between them