Python Forum
Getting error when running "MINUS" between 2 databases
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Getting error when running "MINUS" between 2 databases
#2
(Nov-09-2022, 05:00 AM)marlonbown Wrote:
connection_obj = sqlite3.connect(database)
cursor_obj = connection_obj.cursor()
statement = '''SELECT * FROM APIX MINUS SELECT * FROM APIW'''
res = connection_obj.execute(statement)
You must use the connection_obj to execute the query. Use the cursor_obj instead.
Reply


Messages In This Thread
RE: Getting error when running "MINUS" between 2 databases - by ibreeden - Nov-09-2022, 07:50 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  error "cannot identify image file" part way through running hatflyer 0 800 Nov-02-2023, 11:45 PM
Last Post: hatflyer
  Error when running kivy on python janeik 8 2,275 Jun-16-2023, 10:58 PM
Last Post: janeik
  [Solved]Help comparing 2 databases Extra 2 1,178 Jul-15-2022, 11:12 PM
Last Post: Extra
  Error while running code on VSC maiya 4 3,995 Jul-01-2022, 02:51 PM
Last Post: maiya
  Pandas - error when running Pycharm, but works on cmd line zxcv101 1 1,424 Jun-18-2022, 01:09 PM
Last Post: snippsat
  Error when running a matplot lib example aurelius_nero 3 7,225 Apr-24-2022, 01:24 PM
Last Post: Axel_Erfurt
  Keep getting Session management error when running imshow in pycharm pace 0 2,183 Mar-25-2021, 10:06 AM
Last Post: pace
  Error when running script on startup in Linux NoahTheNerd 0 2,030 Mar-07-2021, 04:54 PM
Last Post: NoahTheNerd
  Error when running mktorrent subprocess command pythonnewbie138 4 4,000 Sep-16-2020, 01:55 AM
Last Post: pythonnewbie138
  error while running in debug mode ModuleNotFoundError avipy123 0 2,694 Jul-14-2020, 02:05 PM
Last Post: avipy123

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020