Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Pulling username from Tuple
#21
You don't need to check if a name is in a table to remove the name from the table. A DELETE query looks a lot like a SELECT query, and you would specify which rows to delete just like you can specify which rows to select.
Reply
#22
(Oct-07-2022, 02:14 AM)deanhystad Wrote: You don't need to check if a name is in a table to remove the name from the table. A DELETE query looks a lot like a SELECT query, and you would specify which rows to delete just like you can specify which rows to select.

Its a user account that I would want to delete from the list of user accounts that are on the MySQL server.

I have now set my code up to use a SQL command to remove the user and I've tested and it works as expected
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Pulling data from mssql to PG DB hartman60 1 469 Jan-31-2025, 12:26 PM
Last Post: hartman60
  checking username newbexx 3 1,074 Jun-17-2024, 11:42 AM
Last Post: Pedroski55
  AttributeError: '_tkinter.tkapp' object has no attribute 'username' Konstantin23 4 5,594 Aug-04-2023, 12:41 PM
Last Post: Konstantin23
  Pulling Specifics Words/Numbers from String bigpapa 2 1,535 May-01-2023, 07:22 PM
Last Post: bigpapa
  Having trouble installing scikit-learn via VSC and pulling my hair out pythonturtle 1 1,484 Feb-07-2023, 02:23 AM
Last Post: Larz60+
  (Python) Pulling data from UA Google Analytics with more than 100k rows into csv. Stockers 0 1,933 Dec-19-2022, 11:11 PM
Last Post: Stockers
  Hiding username and password on sql tantony 10 6,747 Oct-21-2022, 07:58 PM
Last Post: wavic
  pulling multiple lines from a txt IceJJFish69 3 3,374 Apr-26-2021, 05:56 PM
Last Post: snippsat
  code with no tuple gets : IndexError: tuple index out of range Aggam 4 4,210 Nov-04-2020, 11:26 AM
Last Post: Aggam
  Pulling Information Out of Dictionary Griever 4 3,922 Aug-12-2020, 02:34 PM
Last Post: Griever

Forum Jump:

User Panel Messages

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