Two Question …..

[blackhawkchile]

hi,

first the program is very good ,im so happy 😀

BUT , ( jajaja )

i have two question for the forum people …..

how can i export the tables like excel book??, i can do it like a csv but not one field in one field in excel i only get the csv with all information in ONE row !!.. 🙁

second question… jeje..

how can i do search in the program ?… for example.. i want to look only the people with age “x” in the db…

that is all !!!

thankz mens…

bye

[peterlaursen]

1) Transfer MySQL data to Excel:

(sorry that I wrote Access in the first palce – that was wrong!)

there are a lot of different settings for the export. You should set the field delimiter to “;” (semicolon). This will be understood by excel

However I prefer not to use SQLyog here. Install MS-Query (an optional component of the MS Office Suite) and the ODBC-driver for MySQL. Then you can generate a query to MySQL from inside Excel using either the MS-Query-GUI or SQL (the sort of SQL that MS-office uses)

2) Filtering.

You must learnn a little bit of SQL! filtering is done with the WHERE-clause

This query:

SELECT column1,column2, etc. FROM people WHERE age = x; (or 'x' if variable-type is some string type)

will open a filtered list in RESULT -pane

A graphical tool for filtering and sorting (like in Access) is planned for a future version. I don't know exactly when:

[CalEvans]

blackhawkchile wrote on Aug 27 2005, 08:50 PM:

how can i export the tables like excel book??,  i can do it like a csv but not one field in one field in excel i only get the csv with all information in ONE row !!.. 🙁

You can either right click on the result set and select “Copy to clipboard”. This will bring up a dialog that allows you to export it to a CSV but jsut to the clipbard. Swap to Excell and paste and it should imort properly.

Or you can export it to a CSV. Excell's import feature will import it into a workssheet with each value in a seperate column. I'm using Excell from Office 2003 but I'm pretty sure most previosu versions do tis also.

blackhawkchile wrote on Aug 27 2005, 08:50 PM:

how can i do search in the program ?… for example.. i want to look only the people with  age “x” in the db…

The proper way to search any given table using SLYog is to write a SQL command that returns only the rows you are interested in. There is no functionality in the program to use something like the “Find” command to searc a result set and I hope there never is.

HTH,

=C=

[peterlaursen]

@CalEvans

u r 2 slow!

Problem is that if you use for instance komma as field delimiter Excel will create all data in one column. With Excel you should use semicolon!

and that was the question! 😀

[peterlaursen]

and @CalEvans

u must start a BLOG. If you don't, you will be mobbed when you are not here 😀

(sorry that wrote “mopped” in the first palce. But you will be that too 😀 )

[blackhawkchile]

thankz for the answers , but, where i have to put the sql sentence ???.. 😮

and i cant export to excel yet…

if u put export data table …. the program giveme to many options..like

FIELD

TErminated by

ENclosed by

Escaped by

LINES

terminated by

Etc….

what i have to put to see the ecxel like…. field A1 NAME…A2 LAST NAME…. i hope u understand the question… 😀

THANKZ……

sorry my english but iam chilean and my lenguage is spanish.. ;-D

[peterlaursen]

Like this:

start SQLyog

right-click a table in Object Browser

export .. export as CSV

now press “change” – button

enter the semicolon as field-delimiter.

See pic attatched. These settings work fine with Excel here

But still I prefer to use MS-Query when transferring data from MySQl to Excel.

BTW: it is no SQL-issue!

[Author]

Posts