Category: SQL
-
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: 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: 15 1. The name of the table field is in the form of lowercase letters and underscores. as shown in Figure 1 2. The interface is implemented based on GraphQL, and the field name that is specified as the interface response must be in the form of hump. 3. Print the parser /modules/themestore/resolver/onlinestoreetheme/themeassesResolver.php method $themeAssets, the object property…
-
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: 21 1. Reference URL:https://www.shuijingwanwq.com/2021/12/29/5622/, Laravel 8.x is deployed to Heroku, based on PostgreSQL implementation. Therefore, some steps can be omitted. 2. In the local development environment, the Laravel native environment has been deployed. Open URL:http://larabbs.local/, the response 200. as shown in Figure 1 3. Verify your installation, to verify your CLI installation, use the heroku –version command. Current…
-
Post Views: 15 1. Execute the command: docker exec -i object-mysql mysql -uroot -proot object_store < object_store.sql , error: mysql:[Warning]Using a password on the command line interface can be inspect. as shown in Figure 1 2. Enter the mysql container, view the database Object_store, and display all the tables, response: Empty set (0.00 sec). as shown in Figure 2 3.…
-
Post Views: 16 1. At this stage, there are two environments in the public cloud. They are COM environments and CSP environments, respectively. COM environment container, as shown in Figure 1 2. Containers in the CSP environment. In the CSP environment, the 2 containers of the COM environment have been merged into one container. And a new container has been…
-
Post Views: 17 1. Query sql error: sqlstate[42000]: Syntax Error or Access Violation: 1055 expression #2 of select list is not in group by clause and contain Nonaggregated Columnmodel.group_idwhich is not functionally depend on columns in group by cluse; as shown in Figure 1 2. Connect mysql in the container and execute the command: mysql -h127.0.0.1 -u username -p password.…