Get the different column names on two tables MySQL
ellaRT
I have two tables with almost identical column names : Here's a sample table
I want to get the columns names highlighted in red.
Any idea?
Giorgos Betsos
Try this:
SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'your_schema' AND
TABLE_NAME = 'table2' AND
COLUMN_NAME NOT IN (
SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'your_schema' AND
TABLE_NAME = 'table1');
The above query returns the column names of table2 not present in table1.
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
- Prev: Content Dialog in Windows 10 UAP
- Next: element-attribute-range-query fetching result but element-attribute-value-query is not fetching any result
Related
Related Related
- 1
Get the different column names on two tables MySQL
- 2
SQL UNION two tables with different column names
- 3
Get the difference of two column in two different tables?
- 4
SQL select rows from two different tables with different column names
- 5
Trying to retrieve names from 'name column' from two different tables
- 6
Join two tables with different column names and same rows
- 7
MySQL Get Different Records Bewteen Two Tables
- 8
Trying to get the difference of two different numbers in different tables in mysql
- 9
MYSQL Inner Join Two Tables Same Column name Different Value
- 10
Get result from two different tables using mysql
- 11
Get result from two different tables using mysql
- 12
Get a certain query result from two different mysql tables
- 13
Joining tables based on different column names
- 14
Search multiples tables with different column names for a string
- 15
mysql join two different tables
- 16
MySQL: JOIN two tables with matching row names
- 17
Joining two selects - different column names
- 18
Joining two selects - different column names
- 19
Joining two tables with different values in one column
- 20
How specify join variables with different names in different MySQL tables
- 21
MySQL INNER JOIN with different column names
- 22
How to combine two tables in MySQL which have only one common column and other are different?
- 23
How to get sum total of particular column from two different tables and print it
- 24
Concentrate two rows in mysql, but keep column names
- 25
MYSQL / PHP - merge two tables with different columns
- 26
Compare two columns in different tables in MySQL
- 27
Compare two values from different tables - MySql
- 28
Combining results of two different tables in MYSQL
- 29
mySQL sum of two values in 2 different tables
Comments