Category: MySQL 5.7
-
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: 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…
-
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: 22 1. Now for an API, 4 tables need to be inserted. The 1st table is the table in database A, and the other 3 tables are the table in database B, and the primary key of the 1st table will be inserted into the 2nd table. 2 database connections have been configured. are WordPress and DB respectively.…
-
Post Views: 19 1. Refer to the template source code editing in the Shopify background, when uploading a file greater than 50 MB, the response 413 request entity too large. This should be limited by the settings of the Nginx server: client_max_body_size 50M . as shown in Figure 1 2. When uploading a 48.5 MB CSS file, it takes 2…
-
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…