yone point me to the right direction on how I can successfully load the date
with the "12/06/2003" format without
getting -00-00 00:00:00 everytime.
Thanks for your help and time.
Lenny Sorey
LOAD DATA INFILE "d:/mydir/myfile.Tmp" INTO TABLE dealervehicle
FIELDS TERM
n)
Order by content.content_order
My platform is as follows:
W2k professional, tomcat 4.1.12, J2SDK 1.4.1, MySQL 4.0.2, mysql-connector-java-3.0.0
Once again,
My platform is as follows:
W2k professional, tomcat 4.1.12, J2SDK 1.4.1, MySQL 4.0.2, mysql-connector-java-3.0.0
Once again, Thanks for any help.
Happy Holidays,
Lenny Sorey
-
Before po
After thinking about some, I think I can ask my question in a clean manner.
How do I convert a Varchar data field into a list? Can someone tell me what I'm doing
wrong?
I have a query see below where the value (a varchar) of category.category_common is ->
2,3
I add the ( ) in the query below to
on column
that contain the number 2.
Content.content_common is not returning any of the four content.content_common data
field that contain a 3.
I know that I cannot use a sub-select with this version of MySql.
Anyone have any ideas what I'm doing wrong?
Thanks In Advance.
Lenny Sorey
on column
that contain the number 2.
Content.content_common is not returning any of the four content.content_common data
field that contain a 3.
I know that I cannot use a sub-select with this version of MySql.
Anyone have any ideas what I'm doing wrong?
Thanks In Advance.
Lenny Sorey
No problem Paul, I understood what you meant.
Lenny Sorey
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Lenny Sorey" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, April 05, 2002 11:17 AM
Subject: Re: Command Line Tool
I'm having a bit of a problem trying to get MySQL version 4.0.1-alpha-max-nt
binary version
to accept The Command - Line Tool to run a script to create a table.
My operating system is Windows 2000 Professional. I can connect with
MyODBC-3.51.02.exe without any problem and run successful queries.