MySQL Snippets in Cacher

All the mysql snippets will be starting with the keyword "mysql" which is used to filer out those snippets.

Syntax

mysql-<category>-<sub-category> what is does?

Category

1. table - queries related to a single table
2. join - queries related to combining diffrent sql queries or grouping multiple tables (UNION)
3. user - granting previlages to users, creating users etc..
4. database - creating,making dump, restore
5. string - queries related to string operation
6. date - queries operating with date
7. cond - conditional queries
8. cursor - queries related to handling cursors
9. index - index snippets
10. function - functions snippets
11. procedure - procedure snippets

SubCategory

1. duplicates - It is either to find or remove duplicates
2. create - create some thing
3. update - update some thing
4. delete - delete some thing
5. search - search through records and find the matching one's.