Tag: Query
-
Post Views: 20 1. When there are multiple rows of data in the table, the implementation is as follows. Error: call to a member function value() on null. as shown in Figure 1 2. The adjustment is realized as follows. When the record does not exist, the query result is NULL. When the record exists, the query result is int(6),…
-
Post Views: 22 1. Reference: In MySQL 8, the IN condition is used for multiple fields. 2. When you need to use the native expression query in Laravel 9, the in condition is used for multiple fields. WhereRaw and OrwhereRaw methods inject the native “Where” into your query. 3. Execute error: sqlstate[42000]: Syntax error or access Violation: 1064 you have…
-
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: 16 1. In Laravel 6, you need to query the penultimate record. as shown in Figure 1 2. Based on the reverse order, use LIMIT, the code is implemented as follows 3. The printing results are in line with expectations. as shown in Figure 2
-
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: 52 1. I have been notified of the account management fee collection fee of huobi.info, and decided to withdraw the remaining assets. as shown in Figure 1 2. The account management fee is collected every month, and the remaining assets are decided to be withdrawn. View email: Notice that the user’s currency withdrawal service in mainland China has…
-
Post Views: 21 1. URL:https://object.local/?oseid=2052A62hlvOV6hlqej5yS2MwoYpUxXTtMQQb, when a certain condition is met, you want to delete the query parameter: oseid and make the URL change to:https://object.local/. Don’t want to use 302 jump implementation. 2. The specific implementation is as follows 3. The printing results are as follows, in line with expectations. as shown in Figure 1
-
Post Views: 21 1. Add Template to create a template. as shown in Figure 1 2. Click the save button to view the network request. Request URL:https://xxx.myshopify.com/admin/themes/111/assets. Request method: POST. This is the REST implementation. as shown in Figure 2 Requested form data: Response data: 3. The API for creating template files is not implemented in GraphQL. Decided to refer…