厚积薄发博客

先是最简单的句子，但是报错1093是查询出的不能直接update然后百度，外面套上一层select * from ，还是报错，查询出的表必须有个别名，然后指定别名 查询成功启动，执行效率真心慢！bug 2阶段：但是以上删除动作只能删除字段里面存在不一样的情况，我还有2万多条 三个字段值全一样的数据。。。。服了真

Loading class com.mysql.jdbc.Driver'. This is deprecated. The new driver class iscom.mysql.cj.jdbc.Driver’. The driver is automatically registered via the SPI and manual loading of the driver class is

mysql> show database;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 'database' at line 1...

卸载mariadb 因为7以上的centos自带mariadb，所以我们先要卸载它 查看是否已安装：rpm -qa | grep -i mariadb 卸载：rpm -qa | grep mariadb | xargs rpm -e --nodeps 然后再次输入查看命令，则不再显示，说明卸载成功下载mys...

Access denied for user 'root'@'192.168.1.148' (using password: YES)是因为没有正确的开放mysql远程权限mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;mysql> FLUS...

查看有多少mysql资源[root@lch software]# docker search mysql选择5.7下载,并配置用户名密码，并设置为开机启动容器[root@lch software]# docker run --restart=always --name mysql-1 -p 3306:3306 -e MYSQL\_ROOT\_PASSWORD=root -d ...