Answers for "how do i get all columns of table in mysql"

mysql all columns

-- MySQL
SELECT * 
FROM INFORMATION_SCHEMA.COLUMNS;

Posted by: Guest on May-15-2020

find a column in all tables mysql

SELECT DISTINCT TABLE_NAME 
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE COLUMN_NAME IN ('columnA','ColumnB')
        AND TABLE_SCHEMA='YourDatabase';

Posted by: Guest on April-08-2021

Source

Code answers related to "how do i get all columns of table in mysql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

Answers for "how do i get all columns of table in mysql"

Code answers related to "how do i get all columns of table in mysql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "how do i get all columns of table in mysql"

Code answers related to "how do i get all columns of table in mysql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us