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 posti
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 P
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 cl
"a set which contains as an element
> 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]
>> S
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 ideas
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
