statement syntax

[Itshim]

Other than INSERT, UPDATE, and DELETE, are there any other 'words' which being a SQL statement to alter data in a MySQL database?

I know this may seem like a strange question, but it's kind of important for a project I am working on.

Thanks,
Itshim

 

[TonyGroves]

Well, there's REPLACE, TRUNCATE, LOAD, RESTORE ...

(I hope it's not a student project you're talking about!)

 

[Itshim]

Thank you very much.

No, it is not a school project, I have been toying with creating an abstract SQL class in PHP, I know there are a ton out there but I am using it more to learn from then for actual use.

Thanks again,
Itshim