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
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
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
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
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
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