Skip to content
English
中文 (中国)
Eternal Night
There is no problem not worth solving, and no technology not worth learning!
Home
About Me & Cooperation
Programming Languages
Programming Dev
Web Frontend
Web App Dev
Blockchain
Mobile Dev
Site Builder
Blog Operations
Dev Tools
App Tools
Cloud
Server
Database
OS
Monitor & Manage
Category:
MySQL
Deploy Shopify PHP application to production environment (CentOS 7.7 64-bit in Alibaba Cloud, ECS, MySQL 5.7)
2023/07/13
Create an app in Ubuntu-20.04 in WSL2: Shopify App Template – PHP
2023/07/01
In PHP 7.4, MySQL 5.7, insert a field of type json, successfully insert the analysis of the value string(4) “null” (related to json_encode(null))
2023/05/10
Query the average of two column values (TytStamp) in MySQL 5.7
2023/04/06
Add fields to a table, which takes 180 seconds to optimize (allow newly added fields are null)
2023/03/10
In Laravel 6, use WHEREJSONContains to query the data in the JSON type field (structure is an array)
2022/12/27
In Laravel 6’s database migration, Doctrine\dbal\Exception : unknown database type enum requested when updating field properties, Doctrine\DBAL\Platforms\MySQL57Platform May not support it.
2022/12/26
The investigation and analysis of the page of the theme editor that is inconsistent with the actual page is not consistent with the actual page
2022/12/12
In Laravle 6, set the refactoring of mysql field type JSON value (implemented based on the helper function arr )
2022/11/11
In Navicat for MySQL, when the table is copied from one database to another, an error is reported:[ERR]1292 – Incorrect DateTime Value:0000-00-00 00:00:00for columnCREATED_AT_GMTAT ROW 1 (in MySQL 8.0)
2022/09/28
Previous Page
1
2
3
4
5
6
…
14
Next Page