s using(student_id) where
keepers.student_id is null;
drop table pickThroughThenDelete;
-Original Message-
From: Baron Schwartz [mailto:[EMAIL PROTECTED]
Sent: Friday, June 01, 2007 10:35 AM
To: Kebbel, John
Cc: mysql@lists.mysql.com
Subject: Re: Find and Add Unmatched Records
Hi
ble pickThroughThenDelete;
-Original Message-
From: Baron Schwartz [mailto:[EMAIL PROTECTED]
Sent: Friday, June 01, 2007 10:35 AM
To: Kebbel, John
Cc: mysql@lists.mysql.com
Subject: Re: Find and Add Unmatched Records
Hi John,
Kebbel, John wrote:
> I have a table of middle school students I
Hi John,
Kebbel, John wrote:
I have a table of middle school students I want to update quarterly. I
am only interested in finding and adding new students (not in finding
and deleting students who have been dropped from the school district).
I'm pretty sure I could put together a PHP script that
The "REPLACE" staement might work for you...
http://dev.mysql.com/doc/refman/4.1/en/replace.html...
-Original Message-
From: Kebbel, John [mailto:[EMAIL PROTECTED]
Sent: 01 June 2007 15:31
To: mysql@lists.mysql.com
Subject: Find and Add Unmatched Records
I have a table
I have a table of middle school students I want to update quarterly. I
am only interested in finding and adding new students (not in finding
and deleting students who have been dropped from the school district).
I'm pretty sure I could put together a PHP script that would do this,
but is there a My