ashbringerhui的博客

1、查找数据库表里包含某个文字 select * from book where bName like '%典%'; 2、插入数据到表里这里用到INSER INTO +表名（）VALUE INSERT INTO book (id,bNAME,price,author,pubdate) VALUE (004,'爵迹','80','3','2021-07-13'); 3、列出表的列信息 show columns from book; 4、列出MySQL Server上的数据库 SHOW DATABA

查看是否有安装过mysql rpm -qa | grep -i mysql find / -name mysql 有目录就rm -rf删除 rpm -e mysql80-community-release-el7-3.noarch 配置Mysql安装源 sudo rpm -Uvh https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm 安装Mysql 8.0 sudo yum --enablerepo=mysq