Chapter 9 . SQL According to MySQL 229 Figure 9-57: A look at the product table prior to the UPDATE statements, the three UPDATE statements, and a look at the product table after the updates Delete The DELETE statement can be used to delete specific records or the entire contents of tables; its syntax is as follows: DELETE [LOW_PRIORITY | QUICK] FROM
[WHERE where_clause] [ORDER BY …] [LIMIT #] or DELETE [LOW_PRIORITY | QUICK]
[.*] [
[.*] …] FROM tablereferences [WHERE where_clause] I ll dispense with some syntactical commonalities among many of the DML statements. The LOW_PRIORITYkeyword causes the DELETE to wait until no other clients are using the table. The WHEREclause tells the DELETE statement which records to delete. The ORDER BY clause determines the order by which the DELETE will occur. The LIMITmodifier causes the DELETE to only delete the specified number of rows. Though not common to other DML statements, the QUICK modifier can assist to speed up certain DELETE statements.
Note: In case you are looking for affordable and reliable webhost to host and run your j2ee application check Vision J2ee Web Hosting services.
This entry was posted
on Sunday, July 29th, 2007 at 2:25 am and is filed under Domain.
You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.