Drop, Create. . .help

2002-12-04 Thread Peter Abilla
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

Re: WHERE IN SYNTAX

2002-12-03 Thread Peter Abilla
the set itself WHERE fooId IN (fooId) Adolfo -Original Message- From: Peter Abilla [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 1:43 PM To: [EMAIL PROTECTED] Subject: sql:WHERE IN SYNTAX Question about SQL WHERE IN syntax: I know that something like

DateTime Calculations

2002-12-03 Thread Peter Abilla
Suppose I have a datetime in the following format: Column One Column Two 1999-09-17 16:30:18 1999-09-18 13:30:18 I want to calculate the minutes like (Column Two - Column One) = Total Minutes I've scoured the mysql site and haven't found something that addresses this. Any

sql:WHERE IN SYNTAX

2002-12-02 Thread Peter Abilla
Question about SQL WHERE IN syntax: I know that something like this is fine to do: (1) SELECT foo FROM bar WHERE fooID in ('1','2') In the example above, the parenthesis includes the itemized fooID's. But, I want to do a similar thing where instead of the actual fooID's in the WHERE IN

access2mysql:MacOSX

2002-11-26 Thread Peter Abilla
I have a similar question, but for access2mysql under MacOSX--any tools out there that facilitate the import process easier--that is, easier than access export to csv/txt, then import from csv/txt into mysql? PSA - Before

Re: Mac OS X installation problem...

2002-11-26 Thread Peter Abilla
Try mark linayage's package at: http://www.entropy.ch/software/macosx/welcome.html It is very easy to install and it works great. PSA On 11/26/02 11:28 AM, Michael Burbidge [EMAIL PROTECTED] wrote: I installed the MySQL (mysql-3.23.51) package from VersionTracker.com on my Titanium