syntax error at 'SELECT LAST_INSERT_ID()'
syntax error at 'SELECT LAST_INSERT_ID()' If I run my query in python, it returns a syntax error. However, if I run this with navicat, it work's fine. Why doesn't it run in python? sql_query INSERT INTO solarsystem ( solarsystemName, solarsystemPositionX, solarsystemPositionY, solarsystemSectorId, solarsystemAngle ) VALUES ('Lima [698/562]',698,562,13,171); SELECT LAST_INSERT_ID(); error 1064, u"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT LAST_INSERT_ID()' [EDIT] create.py [...] args = (solarsytem['solarsystemName'], solarsytem['x_pos'], solarsytem['y_pos'], solarsytem['sector_id'], solarsytem['angle']) with self.engine.begin() as connection: result_proxy = connection.execute(sql_query, args).first() [...] UPDATE If I try the INSERT as single que...