Tag: MySQL 5.7
-
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: 20 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…
-
Post Views: 155 1. There is a Shopify PHP application, which can already be previewed in the development environment. as shown in Figure 1 2. Now it is ready to be deployed to the production environment. Shopify recommends creating a separate application if you need to deploy the application to the production environment. This application shares the code base with…
-
Post Views: 15 1. In the MySQL table, the field type is JSON, and it is allowed to be null. as shown in Figure 1 2. Since only is_null() is judged in the program, if it is not null, the default is json format. When its value is String(4) “NULL”, the program throws a 500 exception. Displayed as null, indicating…