Data Manipulation statements...

[rch10007]

Does anyone have a comprehensive list of DM statements they will share. I have started a list but my lack of experience leaves me wondering what I have forgotten. I know I can get them from chapter 13 in the MySQL manual, BUT it would be nice if someone can simplify the manual into a comprehensive list here to share.

Here's what I got so far:

DELETE
-- FROM -- WHERE -- ORDER BY -- LIMIT -- USING
DO

HANDLER
-- OPEN -- READ -- CLOSE
INSERT
-- INTO -- VALUES
LOAD DATA INFILE
-- INTO TABLE
REPLACE
-- INTO -- VALUES -- SET -- SELECT
SELECT
-- * -- ALL -- FROM -- WHERE -- GROUP BY -- HAVING -- ORDER BY -- LIMIT
TRUNCATE
-- TABLE
UPDATE
-- SET -- WHERE -- ORDER BY -- LIMIT


I was hoping someone has already created a "working copy" of this! If you do, PLEASE, upload the file or copy it into here so I can get the COMPLETE list of statements.

Thanks ALOT! :D

[Bootsman123]

Why give an incomplete list instead of referring to:
http://dev.mysql.com/doc/mysql/en/data-manipulation.html

[rch10007]

Does anyone have a comprehensive list...

I wasn't trying to give anything - above is an example so you can get an idea of what I meant by comprehensive.

I know I can get them from chapter 13 in the MySQL manual, BUT...

As you can see - I already knew that... In case you didn't understand, here it is again:
...hoping someone has already created a "working copy"...