Tag: MySQL
-
Post Views: 16 1. Execute SQL as follows 2. Error: 1093 – you canT specific target tablexx_themesfor update in from clause. as shown in Figure 1 3. Reference:https://dev.mysql.com/doc/refman/5.7/en/update.html, in MySQL, you cannot modify the same table used in the Select section. You can connect the table to itself, which will cause MySQL to treat the table as two different things,…
-
Post Views: 22 1. Now for an API, 4 tables need to be inserted. The 1st table is the table in database A, and the other 3 tables are the table in database B, and the primary key of the 1st table will be inserted into the 2nd table. 2 database connections have been configured. are WordPress and DB respectively.…
-
Post Views: 19 1. Refer to the template source code editing in the Shopify background, when uploading a file greater than 50 MB, the response 413 request entity too large. This should be limited by the settings of the Nginx server: client_max_body_size 50M . as shown in Figure 1 2. When uploading a 48.5 MB CSS file, it takes 2…
-
Post Views: 14 1. The data in the table is as follows 2. When executing a where like query, use likelayouts\\%Attempts to query the data rows starting with Layouts\. The result is empty. as shown in Figure 1 3. When executing a where like query, use likelayouts\\\%Attempts to query the data rows starting with Layouts\. Only the corresponding results are…
-
Post Views: 21 1. Reference URL:https://www.shuijingwanwq.com/2021/12/29/5622/, Laravel 8.x is deployed to Heroku, based on PostgreSQL implementation. Therefore, some steps can be omitted. 2. In the local development environment, the Laravel native environment has been deployed. Open URL:http://larabbs.local/, the response 200. as shown in Figure 1 3. Verify your installation, to verify your CLI installation, use the heroku –version command. Current…
-
Post Views: 15 1. Execute the command: docker exec -i object-mysql mysql -uroot -proot object_store < object_store.sql , error: mysql:[Warning]Using a password on the command line interface can be inspect. as shown in Figure 1 2. Enter the mysql container, view the database Object_store, and display all the tables, response: Empty set (0.00 sec). as shown in Figure 2 3.…
-
Post Views: 111 1. Laravel Sail requires Windows 10 systems that support WSL 2. The 2004 version released in May 2020 only supports the WSL 2 function, so our system needs to be updated to the 2004 version equal to or greater than the 2004 version. To view the system version, you can use the winver command, refer to Windows…
-
Post Views: 16 1. At this stage, there are two environments in the public cloud. They are COM environments and CSP environments, respectively. COM environment container, as shown in Figure 1 2. Containers in the CSP environment. In the CSP environment, the 2 containers of the COM environment have been merged into one container. And a new container has been…
-
Post Views: 17 1. Query sql error: sqlstate[42000]: Syntax Error or Access Violation: 1055 expression #2 of select list is not in group by clause and contain Nonaggregated Columnmodel.group_idwhich is not functionally depend on columns in group by cluse; as shown in Figure 1 2. Connect mysql in the container and execute the command: mysql -h127.0.0.1 -u username -p password.…