From: Gavin Towey (gtoweyffn.com)
Date: Fri Oct 02 2009 - 16:30:17 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Mysql -vv

See mysql --help for more info

Regards,
Gavin Towey

-----Original Message-----
From: Lucas.CTR.Heumanfaa.gov [mailto:Lucas.CTR.Heumanfaa.gov]
Sent: Friday, October 02, 2009 2:20 PM
To: mysqllists.mysql.com
Subject: The Execute from the command line

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,Expire,BadgeNum);"

and it works great, I just get no verification that anything has been
loaded in.. if I login it gives me back a little message saying it was
completed and how many are duplicated. How can I get this information from
the command line?

Wishing you the best you know you deserve,

The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]