Skip to content
Related Articles

Related Articles

How to Concatenate Column Values of a MySQL Table Using Python?

Improve Article
Save Article
  • Last Updated : 17 May, 2021
Improve Article
Save Article

Prerequisite: Python: MySQL Create Table

In this article, we show how to concatenate column values of a MySQL table using Python. We use various data types in SQL Server to define data in a particular column appropriately. We might have requirements to concatenate data from multiple columns into a string

Concatenating Columns means that one is merging column data and showing it into a single column. This can also be done in MySQL using the CONCAT() function, but we are using a Python Program to concatenate multiple columns. MySQL Connector-Python module is an API in python for communicating with a MySQL database.

We are going to use this database:

How to Concatenate Column Values of a MySQL Table:

Syntax: SELECT Concat(Column Name 1, Column Name 2) AS fulldetail FROM Table_Name

How to Concatenate Column Values of a MySQL Table Using Python:

This example shows the Concatenation of a column. Steps are as follows:

  • Use connect() function to establish a connection with the database server. Pass the host, user (root or your username), password (if present), and database parameters to connect() method.
  • Then to create a cursor object, use the cursor() function.
  • Execute the upper disused syntax for the Person table.

Syntax: 
cursor.execute(“SELECT Concat(Column Name 1, Column Name 2) AS fulldetail FROM Table_Name”)

Code:

Python3




# Establish connection to MySQL database
import mysql.connector
 
mydb = mysql.connector.connect(
  host="localhost",
  user="root",
  password="root123",
  database = "geeks"
  )
mycursor = mydb.cursor()
 
mycursor.execute("SELECT Concat(FirstName, LastName) AS fulldetail FROM Persons;")
 
myresult = mycursor.fetchall()
 
for x in myresult:
  print(x)

Output:

('PathakAnuk',)
('kantKrish',)
My Personal Notes arrow_drop_up
Related Articles

Start Your Coding Journey Now!