Solve This (? + ? + ?=30)
If 1111=R, 2222=T, 3333=E, 4444=N Then 5555=?
Guess the Hindi Muhawara from the following whatsapp Emoticons?
Sweet, Medicine, Film, Girl, City, Car, Place, Doggy all are name same, guess which word it is?
A girl is blind, deaf, dumb and uneducated too. A boy loves her. How would he propose without touching her?
Four Question, One Answer: One River Name, One Flower Name, One Film Name, One Actress Name?
Guess me who am I, I am the first on earth, the second in heaven...
Which Indian cricketer is known as "Brown Bradman"?
Ravindra Jadeja hit the highest score by an India No. 8 in ODIs, beating the 67 scored by who?
What superhero gained his powers after being exposed to the Orb of Ra?
This query it seems has two portions -
1. If the structure of both the tables is same
2. If structure is same then is the contents of both the table same.
If the structure of both the tables is same: following query will show the actual diff between table1 and table2 -
SELECT column_name,ordinal_position,data_type,column_type FROM
AND table_name IN ('
If structure is same then is the contents of both the table same: Assuming in the step 1 you find both the table structure is same then just find out the content of both are same or not (picking what Ajay has suggested) -
LEFT OUTER JOIN Second_table
ON First_table.id = Second_table.id
WHERE Second_table.id IS NULL
How can I insert data into one table from two other tables where i have three tables namely users, role and userrole.
Now I want to insert the data into userrole table from users table and role table with a single statement.
Joiner using how to get three tables value fetching from single query.
Forgot Your Password?
2018 © Queryhome