I want to export query result in to CSV file from PHPMyAdmin
How to do that?
See the below picture. Normally I can see the option to check all, edit and delete rows.
But when I run this query
SELECT n.id
, n.gazette_notice_id
, n.notice_code
, n.publication_date
, n.company_number
, c.company_name
, c.registered_address_line_1
, c.registered_address_line_2
, c.registered_address_town
, c.registered_address_county
, c.registered_address_country
, c.registered_address_postcode
, c.sic_1
, s.description sic_code_description
, s.division sic_code_division
, s.section sic_code_section
, ni.insolvency_practitioner_id
, i.name practionar_name
, i.company practitioner_company
, i.address practitionar_address
, i.phone
, i.email
FROM notices n
LEFT
JOIN companies c
ON c.company_number = n.company_number
LEFT
JOIN sic_codes s
ON s.code = c.sic_1
LEFT
JOIN notice_insolvency_practitioners ni
ON ni.notice_id = n.id
LEFT
JOIN insolvency_practitioners i
ON i.id = ni.insolvency_practitioner_id
WHERE n.publication_date > '2020-03-01'
AND n.publication_date < '2020-03-31'
AND n.notice_code = 2410
The option just disappears and I get this message warning
Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available.
And if you click on export without selecting the rows then it will export the table. But I don't want to export one single table. I have created query to select data from 5 tables.
Please guide me how to export query result into excel /csv file.