I have a MySQL database which contains a table named "event-site". It has one column named "signature" and i want to select that particular column using MySQL lib in python. I tried "SELECT signature FROM event-site" and "SELECT signature FROM 'event-site'" (apostrophe around the table name as it contains special characters) but none seems to work. I always get the error that there is an error in the MySQL syntax and I should look near 'event-site'. Can somebody help me with the right syntax?
Asked
Active
Viewed 10 times
0
-
try to surrond "event-site" with ` characters – Christian Moen Jun 15 '20 at 19:47
-
Use back quotes. SELECT signature FROM `event-site` – codemonkey Jun 15 '20 at 19:48