Results 1 to 3 of 3

Thread: Deletion

  1. #1
    Sean K. Guest

    Default Deletion

    I am working on a data dump script to dump data from many tables in many databases into many other tables in many other databases, and the only thing i have left to do is clear the tables to prep them to recieve the dumped data, do I have to just loop through them all or is there a nice quick "delete everything dag nab it" command that I can use?

  2. #2
    Join Date
    Dec 1969

    Default RE: Deletion

    Two ways to "delete everything dag nab it"<BR><BR>DELETE FROM tablename<BR><BR>or the preferred and MUCH MUCH faster way (esp if you have many records)<BR><BR>TRUNCATE TABLE tablename

  3. #3
    Sean K. Guest

    Default Thank you <n/t>


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts