230 Part II . SQL Essentials The DELETE
230 Part II . SQL Essentials The DELETE statement has two versions. The first version of the DELETE statement simply deletes from one table. The second version of the DELETEstatement enables deletion from multiple tables. I ll show a syntax example or two for each type of DELETE. DELETE FROM example1 WHERE ID = 1; DELETE FROM example1 ORDER by ID LIMIT 1; DELETE example1,example2 FROM example1,example2,example3 WHERE example1.ID = example2.ID AND example2.ID = example3.ID; In the last of these examples, any matching rows are deleted from the example1 and example2 tables only. Showing my true System Administrator colors, I admit that my favorite action is performing deletes. Few ways of starting a day are more rewarding than removing a few hundred thousand records. Summary MySQL includes a large number of commands and statements used for administration as well as performance tuning and informational purposes. These statements include the SHOW, DESCRIBE, and KILL. . MySQL also includes most ANSI92 compatibility in the Data Definition Language (DDL) statements. . MySQL extends the ANSI92 standard in some DDL statements. . As with DDL, MySQL features compatibility with most ANSI92 Data Markup Language (DML) statements. . Like DDL, MySQL extends the ANSI92 standard in the area of DML. …
Searching for affordable and reliable webhost to host and run your web applications? Go to our java web server services and you will be pleased.