Separating Columns with Colon

[me7]

So I need to get columns from a mysql db into a txt docment and separate two columns with a ":".

 

I found that the -B command will separate them with a tab.

 

mysq -uuser -ppassword -Bse"use db;show column_name, column_name2 from table" > file_name.dmp

 

Also, what does the se in -B mean? It didn't work without it, but I couldn't find anything in the mysql documentation.

 

So my questions is, how can output the above like this - column_name:column_name2

 

Thanks!

[nankoweap]

there's probably an easier way to do this, but you use the concat function in your sql statement to get this done.

[The Little Guy]

Try something like this:

$sql = mysql_query("select * from table");

$str = '';
while($row = mysql_fetch_assoc($sql)){
    $str .= implode(":", $row)."\n";
}

$handle = fopen('myfile.txt', 'w');
fwrite($handle, $str);
fclose($handle);