| Package home | Report new bug | New search | Development Roadmap | Status: Open | Feedback | All | Closed Since Version 1.12.3 |
| Bug #1005 | affectedRows returns 0 for 'load data infile' | ||
|---|---|---|---|
| Submitted: | 2004-03-12 23:52 UTC | ||
| From: | rex at seas dot ucla dot edu | Assigned: | danielc |
| Status: | Closed | Package: | DB |
| PHP Version: | 4.3.3 | OS: | SunOS server7 5.8 Generic_1085 |
| Roadmaps: | (Not assigned) | ||
[2004-03-12 23:52 UTC] rex at seas dot ucla dot edu
Description:
------------
When using the mysql command of "LOAD DATA INFILE" and then checking how many rows were affected, I get a result of always zero.
Reproduce code:
---------------
$db = DB::connect($dsn);
$sql = "load data infile 'test.txt' replace into table test (key,data)";
$result = $db->query($sql);
$num_changes = $db->affectedRows();
Expected result:
----------------
The number of rows that are affected by the loading of data from the file.
Comments
[2004-03-13 16:11 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!