Tag: Expression
-
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: 17 1. Get the task list of the application of the Penguin, the list is empty, as shown in Figure 1 2. Types of published articles: standard (normal, graphic) articles, successful publishing (that is, the storage is successful), check the sql statement of the publishing task, as shown in Figure 2 3. Get the task list of the…
-
Post Views: 17 1. Table: Fields in pub_log: The type of data is: text, as shown in Figure 1 2. Table: field in pub_log: data structure of data is: json, the formatted data is as follows, as shown in Figure 2 3. The current requirement is that if “channel_app_task_status”: 6, it needs to be changed to: “channel_app_task_status”: 7, that is,…
-
Post Views: 16 1. Reference URL:https://www.shuijingwanwq.com/2019/08/15/3427/ 2. Update table: field in channel_app_source: The value of Permission is: 3, as shown in Figure 1 3. Based on the database migration command, generate the implementation of a SQL as shown above, edit \console\migrations\m190815_020034_permission.php 4. Execute the database migration command, as shown in Figure 2 5. Check the table: the field in channel_app_source:…
-
Post Views: 53 1. Use updateAll() to update the value of prev_status to the value of status, and update the value of status to 4, the table structure is shown in Figure 1 2. Based on the query builder, the code is as follows 3. However, it does not meet the expectations. The values of prev_status are updated with 0,…