I want to use MySQL database soI need to know SQL which is used for MySQL because I read SQL/PL SQL by ivan bayros a couple of years ago, I found SQL for Oracle & MySQL is little different so I will use MySQL in company, want to learn SQL for MySQL database till that depth so I'll be able to deal with more than 100000 records in database. Please any book suggestion ?
Unless you're a database administrator you're not going to need to know MySQL 100% inside and out.
For example, knowing the difference between WHERE and HAVING is probably never going to come up in your work (They result in the same data, but WHERE filters at the source while HAVING filters the data once you've received it all).
On the other hand, you'll definitely need to know basic stuff like the CRUD statements (select, update, etc), the various joins involved in SQL, UNION, concatenation of strings, date/time manipulation, prepared statements and I'm sure some other things that I can't quite recall at the moment.
Your milage may vary of course, as I'm sure I have limited experience in MySQL when compared to other Ranchers.
Also, I should mention that I've never owned an SQL book outside of the absolutely most basic introductory books on the subject.
@ Marc yes I just need to know how to make efficient queries like using joins and all ( I won't remember all of them now as I had read few years ago ) so I could fetch my data in proper manner. I found some site I can't mention here as per rule which teaches basic things except procedures, triggers like those things. I did programs of procedure and triggers long time ago but don't know its usage. Anyway will learning start by today. Thank you for help