i try to use mysql command to achieve show warnings after execution but my command seems didn't work,what's wrong with the below code,i have tested for many times

mysql -uroot -pbin \W --execute="LOAD DATA LOCAL INFILE '/home/mlzboy/code/mq/model_product.csv' INTO TABLE search.model_product FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\n' (name,price,productid,site,link,smallImage,bigImage,description,createdOn,modifiedOn,size,weight,wrap,material,packagingCount,stock,location,popularity,inStock,categories);"
link|improve this question
feedback

2 Answers

Try using

mysql -uroot -pbin --show-warnings --execute="..."

link|improve this answer
feedback

Perhaps this will help: How does one list warnings from the 'mysqlimport' utility?

link|improve this answer
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.