MYSQL Compare data in different Databases

Following statement will compare values in two databases and gives you records that not matched.

SELECT stage,live,path,scope_id FROM
(
SELECT 
    (CASE
        WHEN (S.value = L.value) THEN ''
        ELSE 'N/M'
    END) as matched,
    S.scope_id,
    S.path,
    S.value AS 'stage',
    L.value AS 'live'
FROM
    cin_stage.core_config_data S
        INNER JOIN
    cin_live.core_config_data L ON S.path = L.path
) RES
WHERE matched = 'N/M'
ORDER BY scope_id

Comments

Dual Screen Script for Ubuntu

I have experienced problems when installing two monitors in Ubuntu. Following script will help you to solve this problem. I had problems when saving below values so I created a script and put it to the startup. #!/bin/sh xrandr --output VGA-0 --mode 1920x1080 --pos 1280x0 --rotate normal --output DVI-I-1 --off --output DVI-I-0 --mode 1280x1024 --pos 0x0 --rotate normal --output HDMI-0 --off

How To Disable Export Button In Crystal Report When you are taking crystal report printouts through a program, such as program written using vb6. you might have a problem how to disable Export button in print preview. All you have to change following property to false or Uncheck the Export option in Property Pages. You CR.WindowShowExportBtn = False Crystal Report Object in Visual Basic 6. (CR is refer to Crystal Report Object ) You can go to Property Pages by right click and choose Properties on Crystal Report Object After you done those things you crystal Report print preview will showing like follows. I was face to above problem. We implemented a software program which is written using vb6. Cashier can take daily sale print out. before printing it is showing a preview to the user. So when the time pass user click export button and saved that report as a excel file. Then he modified the values and took printout to the management. That gives Security problem to the program a...

My Programming Life

Search This Blog