Category: MySQL 5.7
-
Post Views: 20 This article is a development environment for the ‘From Windows to Ubuntu: Complete Guide to Migration and Configuration’ series.It is suitable for developers who have completed the Ubuntu system installation and hope to build an efficient, isolated and multi-version database environment. Why use Docker to manage databases? Under Windows, I am used to running a separate database…
-
Post Views: 23 When displaying code snippets containing emoji in WordPress, it is often encountered that Emoji is converted into 🎉 Or <img> label problem. This article records a complete investigation and solution process. problem In the code block of the WordPress Gutenburg editor, write the following PHP code, as shown in Figure 1: After saving the article, the front…
-
Post Views: 18 1. After downloading the installation package of MySQL 8.0, start the installation. The process prompts: Select products to upgrade. using this wizard you will be able to update your installed products. upgradeable products. MySQL Server can be upgraded from 5.7.19 to 5.7.44. Can’t upgrade to 8.0. as shown in Figure 1 2. Decide to back up the…
-
Post Views: 52 1. When clearing the table in MySQL 5.7, there are more than 3 million records in the table, and when there are more than 2 million records left, prompt: 1206 – The total number of locks Exceeds the lock tablesize. as shown in Figure 1 2. Reference: The total number of locks exceds. 3. This problem can…
-
Post Views: 19 1. The values in the JSON field are as follows. The fields to query: $.current.sections.announcement-bar.blocks.*.settings.text. The field key corresponding to * is unknown. as shown in Figure 1 2. The final sql is as follows, the query result is an array, if it does not exist, it is null. as shown in Figure 2 3. Announcement-bar needs…
-
Post Views: 17 1. The json field is stored in the array format, the value example:[249, 247, 250, 244, 243, 255, 246, 245, 257, 248, 259, 252, 256]. as shown in Figure 1 2. The existing code running in the queue job is implemented as follows, the generated SQL is as follows 3. Since the queue tasks can be run…
-
Post Views: 13 1. The field table2_id in the table table1 is associated with the primary key field ID of the table table2. Now you need to query data that exists in table table1 but not in table table2 . The final implementation of SQL is as follows. as shown in Figure 1
-
Post Views: 19 1. When deleting the table in MySQL, an error is reported: 1217 – Cannot delete or update a parent row: a foreign key constraaint fail. as shown in Figure 1 2. Reference:You can get information about foreign keys from information_schema.key_column_usagetable. The query example for that table is shown here . as shown in Figure 2 3. The…
-
Post Views: 19 1. Reference:Deploy Shopify PHP application to production environment (CentOS 7.7 64-bit in Alibaba Cloud, ECS, MySQL 5.7) 2. When the application: learn-php-app-ubuntu-2004-0605 is newly created and deployed the theme application extension. The test passed, in line with expectations. as shown in Figure 1 3. Upload the application in the local environment: learn-php-app-ubuntu-2004-0605 Web The code below is…