Mysql query with column name in spaces

Question

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

select 'column name with spaces',[column name with spaces] from table_name — donstack
– donstack, Commented Feb 26, 2014 at 13:00
I'm not sure what the question is, but your insert query is not valid sql. — Dan Bracuk
– Dan Bracuk, Commented Feb 26, 2014 at 13:01

Digital Chris · Accepted Answer · 2014-02-26 13:10:14Z

2

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

edited Feb 26, 2014 at 13:10

answered Feb 26, 2014 at 13:03

Digital Chris

6,1771 gold badge22 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

ypercubeᵀᴹ Over a year ago

If you are posting code, edit it for syntax errors. INSERT ... VALUES ... WHERE is not valid SQL.

Collectives™ on Stack Overflow

Mysql query with column name in spaces

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related