Skip to content
Related Articles

Related Articles

Improve Article
Save Article
Like Article

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

  • Last Updated : 17 May, 2021

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

 Attention geek! Strengthen your foundations with the Python Programming Foundation Course and learn the basics.  

To begin with, your interview preparations Enhance your Data Structures concepts with the Python DS Course. And to begin with your Machine Learning Journey, join the Machine Learning - Basic Level Course

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
Recommended Articles
Page :

Start Your Coding Journey Now!