/Python/Pandas mysql error in query concat with space

Pandas mysql error in query concat with space

#Ensure that the space is in single quotes to stop the query string being broken:
clients=pd.read_sql_query("SELECT concat(cl.`Title`, ' ', cl.`FirstNames`, ' ', cl.`Surname`) as ClientName
                          FROM tblClients cl;",conn);

Source: tutorialspoint.com

Similar codes

7 votes408 views3 answers
Spacy en_core_web_sm error
Python
9 votes272 views2 answers
Read live video from usb opencv python
Python
3 votes274 views2 answers
How to change role permissions in discord.py
Python
9 votes395 views2 answers
Flask template
Python Flask
0 vote296 views1 answer
How to use put method in django
Python
0 vote324 views1 answer
List of prime numbers in python with list comprehension
Python
19 votes306 views3 answers
Pil image to numpy array
Python
1 vote296 views1 answer
What is kali
Python
11 votes284 views3 answers
Logistic regression algorithm in python
Python
4 votes276 views3 answers
Pandas how to find column contains a certain value
Python