Mysql (maria db)

All lectures: All lectures on the discipline: mysql (maria db) 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. MYSQL Interview Questions and Answers

2. the cumulative total of mysql and total for each column

3. MySQL: the differences between MyISAM and InnoDB

4. Views (VIEW) in MySQL

5. Setting the correct time zone in php and mysql. Time Zones in MYSQL

6. Correct resizing of the innodb log (innodb_log_file_size)

7. Partitioning tables in mySQL

8. Regular expressions in mysql RLike REGEXP, operation or, and, escaping special characters

9. Working with hierarchical data in MySQL (Adjacency List List of Adjacent Vertices, Nested Set Nested Set, Materialized Path Materialized Path)

10. Using and analyzing indexes in MySQL (in WHERE and in JOIN queries)

11. IIS: ASP.NET не подключается с ошибкой "Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path..."