1、mysql下载

正常查询语句中TOP的运用:

使用mysqldump 指令:

下载地址:https://dev.mysql.com/downloads/mysql/5.6.html
下载以下安装包:
MySQL-client-5.6.33-1.el6.x86_64.rpm
MySQL-devel-5.6.33-1.el6.x86_64.rpm
MySQL-server-5.6.33-1.el6.x86_64.rpm

SELECT TOP
1000 *

D:\>mysqldump -u root -proot bookStore>bookStore.sql

2、查看是否已经安装了mysql,有则移除

FROM MP_MemberGrade

 

rpm -qa|grep -i mysql
mysql-libs-5.1.66-2.el6_3.x86_64
yum -y remove mysql-libs*

 

3、安装mysql5.6

随意更新一张表中满足条件的前N条数据:

rpm -ivh MySQL-client-5.6.33-1.el6.x86_64.rpm
rpm -ivh MySQL-devel-5.6.33-1.el6.x86_64.rpm
rpm -ivh MySQL-server-5.6.33-1.el6.x86_64.rpm
cp /usr/share/mysql/my-default.cnf /etc/my.cn

UPDATE TOP
(1) MP_Member SET FKGradeID=2

4、初始化MySQL及设置密码

WHERE IsDeleted=2

/usr/bin/mysql_install_db
service mysql start
cat /root/.mysql_secret
mysql -uroot -p初始密码
set PASSWORD=PASSWORD('123456');
exit

 

5、开启远程访问

更新A表中满足B表前N条记录的数据

发表评论

电子邮件地址不会被公开。 必填项已用*标注