I read a few books, wrote over requests

All in the style of web developers

Joyns and complex queries mastered

I heard that you can write functions and procedures in sql, is that true? if so how is it done?

And what else do I have to learn in order to know everything about MySQL in terms of query design?

And what is usually used to test query performance?

1 answer 1

True, functions and procedures are very often used in MySQL. Mysql Ref Manual. It ’s not possible to know everything, sql is already quite severe, it is better to start from incoming tasks.

Profiling can be used to test performance.