How To Export Csv File

[gaspower]

Hello,

Very new to SQLyog, and need some helping on exporting a csv file. I have information in multiple tables, for example customer name, and address under one table and their email address under another table. How do I either view or export so I can see the stored information. If i link in the Query field the corresponding fields I can not see the data? Any help would be great.

Thanks JR

Example structure:

Table (address_book)

customer_id

entry_firstname

entry_lastname

Table (customers)

customer_id

customer_email_address

[peterlaursen]

something like:

Code:

Select adress_book.entry_firstname, adress_book.entry_lastname, customers.customer_email_address from adress_book, customers where adress_book.customer_id = customers.customer.id;

We will soon provide a Graphical Query Builder that can build such queries.

[gaspower]

Thank you,

But when I enter the above into the query window and execute, I get the following error.

Error Code : 1046

No Database Selected

(109 ms taken)

But the correct databases are listed in the statement??

Thans JR

[peterlaursen]

Only the tables and columns (and not the database) are listed in the example statement that I wrote. Do one of:

1) include the database like database.table.column in every reference

2) or select the database in the Object Browser (the left pane of SQLyog) or in the dropdown on the icon bar

[gaspower]

Hello,

We'll I tried

Select customers_id, customers_firstname, customers_lastname, entry_email_address From customers, address_book Where customers_id = customers_id

And Get Error:

Error Code : 1052

Column: 'customers_id' in field list is ambiguous

(94 ms taken)

Example structure:

Table (address_book)

customer_id

entry_firstname

entry_lastname

Table (customers)

customer_id

customer_email_address

[peterlaursen]

Quote:

Error Code : 1052

Column: 'customers_id' in field list is ambiguous

Yes .. there is a `customers_id` in both tables!

Now read the error message: ” … is ambiguous”. It tells everything!

In this situation you must use `table`.`column` like

`address_book`.`customers_id`

or

`customers`.`customers_id`

.. for that column!

[Author]

Posts