Unanswered: Exporting data from mysql to Existing txt file.
Hi, Can someone please guide me about database export..
i wanted to export MySQL db Table fields to txt file such a format, that should get assign into a different existing columns of an existing txt file and it should separated by "comma and space"
col1 = field1, field2, ......
col2 = field3, field4, ......
I dont want to update fields rather than need to export(asign) database values into one list name "values" which is already present in My Text file .
Eg: Let "values" is one column in my sql table "values_tb" and val1, val2, val3 are the values of column, these values i need to assign into one list name called as "values" which is present in My Text file.
If the file already exists and you want to update entries in this file with values from queries then this is not possible from MySQL directly. However, this can be done by developing the update in the file of the values through some programming language (PHP, Java, C++).