Try '-mm-dd'.
-Original Message-
From: Lakshmi Chennareddi [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 16, 2003 10:18 AM
To: [EMAIL PROTECTED]
Subject: Reading Date from a csv file
I am new to mySQL.
I am trying to import data from a csv file, using the following code
LOAD D
the server you're using. I'm
not sure when all the various joins took effect. There may be some such
info in the mysql docs.
-Original Message-
From: Jordan Morgan [mailto:[EMAIL PROTECTED]
Sent: Sunday, September 14, 2003 2:45 PM
To: David Sears
Cc: [EMAIL PROTECTED]
Subject: Re:
That's parentheses () around the inner join, not braces {}.
-Original Message-
From: Jordan Morgan [mailto:[EMAIL PROTECTED]
Sent: Sunday, September 14, 2003 12:56 PM
To: David Sears
Cc: [EMAIL PROTECTED]
Subject: Re: Newbies asking help with LEFT JOIN
Thanks for the prompt res
I didn't have the fortitude to populate the tables with data, so I don't
know if this will work for you, but to use explicit joins try something like
the sample below. (Note that I don't like to type as much as you do:-)
select distinct IE.title, FP.LastName, FP.FirstName
from InstitutionEmploymen
