CODEWITHSUNDEEP
mysqlsql
Wordica
Wordica

Reputation: 2595

Sql export for select result

I try to export data from database but in phpmyadmin i have no option to dump it to sql format.

SELECT email 
FROM users, 
     profiles 
WHERE users.id = profiles.user_id 
  AND profiles.country_id = 1

I'm not good in sql - why i cant dump this to sql format form phpmyadmin

Upvotes: 0

Views: 80

Answers (1)

po_taka
po_taka

Reputation: 1856

There is export option below the results. enter image description here

EDIT:

You need to select single table e.g.

SELECT email
FROM   users
WHERE  userid IN (SELECT userid
                  FROM   users,
                         profiles
                  WHERE  users.id = profiles.user_id
                         AND profiles.country_id = 1)

Upvotes: 1

Related Questions