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
import mysql.connector
mydb = mysql.connector.connect(
host = "localhost" ,
user = "root" ,
password = "root123" ,
database = "geeks"
)
mycursor = mydb.cursor()
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 ])
mydb.close()
|
Output;
5
Example 2:
In this example we are using this database with the following query;
Python3
import mysql.connector
mydb = mysql.connector.connect(
host = "localhost" ,
user = "root" ,
password = "root123" ,
database = "geeks"
)
mycursor = mydb.cursor()
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 ])
mydb.close()
|
Output:
2
Share your thoughts in the comments
Please Login to comment...