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 598 Jan-31-2025, 12:26 PM
Last Post: hartman60
  checking username newbexx 3 1,233 Jun-17-2024, 11:42 AM
Last Post: Pedroski55
  AttributeError: '_tkinter.tkapp' object has no attribute 'username' Konstantin23 4 6,374 Aug-04-2023, 12:41 PM
Last Post: Konstantin23
  Pulling Specifics Words/Numbers from String bigpapa 2 1,706 May-01-2023, 07:22 PM
Last Post: bigpapa
  Having trouble installing scikit-learn via VSC and pulling my hair out pythonturtle 1 1,638 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 2,018 Dec-19-2022, 11:11 PM
Last Post: Stockers
  Hiding username and password on sql tantony 10 7,374 Oct-21-2022, 07:58 PM
Last Post: wavic
  pulling multiple lines from a txt IceJJFish69 3 3,545 Apr-26-2021, 05:56 PM
Last Post: snippsat
  code with no tuple gets : IndexError: tuple index out of range Aggam 4 4,615 Nov-04-2020, 11:26 AM
Last Post: Aggam
  Pulling Information Out of Dictionary Griever 4 4,112 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