you know the proper WHERE clause to select the desired record, so the DELETE query can be constructed correctly


MySQL Tutorial			Previous Next

From that you can see the need to be more specific:

mysql> SELECT last_name, first_name FROM president
-> WHERE last_name='Roosevelt' AND first_name='Theodore';

last_name	first_name
Roosevelt	Theodore

Now you know the proper WHERE clause to select the desired record, so the DELETE query can be constructed correctly:

mysql> DELETE FROM president
-> WHERE last_name='Roosevelt' AND first_name='Theodore';

This seems like a lot of work to delete a record, doesn't it? Better safe than sorry! (This is the type of situation in which you'll want to minimize typing through the use of copy and paste or input line-editing techniques. See the "Tips for Interacting with mysql" section later in this chapter for more information.)

To modify existing records, use UPDATE, which has the following form:

Previous Next

Link Partners: Asia florist, Flowers to India, Hong kong flowers, Site submit, Cheap web hosting, China florist, Japan florist