SELECT user_id,username,nick_name,dept_id,enabled FROM sys_user WHERE `status`='ENABLE' INTO OUTFILE '/home/flex/mysql/docs/用户20230324.xlsx';
mysqldump -uroot -p dy_pmis t_bom --where="PRO_ID=3557" > D:\mysqlbak\bom3.sql
注意:where后面单引号导不出insert语句,必须为双引号
mysqldump -uroot -ppassword --column-st
atistics=0 -h 172.16.2.13 -P 3306 DY_PMIS Task_User --where="Task_ID=319527" > d
:\Task_User_bak.sql
错误提示:
mysqldump: Couldn't execute 'SELECT COLUMN_NAME, JSON_EXTRACT(HISTOGRAM, '$."number-of-buckets-specified"') FROM information_schema.COLUMN_STATISTICS
原因:
因为新版的mysqldump默认启用了一个新标志,通过- -column-statistics=0
来禁用他
解决方法:
mysqldump --column-statistics=0 -h ip -u root -p dbname > db.sql;