Thanks that worked.
I was trying -v from the help.
Gavin Towey gto...@ffn.com
10/02/2009 05:30 PM
To
Lucas CTR Heuman/ACT/CNTR/f...@faa, mysql@lists.mysql.com
mysql@lists.mysql.com
cc
Subject
RE: The Execute from the command line
Mysql -vv
See mysql --help for more info
Regards
I am using
linuxmachine:/var/wwwdev/lucas# mysql -udatabase -ppassword -e LOAD DATA
LOCAL INFILE '/var/wwwdev/lucas/cardreaderimport/update.csv' into table
Project.testtest fields terminated by ',' lines terminated by '\n'
I have a table in my database with 4 fields, Because it is already
implemented in the application I am modifying I cannot change the table.
Here is what I have
DATA1STAMP type DATE , DATA1DATA type INTEGER, DATA2STAMP type DATE,
DATA2DATA type INTEGER in my DATATABLE.
I now need to select
/2008 09:14 AM
To
Lucas CTR Heuman/ACT/CNTR/[EMAIL PROTECTED]
cc
mysql@lists.mysql.com
Subject
Re: Formatting in same columns when selecting from two tables.
Good Morning Lucas-
could you define the formatting specifics of DATA and DATASTAMP
result-type?
Thank You
Martin
- Original
Isn't there a chance that you could get a ID that is the same as one
already in use? and if this happens what happens on the insert?
Wishing you the best you know you deserve,
__
Lucas Heuman
Web Developer
Ricomm Systems Inc.
FAA, WJHTC/Bldg 300, 3nd Fl., L33
Atlantic City
I have been looking online for an explanation of the differences between
ODBC drivers 3 and 5. I'm sure it is someplace simple to find. Does
anyone here know?
Phone 609.485.5401
the same version?
-Luke
Jim Winstead [EMAIL PROTECTED]
06/19/2007 12:09 PM
To
Lucas CTR Heuman/ACT/CNTR/[EMAIL PROTECTED]
cc
MySQL List mysql@lists.mysql.com
Subject
Re: ODBC Drivers 3 and 5
On Tue, Jun 19, 2007 at 10:24:11AM -0400, [EMAIL PROTECTED] wrote:
I have been looking online
By chance when you set them as null did you use null or 'null' setting
it as a string value?
__
Lucas Heuman
Phone 609.485.5401
Martijn Tonies [EMAIL PROTECTED]
05/01/2007 04:45 AM
To
MySQL mysql@lists.mysql.com
cc
Subject
Re: IS NULL Question
I'm having
Has anyone found a way to get a result set with the current row return
number in a select statement without using vars?
select concat('Test row ',currentreturnrownum()) as testdata , mytestdata
from mytestdatatable;
++---+
|Test row 1 |
I'm sorry, currentreturnrownum() doesn't exist .. I was looking for a
function like that so I can make a result set show what row it is in the
return set.
so I can get select currentrownumber , * from anytable;
then I get
1 (rest of date from the *)
2 (rest of date from the *)
3 (rest of date
Hello Group,
Looking to use this REPLACE to strip multi line data out of my return
data.
I am having problems getting the \n to work correctly, any ideas?
REPLACE(DESCRIPTION,\n,' ')
SELECT
rpad(CASE WHEN DESCRIPTION IS NULL THEN '' ELSE
REPLACE(DESCRIPTION,'\n',' ') END,80,' ') as var
Ok.. I found the problem.. I needed to add a \r.. but now that opens up
the question can I have a Multi replace search in replace?
Example can I do something like this in MySQL
REPLACE (STRING,'\r' or '\n',' ')
REPLACE(DESCRIPTION,'\r\n',' ')
Wishing you the best you know you deserve,
I am running a basic install of MySQL 5.0 with strict mode turned on I
would like to use RPAD however at times a NULL var will be sent to the
function. My goal is to have a function that will convert the NULL to a
blank string to get the result of EXAMPLE3 if a NULL is returned.
EXAMPLE 1
I don't see how to use this here, I will have to research the |/||/|
select rpad(|IFNULL(|null, ''),5,'1');
|/||/|
but this below works thank you
SELECT RPAD(CASE WHEN NULL IS NULL THEN '' ELSE '2' END, 5, '1');
If you are using it on an actual field, you would replace the first NULL
and
14 matches
Mail list logo