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

    Join Date
    Mar 2000
    Posts
    60
    Rep Power
    15
    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.

    Ideas?

  2. #2
  3. No Profile Picture
    Robert_J_Sherman
    Guest
    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, 10:27 PM
  2. SELECT records between two months
    By C3P0 in forum MySQL Help
    Replies: 6
    Last Post: April 4th, 2003, 05: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, 01:32 AM
  4. delete and left join not working
    By ebizsols in forum MySQL Help
    Replies: 2
    Last Post: June 24th, 2002, 10:33 AM
  5. SELECT where data is comma delimited..
    By Robert_J_Sherman in forum MySQL Help
    Replies: 29
    Last Post: June 28th, 2001, 11:29 AM

IMN logo majestic logo threadwatch logo seochat tools logo