Category: MySQL 5.7
-
Post Views: 15 1. Error when adding foreign key constraints: sqlstate[23000]: Integrity Constraint Violation: 1452 cannot add or update a child row: a foreign key constraint fails . as shown in Figure 1 2. Analyze the reason, the record of the user ID equal to 9 exists in the topics, but it no longer exists in users. as shown in…
-
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: 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.…
-
Post Views: 15 1. Request parameter: filter[and][0][or][0][title][like]=\, the generated sql is as follows, the search result is empty. as shown in Figure 1 2. Check the value of the field title in the table plan, one of the records exists \. In theory, it is possible to query a record. as shown in Figure 2 3. Execute SQL in Navicat…
-
Post Views: 14 1. Mysql error: 1055 – expression #2 of select list is not in group by clause and contains nonaggregated columnmodel.group_idwhich is not functionally depend on columns in group by cluse; as shown in Figure 1 2. Execute the first SQL clause, no error is reported, and the query result is empty. as shown in Figure 2 3.…
-
Post Views: 14 1. The external network address of the Alibaba Cloud RDS MySQL instance has been applied to connect. as shown in Figure 1 2. Failed to connect in Navicat for MySQL, error: 2003 – CANT connect to mysql server onRM-BP(10060 “Unknown Error”). as shown in Figure 2 3. To access RDS through the external network, you need to…
-
Post Views: 20 1. The current requirements are as follows. Based on the time range of article publishing, it is necessary to filter account rankings based on the number of articles published. as shown in Figure 1 2. View the method file of the obtained account list, the code is as follows 3, gethttp://api.channel-pub-api.localhost/v1/channel-app-sources?group_id=015ce30b116ce86058fa6ab4fea4ac63&sort=-channel_app_task_count。Sometimes, when connecting two tables, you may…
-
Post Views: 14 1. Main table: CPA_CHANNEL_APP_TASK and Schedule: CPA_Task: many-to-one. as shown in Figure 1 2, table: cpa_task and Table: CPA_baijia_article|cpa_customize_article|cpa_douyin_article|cp a_netease_article|cpa_qq_article|cpa_weibo_article|cpa_wx_article The association relationship: one-on-one. Table: A record in cpa_task will only exist in Table: CPA_baijia_article|cpa_customize_article|cpa_douyin_article|cp a_netease_article|cpa_qq_article|cpa_weibo_article|cpa_wx_article in one of the tables. As shown in Figure 2, Figure 3, Figure 4 3. Table: CPA_baijia_article|cpa_customize_article|cpa_douyin_article|c PA_Netease_Article|CPA_QQ_Article|CPA_Weibo_Article|CPA_WX_Article…