1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2000
    Rep Power
    Howdy all,

    I am having a difficult problem working with the parameters I have been given.

    I have two tables, table1 and table2.
    Table1 is a load data infile from external text file

    Table2 is updated (only changed information) by Table1.

    NOW, I need to delete a row from table2 where a specific field is empty in table1, before updating table2 with table1.

    I know joins, i know delete, but I can't figure out how to get the two to play together.


  2. #2
  3. No Profile Picture
    Devshed Newbie (0 - 499 posts)
    I may be wrong, but I would imagine that this would work much in the way you insert data data.

    When we insert data from a form, we're inserting to muliple tables, mostly, and linking that data via a primary table.

    I would guess my first attempt would be to perfom the delete from the minor table first, then the major table.

    SnR Graphics,
    Low Cost Hosting and Web Development.

Similar Threads

  1. Replies: 2
    Last Post: September 22nd, 2003, 09:27 PM
  2. SELECT records between two months
    By C3P0 in forum MySQL Help
    Replies: 6
    Last Post: April 4th, 2003, 04:56 PM
  3. Can I join table and delete only 1 table
    By itsource in forum MySQL Help
    Replies: 3
    Last Post: January 4th, 2003, 12:32 AM
  4. delete and left join not working
    By ebizsols in forum MySQL Help
    Replies: 2
    Last Post: June 24th, 2002, 09:33 AM
  5. SELECT where data is comma delimited..
    By Robert_J_Sherman in forum MySQL Help
    Replies: 29
    Last Post: June 28th, 2001, 10:29 AM

IMN logo majestic logo threadwatch logo seochat tools logo