How to update data in MySQL from a file

Question

sql table update

Answer 1

Do you mean to import from a .sql file? define meaning of "file" here?

Answer 2

I used to export/import data to/from .sql file with phpMyAdmin, but I am not experienced with other types of file. Maybe there is such feature in other tools like MySQL workbench

https://www.mysql.com/products/workbench/

Answer 3

You're welcome Vinit : )
Glad if it helps...

Answer 4

thanks Ipang

Answer 5

any text file with same column as table