Lost Data #2

2002-01-29 Thread Scott Wang
s data??? This happened suddenly with two different tables, at the same time. They were the two largest tables in the database - other unaffected tables are smaller. Thank you, - Scott Wang [EMAIL PROTECTED] http://www.scottscomputing.com

Lost data

2002-01-28 Thread Scott Wang
has the 1gb files. Is there any way to restore this data??? This happened suddenly with two different tables, at the same time. They were the two largest tables in the database - other unaffected tables are smaller. - Scott Wang [EMAIL PROTECTED] h

Removing duplicates from a table

2001-03-08 Thread Scott Wang
Hi guys, I set up a table that I'll be using for a mailing list. Two fields: id and addr. The id is a unique primary key that is used to "identify" (?) the email address in the addr field. How can I remove duplicate addresses in the addr field? I know of the select distinct addr from tabl