Tag: utf8mb4_unicode_ci
-
Post Views: 15 1. Request parameter: filter[and][0][or][0][title][like]=\, the generated sql is as follows, the search result is empty. as shown in Figure 1 2. Check the value of the field title in the table plan, one of the records exists \. In theory, it is possible to query a record. as shown in Figure 2 3. Execute SQL in Navicat…
-
Post Views: 53 1. In the development environment, the execution of the database migration command fails: 1071 Specified key was too long; Max key length is 767 bytes, as shown in Figure 17 2. Run sql in the database in the development environment, and report an error: #1071 – specific key was too long; max key length is 767 bytes,…
-
Post Views: 64 1. Create a new warehouse, shuijingwan/yii2-app-advanced, as shown in Figure 1 Yii 2 advanced project template, the template includes four layers: interface (the API to implement the RESTful style web service service), front-end, back-end and console, each of which is a separate YII application. 2. Successfully created the warehouse, as shown in Figure 2 3. Use the…