How to find tables that contain a specific column in SQL using Python?

Count SQL Table Column Using Python

Last Updated : 23 Dec, 2020

Prerequisite: Python: MySQL Create Table

In this article, we are going to see how to count the table column of a MySQL Table Using Python. Python allows the integration of a wide range of database servers with applications. A database interface is required to access a database from Python. MySQL Connector-Python module is an API in python for communicating with a MySQL database.

We are going to use geeks(Database name) database and table describing the salary.

Approach:

Import module.
Make a connection request with the database.
Create an object for the database cursor.
Execute the following MySQL query:

SELECT count(*) AS New_column_name FROM information_schema.columns where table_name = 'Table_name';

Example 1:

In this example we are using this database with the following query;

Python3

# Establish connection to MySQL database
import mysql.connector

mydb = mysql.connector.connect(
    host="localhost",
    user="root",
    password="root123",
    database="geeks"
)

# Create a cursor object
mycursor = mydb.cursor()

# Execute the query
query = "SELECT count(*) AS New_column_name FROM information_schema.columns where table_name = 'Persons';"
mycursor.execute(query)

myresult = mycursor.fetchall()

print(myresult[-1][-1])

# Close database connection
mydb.close()

Output;

Example 2:

In this example we are using this database with the following query;

Python3

# Establish connection to MySQL database
import mysql.connector

mydb = mysql.connector.connect(
    host="localhost",
    user="root",
    password="root123",
    database="geeks"
)

# Create a cursor object
mycursor = mydb.cursor()

# Execute the query
query = "SELECT count(*) AS New_column_name FROM information_schema.columns where table_name = 'Salary';"
mycursor.execute(query)

myresult = mycursor.fetchall()

print(myresult[-1][-1])

# Close database connection
mydb.close()

Output:

How to find tables that contain a specific column in SQL using Python?

kumar_satyam

Improve

Article Tags :

Practice Tags :

python

Similar Reads

How to Alter a SQLite Table using Python ?

In this article, we will discuss how can we alter tables in the SQLite database from a Python program using the sqlite3 module.Â We can do this by using ALTER statement. It allows to: Add one or more column to the tableChange the name of the table.Adding a column to a table The syntax of ALTER TABLE

How to find tables that contain a specific column in SQL using Python?

MySQL server is an open-source relational database management system that is a major support for web-based applications. Databases and related tables are the main component of many websites and applications as the data is stored and exchanged over the web. In order to access MySQL databases from a w

Count set bits using Python List comprehension

set bits means finding how many 1s are in the binary form of a number. The set bit is any bit that is 1. List comprehension offers a quick and simple way to count these set bits. In this article, we will count set bits using Python list comprehension. Using bin()bin() function converts a number to b

How to GroupBy and Sum SQL Columns using SQLAlchemy?

In this article, we are going to see how to use GroupBy and Sum in SQLAlchemy. Installing SQLAlchemySQLAlchemy is available via pip install package. pip install sqlalchemyHowever, if you are using a flask you can make use of its own implementation of SQLAlchemy. It can be installed using - pip insta

Get column names from CSV using Python

CSV (Comma Separated Values) files store tabular data as plain text, with values separated by commas. They are widely used in data analysis, machine learning and statistical modeling. In Python, you can work with CSV files using built-in libraries like csv or higher-level libraries like pandas. In t

How to Find Duplicate Values in a SQL Table using Python?

MySQL server is an open-source relational database management system that is a major support for web-based applications. Databases and related tables are the main component of many websites and applications as the data is stored and exchanged over the web. In order to access MySQL databases from a w

Python SQLite - Create Table

In this article, we will discuss how can we create tables in the SQLite database from the Python program using the sqlite3 module.Â In SQLite database we use the following syntax to create a table: CREATE TABLE database_name.table_name( Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â column1 datatype PRIMARY

How To Select Only One Column Using SQLAlchemy?

In this article, we are going to see how to select only one column using SQLAlchemy in Python. SQLAlchemy is a large SQL toolkit with lots of different components. The two largest components are SQLAlchemy Core and SQLAlchemy ORM. The major difference between them is SQLAlchemy Core is a schema-cent

How to Show all Columns in the SQLite Database using Python ?

In this article, we will discuss how we can show all columns of a table in the SQLite database from Python using the sqlite3 module.Â Approach:Connect to a database using the connect() method.Create a cursor object and use that cursor object created to execute queries in order to create a table and

Python SQLAlchemy - func.count with filter

In this article, we are going to see how to perform filter operation with count function in SQLAlchemy against a PostgreSQL database in python Count with filter operations is performed in different methods using different functions. Such kinds of mathematical operations are database-dependent. In Po