pandas mysql error in query concat with space code example
Example: 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);