Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. bwelch42

    Running an SQL command on all tables of a database

    I agree, Feherke. I have a shell script that does this already, but unfortunately have only SQL access to the server in question. Oh, well. This will force me to develop my SQL skills.
  2. bwelch42

    Running an SQL command on all tables of a database

    Okay, I've got the list of tables that need updates. What looping structure works best? As I'm switching from Oracle and MS SQL Server, the looping part seems foreign.
  3. bwelch42

    Running an SQL command on all tables of a database

    Using MySQL 5.0 and only SQL, what's a way to run a SQL command on all tables of a database? The command would be something like: delete userID from tblUser where userID = 'abcd1234';

Part and Inventory Search

Back
Top