Skip to main content

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
Labels:

Comments

Post a Comment

Popular posts from this blog

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...
Post a Comment
Read more

Expire Session When the Browser Close [Codeigniter]

I wanted user to log again to the site whenever they close the browser. i searched everywhere and i found the easiest way. application/config/config.php sess_expire_on_close = TRUE Easy Session Preferences You'll find the following Session related preferences in your file: Preference Default Options Description sess_cookie_name ci_session None The name you want the session cookie saved as. sess_expiration 7200 None The number of seconds you would like the session to last. The default value is 2 hours (7200 seconds). If you would like a non-expiring session set the value to zero: 0 sess_expire_on_close FALSE TRUE/FALSE (boolean) Whether to cause the session to expire automatically when the browser window is closed. sess_encrypt_cookie FALSE TRUE/FALSE (boolean) Whether to encrypt the session data. sess_use_database FALSE TRUE/FALSE (boolean) Whether to save the session data to a database. You must...
3 comments
Read more

Remove comma from a String in Crystal Reports

I have a little problem regarding with following in Crystal Report "Salary Sheet For "+ Monthname (month({PrintPaySlip;1.Salary_Date}))+ " "+ totext(TONumber({@FYear})) Outout will be like follwos. Salary Sheet For January 2,010 What i want is like follows (Without the comma) Salary Sheet For January 2010 So the soultion would be like this. "Salary Sheet For "+ Monthname (month({PrintPaySlip;1.Salary_Date}))+ " "+ totext(TONumber({@FYear}),0,"") Thanks for looking a simple function. but if you dont know.... it'll become Difficult.... Learn everything.... impossible but give a try...
1 comment
Read more