Yort

Mysql 常用 SQL 语句集锦基础篇//查询时间，友好提示$sql = "select date_format(create_time, '%Y-%m-%d') as day from table_name";//int 时间戳类型$sql = "select from_unixtime(create_time, '%Y-%m-%d') as day from

ubuntu 16.04 mysql-5.7安装:$ sudo apt-get install software-properties-common$ sudo add-apt-repository -y ppa:ondrej/mysql-5.7$ sudo apt-get update$ sudo apt-get install mysql-server其它版本请参考：https://te

ERROR 1366 (HY000): Incorrect string value错误解决办法通过命令查看Mysql默认字符集的相关设置