Category: MySQL
-
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…
-
Post Views: 50 1. In the production environment, the data in the skill data table is repeatedly written, as shown in Figure 1 2. However, before writing, it is judged whether the record exists. The combination of GAME_CODE and TEAM_CODE should be the only one, as shown in Figure 2 3. It is recommended to check the website first: https://www.shuijingwanwq.com/2017/04/18/1568/…
-
Post Views: 15 1. Please refer to the previous blog:https://www.shuijingwanwq.com/en/2016/11/26/10288/ 2. Prepare to implement RESTful web services based on shujujixi 3. Based on the GII generation model on the Frontend application, edit \environments\dev\frontend\config\main-local.php, as shown in Figure 1 4. Execute .\init in Windows PowerShell to overwrite \frontend\config\main-local.php, and set the IP allowed by GII, as shown in Figure 2 5.…
-
Post Views: 14 1. Install yii2-starter-kit under Windows 10 and Nginx 1.10, and run on the command line: php console/yii app/setup, as shown in Figure 1 2. Error: create unique index IDx_article_slug on {{%article}} (slug) …exception: sqlstate[42000]: Syntax error or access Violation: 1071 specific key was too long; max key length is 767 bytes, as shown in Figure 2 Translation:…
-
Post Views: 14 An error is reported in this step, but the screenshot is not sorted, and finally I have to modify $cfg on the server phpmyadmin[‘Servers’][$i][‘controlhost’]=localhost; Only the steps to successfully copy the root user successfully realize the successful step.
-
Post Views: 14
-
Post Views: 13
-
Post Views: 14 In order to make the test environment of the intranet as much as possible to the online production environment, the httpd, ftp, mysql, etc. of the intranet are all installed on the CentOS 6.5 64 bit, but my development environment is still Windows 8.1 64-bit, and the program is also in the development environment, so the problem…
-
Post Views: 11 Furtherhttp://localhost/phpmyadmin有时候会被跳转至http://www.localhost.com/phpmyadmin，最后的解决方案为： Insert after phpinidir “c:/php” in the httpd.conf file loadfile “c:/php/php5ts.dll” loadfile “c:/php/libmysql.dll” Just solved! The specific environment of this problem is Apache/2.2.15 (Win32) PHP/5.2.17 Database client version: libmysql – 5.0.51a php extension: mysqli documentation
-
Post Views: 8 Screenshot of problem: Since on the first installation, install TO did not select the default drive letter, but chose the D drive, which caused this problem to occur the first time, and later even if it was completely deleted through the 360 software housekeeper, and the registry was cleared, and even all the files and folders related…