| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Lucas.CTR.Heuman | Date: | October 2 2009 9:19pm |
| Subject: | The Execute from the command line | ||
| View as plain text | |||
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,
| Thread | ||
|---|---|---|
| • Remote connection | Hugo Leonardo Ferrer Rebello | 4 Aug |
| • RE: Remote connection | Pablo A. Otero | 4 Aug |
| • Re: Remote connection | Carlos Proal | 4 Aug |
| • RE: Remote connection | Gavin Towey | 5 Aug |
| • RES: [SPAM] RE: Remote connection | Hugo Leonardo Ferrer Rebello | 5 Aug |
| • The Execute from the command line | Lucas.CTR.Heuman | 2 Oct |
| • RE: The Execute from the command line | Gavin Towey | 2 Oct |
| • RE: The Execute from the command line | Lucas.CTR.Heuman | 5 Oct |
