CODEWITHSUNDEEP
mysqlsql
preethi
preethi

Reputation: 905

Mysql query with column name in spaces

I have a table with columns machine id like (311a__) and (311bb__) and some of them like (08576). How can I retrieve them in SQL - how to insert into row where machine ID is like ( 311a__)? My question how to insert and select a column which has spaces in it.. How to retrieve data where machine_name ="%s__" is it correct

sql_local = """SELECT id FROM customer_1.pay_machines WHERE machine_name="%s" """ % machine

  retVal = cursor.execute(sql_local)
  if (retVal == 0):
    sql_local = """INSERT INTO customer_1.pay_machines (machine_name, carpark_id) VALUES ("%s", 0)""" % machine

Upvotes: 0

Views: 1340

Answers (1)

Digital Chris
Digital Chris

Reputation: 6202

Surround odd (or reserved word) column names with backticks:

SELECT * 
  FROM  pd 
 WHERE `machine id` = '(%s__)';

edit: removed invalid insert query as the first query is sufficient as an example

Upvotes: 2

Related Questions