Đang Thực Hiện

165815 Simple data project

Maximum: $10

I need city lists of Portugal and Brazil.

The lists should be in SQL format.

The DB tables are attached.

Explanation:

1- You should enter a company with name Portugal in table countries

2- Enter all districts of portugal in the districts table with countryid from the countries table

3- Enter all cities of all districts of portugal in the cities table with districtid from the districts table

4- Do the same for Brazil

Note: Take care of special portuguese letters

CREATE TABLE `cities`

(

`id` int(20) NOT NULL auto_increment,

`name` varchar(200) NOT NULL,

`districtid` int(20) NOT NULL,

PRIMARY KEY (`id`),

KEY `districtid` (`districtid`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

CREATE TABLE `countries` (

`id` int(20) NOT NULL auto_increment,

`name` varchar(200) NOT NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `name` (`name`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

CREATE TABLE `districts` (

`id` int(20) NOT NULL auto_increment,

`name` varchar(200) NOT NULL,

`countryid` int(20) NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

Kỹ năng: Bất kì công việc gì, Nhập liệu, SQL

Xem thêm: primary data, data key entry, data entry portuguese, data entry 10-key, data entry 10 key, 10 key data entry, portuguese project, data entry SQL , engine data, simple city, enter company data, data key, sql simple project, Districts, simple special, brazil portuguese, data entry special project, primary key, countries need data entry, simple project sql, create primary key sql, simple format project, create data project, simple tables, simple data project

Về Bên Thuê:
( 45 nhận xét ) Madrid, Portugal

Mã Dự Án: #1912006