Thanks that worked.
I was trying -v from the help.
Gavin Towey
10/02/2009 05:30 PM
To
Lucas CTR Heuman/ACT/CNTR/f...@faa, "mysql@lists.mysql.com"
cc
Subject
RE: The Execute from the command line
Mysql -vv
See mysql --help for more info
Regards,
Gavin Towey
---
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'
(Id,LastName,MiddleName,FirstName,TimeStamp,Ext,Status,Location,Expi
/06/2008 09:14 AM
To
Lucas CTR Heuman/ACT/CNTR/[EMAIL PROTECTED]
cc
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 Message -
W
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 this
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
using 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
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 for
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
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"
cc
Subject
Re: IS NULL Question
> I'm having problems understan
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
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 | testd
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,
_
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
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
t
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
14 matches
Mail list logo
