Databases - MySql (Maria DB)

All lectures: All lectures at the Academy of Intelligence on the discipline: databases - mysql (maria db). 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. Exploding UTF-8 Russian (Cyrillic) letters in MySQL
12. MySQL aggregate functions and GROUP BY
13. Virtual columns in MySQL and their use cases
14. How to change the system character set and collation for a MySQL server
15. MS SQL: migrated databases attach in read-only mode only
16. MySQL: how to get a list of stored procedures or functions
17. SQL Server Express is not accessible over the network (via TCP/IP)
18. How to clear MySQL logs (transaction log or log table)
19. MySQL: how to copy a table (including to another database)
20. MySQL: how to set AUTO_INCREMENT to start from a value other than 1
21. SQL Server Express: scheduled jobs or automatic backups
22. Installing BDE (Borland Database Engine) on Windows Server 2008 R2 (or any x64 system)
23. bash/sh: working with MySQL from the command line or scripts
24. MySQL: how to change the maximum query length, or the "ERROR 1153 (08S01) at line 1: Got a packet bigger than 'max_allowed_packet' bytes" error
25. MySQL: the "too many connections" error, or how to change the maximum number of connections
26. IIS: ASP.NET не подключается с ошибкой "Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path..."
27. MySQL: how to enable query logging on a MySQL server
28. MySQL: importing a CSV file directly into a database table
29. MySQL: finding out database size from the console (bash/sh script or command line)
30. MySQL: optimizing the server with the mysqltuner script
31. Repairing a corrupted Firebird database
32. MySQL: restoring a database from a backup
33. MySQL: where is the my.cnf file located on Debian (Ubuntu), CentOS (RedHat), and FreeBSD
34. MySQL: how to back up a database
35. MySQL: the syntax of the CASE WHEN THEN ELSE query
36. How to move a MySQL table from one database to another
37. Truncating the transaction log in MS SQL 2008
38. Microsoft SQL Server error referencing sys.databases
39. MySQL GUI on Windows
40. Installing MySQL 5.1 on Windows Server
41. MySQL: searching for a value in a delimited string array
42. Concatenating SELECT output into a single string
43. MySQL: how to view processes (connections) or kill a specific process (connection)
44. MySQL: extracting a substring by index between delimiters
45. Counting specific characters in a MySQL column
46. DTS and MS SQL Server 2008 (on Windows Server 2008 R2)
47. Changing the MySQL root password (especially when it's lost)
48. Changing the MySQL data directory
49. Changing a MySQL user's password
50. Accessing MySQL over the network
51. MySQL: listing users, databases, tables, and their structure
52. How to get the total result count of a query with LIMIT in MySQL
53. Query with variables doesn't work in the MySQL + dbExpress + Delphi stack
54. Foreign key constraint error when adding a foreign key in MySQL
55. Exporting products from PrestaShop to OpenCart
56. MySQL equivalent of Excel's COUNTIF() function
57. Aggregate functions and nested aggregate functions or a subquery in the FROM clause, the difference between WHERE and HAVING, and query execution order
58. MySQL equivalent of Excel's AVERAGE(number1, number2, ...) function
59. Field value won't change to negative in dbForge Studio
60. MySQL SELECT query stopped working after moving to another hosting provider
61. How to temporarily disable triggers in MySQL
62. How to save SELECT INTO into multiple variables in a MySQL procedure
63. Installing MySQL with screenshots (a step-by-step guide)
64. Selecting the latest posts and comments in MySQL from a single table with parent and child rows
65. What is an ORM for? Thoughts on Doctrine
66. How to assign a clean URL to all products in OpenCart based on product name
67. Friends, friends of friends, and similar recommended products
68. Neo4j basics: creating, inserting, adding keys, deleting, and editing
69. How to select all users with at least one message in MySQL, along with each user's last message
70. Delete a parent post and all its child comments in a single MySQL query
71. MySQL server won't start: Plugin InnoDB registration as a STORAGE ENGINE failed
72. How to create a MySQL trigger that fires on UPDATE when a specific field changes
73. How to find out who is using the MySQL server and in what state
74. Cant update table in stored function/trigger because it is already used by statement which invoked this stored function/trigger
75. How to relate entities in Doctrine, the equivalent of an SQL JOIN
76. Foreign key won't create in dbForge Studio for MySQL: Cannot add or update a child row, a foreign key constraint fails
77. How to find the size of databases in MySQL
78. How to export all products from ShopFreeScript to OpenCart
79. Is it possible to write a MySQL query to find a chain of friends in a relational database?
80. MySQL errors
81. A MySQL error started appearing: Got error 28 from storage engine
82. MySQL hangs on UPDATE
83. How to get the last executed query in Symfony Doctrine
84. How to assign values to rows in MySQL based on rating
85. Deleting duplicate records in a MySQL table
86. Field id doesnt have a default value, SQL1.sql line 1
87. Rave Reports stopped working
88. How to determine rank (position) in MySQL based on the rating of users or products
89. Selecting the category with the most nested parent-child subcategories and building the category path in MySQL for OpenCart, an analog of Oracle's SYS_CONNECT_BY_PATH
90. How to select all users in MySQL along with their three latest photos (or groups and three latest photos per group)
91. How to write a MySQL audit trigger to log table changes
92. MySQL Error: Can't Create Table '...' (errno: 121)
93. How to install Oracle the easy way
94. How to Enter NULL into a Field in dbForge Studio
95. SELECT with different conditions
96. The client-server connection is very slow
97. MySQL discount table: a separate discount per client for each product group
98. Selecting a Random Record from MySQL with PHP and Smarty
99. MySQL query for the number of unread messages between two users
100. MySQL: How to view the last query and the full query log
101. How to write a MySQL query selecting the maximum value from each group with conditions
102. How to dump all MySQL tables with PHP on hosting without OUTFILE privileges
103. Creating a new database with mysqlcc: an illustrated guide
104. PDO PHP MySQL UPDATE Not Working
105. Alias not working in a MySQL INSERT statement
106. Page view increment not working: UPDATE table SET view=view+1
107. Can't delete a MySQL database via phpMyAdmin in Denwer
108. I want my own Postgres: a quick start with PostgreSQL and Foreign Data Wrappers
109. A Bash script for creating a database dump
110. Quick Start with PostgreSQL
111. NoSQL data stores and their use in .NET
112. MySQL SUM aggregate function returning wrong results when used with JOIN
113. Ways to merge several tables into one so record IDs match chronological order (consolidation)
114. The specifics of legal protection for software and databases
Complain