Database Reference
In-Depth Information
IGNORE 1 LINES
(prospect_name, prospect_email, prospect_country);
Query OK, 6 rows affected (0.02 sec)
Records: 5 Deleted: 1 Skipped: 0 Warnings: 0
SELECT * FROM birdwatchers.birdwatcher_prospects_import
WHERE prospect_name LIKE '%Sveta%' \G
*************************** 1. row ***************************
prospect_id: 26
prospect_name: Ms. Sveta A. Smirnova
prospect_email: bettasveta@gmail.com
prospect_country: Russia
Notice how the results message reads this time. It says that no rows were skipped, but one
was deleted. That's the replacement of the first entry for Sveta. You can see in the results
of the SELECT statement that the record containing her middle initial replaced the one
withoutit.
Search WWH ::




Custom Search