weixin_43697585的博客

mysql 8.0 及以上版本mysql -u root -puse mysql;ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123123'; # 123123是密码，root是用户名flush privileges;quit;➜ ~ mysql -u root -pEnter password: Welcome to the MySQL monitor. Commands

eg : house_date字段的值为2013.03.02，提取 2013.03方法一 DATE_FORMAT() 函数SELECT DATE_FORMAT(house_date,'%Y.%m') as month ,house_date from record limit 10运行发现，有些日期格式本身就是年月，这样的数据会出现问题方法二left(str, length)函数 【从左开始截取，right()从右开始截取】substring(str, pos,[length]) 函数

select GROUP_CONCAT(column_name) as column_name,GROUP_CONCAT(data_type) as data_typefrom information_schema.columns where table_name='d_area' and table_schema='house'或select GROUP_CONCAT("`",column_name,"`") as column_name,GROUP_CONCAT(data_type) .

客户端报错：2003 - Can’t connect to MySQL server on ‘127.0.0.1’ (61 “Connection refused”)终端报错：ERROR 2002 (HY000): Can’t connect to local MySQL server through socket '/tmp/mysql.sock’报错原因是由于mysql服务没打开1...