Categories
Development MySQL Python SQL

insert data in RDS MySQL with python ( IndentationError: unindent does not match any outer indentation level)

I use RDS MySQL, and I want to insert data in a table with Python code, but I have the error File “DB2.py”, line 23 mySql_insert_query = “””INSERT INTO empolyee (ID, Name, date) VALUES (1, ‘reham’, ‘2019-08-14’)””” IndentationError: unindent does not match any outer indentation level the code import mysql.connector from mysql.connector import Error from […]

Categories
Development

Return mixed non-series items + next upcoming in series

I’m looking for the best way to handle the following query. I have a table of items, some (but not all) of which are part of a series of items (one per day). The ones in a series are grouped by a shared series ID: Table “items”: id series_id (may be NULL) title date etc. […]