Tag: MySQL
-
Post Views: 18 1. In PHP, insert the JSON string (the Chinese has been encoded) into MySQL, and the Chinese has been encoded. as shown in Figure 1 2. Try to url decode the entire JSON string directly. Instead of converting JSON to an array, then traversing the array, url decoding each value, and finally encode the array into a…
-
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: 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: 19 1. When deleting the table in MySQL, an error is reported: 1217 – Cannot delete or update a parent row: a foreign key constraaint fail. as shown in Figure 1 2. Reference:You can get information about foreign keys from information_schema.key_column_usagetable. The query example for that table is shown here . as shown in Figure 2 3. The…
-
Post Views: 21 1. Existing code implementation 2. The final generated structure is as follows, which is an array with the field name: SETTING_MIGRATIONS 3. Decide to adjust the name of the adjustment field as extra, and include the value of the setting_migrations field. The code is adjusted as follows, based on the helper function ar. 4. The final generated…
-
Post Views: 22 1. The database migration implementation is as follows, and an index is added to the UUID type field. 2. After the migration is performed, the table field type is char(36). as shown in Figure 1 3. In the constructor of the model file, set the field value of the UUID type to: str::OrderDuUID() to take advantage of…