MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table `cities` (
    `city_id` int (11),
    `city` varchar (270),
    `state_id` int (11),
    `is_active` tinyint (1),
    `created_at` datetime ,
    `updated_at` datetime 
); 
insert into `cities` (`city_id`, `city`, `state_id`, `is_active`, `created_at`, `updated_at`) values
('1','Port Blair*','1','1','2021-03-31 07:25:28','2021-03-31 07:25:28'),
('2','Adoni','2','1','2021-03-31 07:25:28','2021-03-31 07:25:28'),
('3','Amalapuram','2','1','2021-03-31 07:25:28','2021-03-31 07:25:28'),
('4','Anakapalle','2','1','2021-03-31 07:25:28','2021-03-31 07:25:28'),
('5','Anantapur','2','1','2021-03-31 07:25:28','2021-03-31 07:25:28'),
('6','Bapatla','2','1','2021-03-31 07:25:28','2021-03-31 07:25:28'),
('7','Bheemunipatnam','2','1','2021-03-31 07:25:28','2021-03-31 07:25:28');
SELECT * FROM cities;
create table `states` (
    `state_id` int (11),
    `state` varchar (180),
    `is_active` tinyint (1),
    `created_at` datetime ,
    `updated_at` datetime 
); 
insert into `states` (`state_id`, `state`, `is_active`, `created_at`, `updated_at`) values
('1','Andaman and Nicobar Islands','1','2021-03-31 06:30:04','2021-03-31 06:30:04'),
('2','Andhra Pradesh','1','2021-03-31 06:30:04','2021-03-31 06:30:04'),
('3','Arunachal Pradesh','1','2021-03-31 06:30:04','2021-03-31 06:30:04'),
('4','Assam','1','2021-03-31 06:30:04','2021-03-31 06:30:04'),
('5','Bihar','1','2021-03-31 06:30:04','2021-03-31 06:30:04'),
('6','Chandigarh','1','2021-03-31 06:30:04','2021-03-31 06:30:04'),
('7','Chhattisgarh','1','2021-03-31 06:30:04','2021-03-31 06:30:04'),
('8','Dadra and Nagar Haveli','1','2021-03-31 06:30:04','2021-03-31 06:30:04'),
('9','Delhi','1','2021-03-31 06:30:04','2021-03-31 06:30:04'),
('10','Goa','1','2021-03-31 06:30:04','2021-03-31 06:30:04'),
('11','Gujarat','1','2021-03-31 06:30:04','2021-03-31 06:30:04'),
('12','Haryana','1','2021-03-31 06:30:04','2021-03-31 06:30:04'),
('13','Himachal Pradesh','1','2021-03-31 06:30:04','2021-03-31 06:30:04');
SELECT * FROM states;

city_id	city	state_id	is_active	created_at	updated_at
1	Port Blair*	1	1	2021-03-31 07:25:28	2021-03-31 07:25:28
2	Adoni	2	1	2021-03-31 07:25:28	2021-03-31 07:25:28
3	Amalapuram	2	1	2021-03-31 07:25:28	2021-03-31 07:25:28
4	Anakapalle	2	1	2021-03-31 07:25:28	2021-03-31 07:25:28
5	Anantapur	2	1	2021-03-31 07:25:28	2021-03-31 07:25:28
6	Bapatla	2	1	2021-03-31 07:25:28	2021-03-31 07:25:28
7	Bheemunipatnam	2	1	2021-03-31 07:25:28	2021-03-31 07:25:28

state_id	state	is_active	created_at	updated_at
1	Andaman and Nicobar Islands	1	2021-03-31 06:30:04	2021-03-31 06:30:04
2	Andhra Pradesh	1	2021-03-31 06:30:04	2021-03-31 06:30:04
3	Arunachal Pradesh	1	2021-03-31 06:30:04	2021-03-31 06:30:04
4	Assam	1	2021-03-31 06:30:04	2021-03-31 06:30:04
5	Bihar	1	2021-03-31 06:30:04	2021-03-31 06:30:04
6	Chandigarh	1	2021-03-31 06:30:04	2021-03-31 06:30:04
7	Chhattisgarh	1	2021-03-31 06:30:04	2021-03-31 06:30:04
8	Dadra and Nagar Haveli	1	2021-03-31 06:30:04	2021-03-31 06:30:04
9	Delhi	1	2021-03-31 06:30:04	2021-03-31 06:30:04
10	Goa	1	2021-03-31 06:30:04	2021-03-31 06:30:04
11	Gujarat	1	2021-03-31 06:30:04	2021-03-31 06:30:04
12	Haryana	1	2021-03-31 06:30:04	2021-03-31 06:30:04
13	Himachal Pradesh	1	2021-03-31 06:30:04	2021-03-31 06:30:04