Category: Database Management Tools
-
Post Views: 48 1. Execute the update statement in mysql workbench, the statement is as follows: 2. Error code: 1175, the specific error information is as follows:, as shown in Figure 1 3. Execute the update statement in phpmyadmin, the statement is as follows: the execution is successful, as shown in Figure 2 4. According to the prompts, to disable…
-
Post Views: 15 1. HTML escape characters appear in SyntaxHighlighter 3.x of WordPress 4.9.8, and newline tags are automatically added, etc., as shown in Figure 1 2. The expected format should not appear HTML escape characters, as shown in Figure 2 3. For a long time, there were no HTML escape characters. I am not sure whether it was caused…
-
Post Views: 15 1. Reference URL:https://docs.phpmyadmin.net/zh_CN/latest/setup.html#installing-using-composer 2. Install and run the command based on composer, as shown in Figure 1 3. Enter the phpmyadmin-localhost directory, update phpmyadmin to the latest version, and run the command, as shown in Figure 2 4. Use the installer to generate the configuration file: config.inc.php, open the browser and use the /setup suffix to access,…
-
Post Views: 53 1. Use updateAll() to update the value of prev_status to the value of status, and update the value of status to 4, the table structure is shown in Figure 1 2. Based on the query builder, the code is as follows 3. However, it does not meet the expectations. The values of prev_status are updated with 0,…
-
Post Views: 14 1. Since too large SQL files cannot be imported in phpmyadmin, I decided to import them in mysql query browser, as shown in Figure 1 2. The SQL file size is: 186MB, as shown in Figure 2 3. Click the Execute button to execute the script, as shown in Figure 3 4. During the execution process, the…
-
Post Views: 43 1. When running the SQL file, an error is reported:[ERR]2013 – Lost Connection to MySQL Server During During Query, as shown in Figure 1 [错误]2013 – Loss of connection to mysql server during query 2. Open the directory C:\ProgramData\MySQL\MySQL Server 5.7, edit the my.ini file, as shown in Figure 2 3. Change max_allowed_packet=4m to max_allowed_packet=256m, as shown…
-
Post Views: 11 1. The final expectation result is: modify the avatar in the player table, its value is: /storage/web/app/player_avatar/gzhou/579365.jpg, where gzhou is the value of the current record field TEAM_CODE, 579365 is the value of the current record field code, as shown in Figure 1 2. First modify the avatar of a record, and its SQL statement is successfully…