You get a bonus - 1 coin for daily activity. Now you have 1 coin

Databases - error detection methods in sql application

All lectures: All lectures on the discipline: databases - error detection methods in sql application are collected here. These fascinating lectures provide us with the opportunity to explore the deep principles and phenomena underlying our knowledge and our desire to understand the world.

1. SQL errors 1. Single queries. 1. Request. ERROR 1064 (42000): You have an error in your SQL syntax

2. SQL errors 2. Invalid data received.

3. SQL errors 3. The database contains incorrect data or what to do with a problematic DML query.

4. SQL errors 4. Mixed cases.

5. 5. Alternative ways to search for a problem query. MySQL Proxy, online logging

6. general recommendations for detecting errors in SQL single queries

7. Errors in competitive requests 6. Interlocks.

8. Errors in concurrent SQL queries 7. Competitive transactions.

9. Errors in concurrent SQL queries / general recommendations

10. Other cases of SQL errors 8. Large data volumes. Got a packet bigger than 'max_allowed_packet' bytes

11. Other cases of SQL errors 9. Mysterious disappearance of the server. MySQL server has gone away

12. Other SQL Error Cases 10. Lost connection to MySQL server during query

13. Other cases of SQL errors are general guidelines.

14. 4. Techniques used for debugging Production applications used by SQL

15. Ways to copy and transfer MySQL and databases.