家里PC上面装的MYSQL8.0,平常都是用的workbench,
操作失误,需要数据回滚,结果一直语法错误,如下:
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysqlbinlog --start-date="2022-08-10 18:15:00" --stop-date="2022-08-10 18:18:00"' at line 1
代码如下:
mysqlbinlog --start-date="2022-08-10 18:15:00" --stop-date="2022-08-10 18:18:00" --database=tongdao mysql-bin.000010 | mysql-uroot -p123456;
F:/Data/tongdao/mysqlbinlog --start-datetime="2022-08-10 18:15:00" --stop-datetime="2022-08-10 18:18:00" F:/Data/mysql-bin.000010 | F:/Data/mysql-uroot -p123456 -v td;
网上的试了很多代码都不管用