Not the answer you need?
Register and ask your own question!

SQL Select with nolock keyword

vbgindiavbgindia EntrantCurrent User Role Beginner
Hi All

I have created a Percona Slave (version 5.1.61-rel13.2) for a MySQL Community Server (5.1.61-log)..

The problem is with the nolock keyword in the select statement and the SLAVE fails at the query. Manuall running the query also fails on the PErcona Slave..

I wanted to upgrade the master to PErcona, but because of this, I might be forced to install MySQL community edition on the slave..

Query output on both servers ==>

On Master (MySQL Community Edition) - mysql> select catid,status from table1 nolock where status=1;
+
+
+
| catid | status |
+
+
+
| 101 | 1 |
| 102 | 1 |
| 103 | 1 |
| 104 | 1 |
| 105 | 1 |
| 106 | 1 |
+
+
+
6 rows in set (0.00 sec)
====

On Slave (PErcona) ==> mysql> select catid,status from table1 nolock where status=1;

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 'nolock where status=1

=============

Please help...

Comments

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.