drop table if exists your_table; create your_table (...); > -----Original Message----- > From: Peter Abilla [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, December 04, 2002 1:12 PM > To: [EMAIL PROTECTED] > Subject: Drop, Create. . .help > > > I want to do the following: > > 1-If table x exists, then drop. > 2-then, create table x again. > > Explanation: > > Table x in (1) has different date parameters than table x in > (2). They are called the same name because there is a > function that uses that table. Basically, I want to do something like: > > DROP TABLE IF EXISTS ExistingDocID > CREATE TABLE ExistingDocID > SELECT distinct OrderingPhysicianID > FROM vu_StudyInformation > WHERE StartDate Between '1999-11-25' and '2002-05-01' > ORDER BY OrderingPhysicianID asc > > Any ideas? > > <sql, query> > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > >
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
