top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration

Facebook Login
Site Registration

How to Use Caution with SQL Server's MERGE Statement ?

+3 votes
87 views
How to Use Caution with SQL Server's MERGE Statement ?
posted Nov 25, 2014 by Vrije Mani Upadhyay

Looking for an answer?  Promote on:
Facebook Share Button Twitter Share Button LinkedIn Share Button

Similar Questions
+3 votes

I am trying to understand MySQL statement based replication with LOAD DATA LOCAL INFILE statement'.

According to manual -
https://dev.mysql.com/doc/refman/5.0/en/replication-features-load.html -
LOAD DATA LOCAL INFILE is replicated as LOAD DATA LOCAL INFILE, however, I am seeing it replicated as 'LOAD DATA INFILE'.

I was wondering why slave isn't getting LOAD DATA LOCAL INFILE statements. Master is using MySQL 5.0 and slave is using MySQL 5.5

+1 vote

I have a website on my private webserver, which consist of some kind of a LAMP-server on a raspberry. Previously it ran on a laptop with Ubuntu and the same kind of LAMP-server. I'm trying to restore the SQL-backup from the old machine to restore with the raspberry. While finding the file and starting the restore is no problem, I get the following message and a full stop:

SELECT MAX( version )  FROM `phpmyadmin`.`pma_tracking` 
WHERE `db_name` = 'bbz' AND `table_name` = 'wp_links VALUES'
AND FIND_IN_SET( 'INSERT', tracking ) >0

MYSQL RETOURNEERDE: #1100 - Table 'pma_tracking' was not locked with LOCK TABLES
Since I do a full restore I'm processing the younameit.SQL file. I'm bad in interpreting the error messag, don't understand what it exactly mens and what I can do to cure this problem.

Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...