SELECT `countries`.`id`,
`countries`.`name`,
`countries`.`phone_code`,
`countries`.`code`,
`countries`.`continent`
FROM `perdepasaji`.`countries`;
SELECT `districts`.`id`,
`districts`.`province_id`,
`districts`.`name`,
`districts`.`district_code`
FROM `perdepasaji`.`districts`;
SELECT `provinces`.`id`,
`provinces`.`country_id`,
`provinces`.`name`,
`provinces`.`phone_code`,
`provinces`.`province_code`
FROM `perdepasaji`.`provinces`;
SELECT `tax_offices`.`id`,
`tax_offices`.`province_id`,
`tax_offices`.`name`,
`tax_offices`.`office_code`
FROM `perdepasaji`.`tax_offices`;
bunlar kolonlar içeriklerini .sql formatında isteniyor
tax_offices
id=unique int
province_id=int
name=VARCHAR(255)
office_code=VARCHAR(255)
districts
id=unique int
province_id=int
name=VARCHAR(255)
district_code=VARCHAR(3)
proviences
id=unique int
country_id=int
name=VARCHAR(255)
phone_code=int
provience_code=VARCHAR(3)
countries
id=unique int
phone_code=int
name=VARCHAR(255)
code=VARCHAR(5)
continent=VARCHAR(25)