Greg McNulty
Reputation: 1466
How do I modify a row with an auto increment field?
Why is this creating a new row at the bottom with this data instead of modifying that specified row?
$sql = "
UPDATE products SET
productName = '$pname',
productDescription = '$pdes'
WHERE pID = '$pidmod'
";
WHERE pID='$pidmod' is the auto increment field.
Upvotes: 0
Views: 34
Answers (1)
ypercubeᵀᴹ
Reputation: 115520
An UPDATE statement does not add rows - unless there are triggers involved.
Upvotes: 3
Related Questions
- Alter a MySQL column to be AUTO_INCREMENT
- altering with auto_increment filed in MYISAM table
- ALTER TABLE AUTO INCREMENT
- Using php mysql set auto_increment primary value into other field
- Change AUTO_INCREMENT value
- Replace a AutoIncrement mysql row with another
- How to update field value to auto-increment field value?
- Updating a MySQL record with an auto-increment field as PK
- Change MySQL auto_increment value without affecting existing rows
- Update with an incremented value based on corresponding row