Skip to content
Related Articles

Related Articles

How to Concatenate Column Values of a MySQL Table Using Python?
  • Last Updated : 26 Dec, 2020

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 Coloums 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(Coloumn Name 1, Coloumn 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(Coloumn Name 1, Coloumn Name 2) AS fulldetail FROM Table_Name”)

Code:

Python3

filter_none

edit
close

play_arrow

link
brightness_4
code

# 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)

chevron_right


Output:

('PathakAnuk',)
('kantKrish',)

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.

My Personal Notes arrow_drop_up
Recommended Articles
Page :