How do you export tables from phpMyAdmin as plain text table format?

Question

I've been through most of the export formats and can't seem to find it.

I'd like to be able to export tables visually like in this answer:

id | name | name
----------------
1  | One  | Partridge
2  | Two  | Turtle Doves
3  | Three| French Hens
4  | Four | NULL

Answer 1

That's the format you can get by running the query in command line, for instance :

mysql> SELECT user_ID, user_fullname FROM user;
+---------+------------------+
| user_ID | user_fullname    |
+---------+------------------+
|       1 | Marc             |
|       2 | Nicole           |
|       4 | Alexandre        |
+---------+------------------+
4 rows in set (0.00 sec)

If you can access to your server that's a quick way to get this layout. Otherwise i dunno how to do it with phpMyAdmin