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
  AttributeError: '_tkinter.tkapp' object has no attribute 'username' Konstantin23 4 1,753 Aug-04-2023, 12:41 PM
Last Post: Konstantin23
  Pulling Specifics Words/Numbers from String bigpapa 2 770 May-01-2023, 07:22 PM
Last Post: bigpapa
  Having trouble installing scikit-learn via VSC and pulling my hair out pythonturtle 1 766 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,238 Dec-19-2022, 11:11 PM
Last Post: Stockers
  Hiding username and password on sql tantony 10 2,952 Oct-21-2022, 07:58 PM
Last Post: wavic
  pulling multiple lines from a txt IceJJFish69 3 2,593 Apr-26-2021, 05:56 PM
Last Post: snippsat
  code with no tuple gets : IndexError: tuple index out of range Aggam 4 2,847 Nov-04-2020, 11:26 AM
Last Post: Aggam
  Pulling Information Out of Dictionary Griever 4 2,903 Aug-12-2020, 02:34 PM
Last Post: Griever
  Trying to create a conditional with a username Realen 2 1,832 Jun-20-2020, 12:44 AM
Last Post: Realen
  Client OS username ImPyBoy17 5 2,708 Sep-24-2019, 10:18 AM
Last Post: buran

Forum Jump:

User Panel Messages

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