Export Textdata like MySQL Command line

thomas_w · Post by **thomas_w** » Wed 06 Apr 2011 17:35

Hi,

ist there any way to export data in the same format then MySQL Command Line do?

Example "devart":

======================================================================================================
|                        id                        |                       path                       
======================================================================================================
|                        1                         |                        1,                        
------------------------------------------------------------------------------------------------------
|                        2                         |                        1,                        
------------------------------------------------------------------------------------------------------
|                        3                         |                       1,3,                       
------------------------------------------------------------------------------------------------------
|                        4                         |                       2,4,                       
------------------------------------------------------------------------------------------------------

example "MySQL Command Line":

Code: Select all

mysql> select * from test;
+----+------+-------+--------+-------+
| id | path | value | parent | idtyp |
+----+------+-------+--------+-------+
|  1 | 1,   | HuHu1 |      0 |     1 |
|  2 | 1,   | HuHu2 |      0 |     1 |
|  3 | 1,3, | HuHu3 |      1 |     2 |
|  4 | 2,4, | HuHu4 |      2 |     2 |
+----+------+-------+--------+-------+
4 rows in set (0.00 sec)

mysql>

The MySQL Command Line Output is more handsome I thing.

with kind regards,
Thomas

Alexz · Post by **Alexz** » Thu 07 Apr 2011 07:14

If you mean the decoration of TEXT export, dbForge Studio for MySQL has such settings. Using them, you can set '-' and '+' characters instead of the default characters '=' and '|'.

If you are talking about the wide grid, we have this suggestion in our development plan. It will implement in one of the next versions of the product.

By the way, you can add your suggestion as well as vote for existing ones here:
http://devart.uservoice.com/forums/7729 ... -for-mysql

thomas_w · Post by **thomas_w** » Thu 07 Apr 2011 19:19

Okay, I check this out, but I get that:

Code: Select all

+++++++++++++++++++++++++++++++
| id  |path |value|paren|idtyp|
|     |     |     |  t  |     |
+++++++++++++++++++++++++++++++
|  1  | 1,  |HuHu1|  0  |  1  |
-------------------------------
|  2  | 1,  |HuHu2|  0  |  1  |
-------------------------------
|  3  |1,3, |HuHu3|  1  |  2  |
-------------------------------
|  4  |2,4, |HuHu4|  2  |  2  |
-------------------------------

The column width must calc flexible to the result set. I cannot setting it before the result is fetched. Sometime a column width is small, sometime wide. You know mysql command line ...

Thanks!

with kind regads,
Thomas

Alexz · Post by **Alexz** » Fri 08 Apr 2011 10:03

Unfortunately, dbForge cannot format the grid as MySQL command line does. We've added this suggestion to consider it for implementation in one of the next versions of the product.

As for column width, I wrote in the previous post that we already have such suggestion in our development plan.