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,
