Tag: MySQL 5.7
-
Post Views: 17 1. In MySQL 5.7, the data in the json type field is an array, and its value is:[365]. as shown in Figure 1 2. Reference: Query the constructor – where statement – json where statement:https://learnku.com/docs/laravel/6.x/queries/5171#35d9d9. JSON arrays can be queried using WhereJsonContains. as shown in Figure 2 3. The code is implemented as follows 4. Print the…
-
Post Views: 17 1. The original format of JSON data is as follows. The order of its key names is as follows: TexGetCux, QKGYGZ2st, YE9GC1KXT, Q1YQZ2RBI. as shown in Figure 1 2. Execute the code to insert the database as follows, print $extra[‘schema’] 3. Print $extra[‘schema’], which is equal to the original format of JSON data. as shown in Figure…
-
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: 18 1. Print the SQL statement executed by the program, and the result is as follows. as shown in Figure 1 2. The number of SQL statements executed by the print program is 79. Array elements start with 0. as shown in Figure 2 3. Print the SQL and copy it to MySQL 5.7 to execute. Its number…
-
Post Views: 19 1. When performing database migration, an error is reported: sqlstate[42000]: Syntax Error or Access Violation: 1059 Identifier nametheme_installation_version_preset_theme_store_theme_version_id_indexis too long. as shown in Figure 1 The index length limit of MySQL 5.7 defaults to 64, while the length of the Theme_Installation_Version_Preset_Theme_Store_Theme_Version_ID_Index is 68. as shown in Figure 2 3. In Laravel 6, each indexing method accepts an…
-
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: 17 1. In Navicat for MySQL, import the SQL file, and report an error when executing: 2006 – MySQL Server has gone away. as shown in Figure 1 2. The size of the imported SQL file is about 35MB. as shown in Figure 2 3. The reason is that the default settings of max_allowed_packet are very low. In…
-
Post Views: 22 1. At this stage, there is a new requirement, and it is necessary to do some initial data work for the product when deploying the product. Prepare the corresponding SQL file in advance. Since multiple SQL statements need to be executed, and subsequent SQL statements depend on the primary key ID generated by the previous SQL statement.…
-
Post Views: 19 1. Enter the CentOS server based on Xshell 6, compress and package the website program directory, execute the compression command, and the execution result is shown in Figure 1 2. Connect to the FTP server based on FlashFXP, download the compressed package: shuijingwanwq.com-20191203.zip to the local, as shown in Figure 2 3. Connect to the MySQL server…
-
Post Views: 15 1. Analysis of the SQL based on EXPLAIN is as follows, as shown in Figure 1 2. The index of the PA_plan_task table is shown in Figure 2 3. After adding the index: IDX_GROUP_ID, IDX_CREATE_USER_ID, IDX_IS_NOT_ISOLATED, the index of the PA_PLAN_TASK table is shown in Figure 3 4. Analysis of the first SQL based on EXPLAIN is…