airlinename field with type varchar(30) contains airlines name which are cut off to 20 characters limit instead of 30

[fortunewalla]

Source:

flughafendb/tree/master/mysql-shell-dumps/flughafendb_small/

Expected Behaviour:

Full Name of the airline or cut off at 30 characters as field type is varchar(30)

Observed Behaviour:

It seems like the airlinename field with type varchar(30) contains airlines names which was already cut off to maximum 20 characters. This means that the names data used was already limited to 20 characters and then inserted into the varchar(30) type airlinename field.

Logs:

mysql>select iata, airlinename from airline limit 3;
+------+----------------------+
| iata | airlinename          |
+------+----------------------+
| AF   | Afghanistan Airlines |
| AL   | Albania Airlines     |
| AM   | American Samoa Airli |
+------+----------------------+    

-- airline table description.

mysql> describe airline;
+--------------+-------------+------+-----+---------+----------------+
| Field        | Type        | Null | Key | Default | Extra          |
+--------------+-------------+------+-----+---------+----------------+
| airline_id   | smallint    | NO   | PRI | NULL    | auto_increment |
| iata         | char(2)     | NO   | UNI | NULL    |                |
| airlinename  | varchar(30) | YES  |     | NULL    |                |
| base_airport | smallint    | NO   | MUL | NULL    |                |
+--------------+-------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)

-- airline names and their lengths

airlinename	length
Afghanistan Airlines	20
Albania Airlines	16
American Samoa Airli	20
Angola Airlines	15
Argentina Airlines	18
Australia Airlines	18
Azerbaijan Airlines	19
Bahamas Airlines	16
Belarus Airlines	16
Bhutan Airlines	15
Bolivia Airlines	16
Brazil Airlines	15
Bulgaria Airlines	17
Caicos Is Airlines	18
Central African Rep	20
Chad Airlines	13
Colombia Airlines	17
Croatia Airlines	16
Cuba Airlines	13
Cyprus Airlines	15
Czech Airlines	14
Dakhla And Laayoune	20
Denmark Airlines	16
Djibouti Airlines	17
Dominica Airlines	17
Ecuador Airlines	16
Egypt Airlines	14
El Salvador Airlines	20
Equatorial Guinea Ai	20
Eritrea Airlines	16
Estonia Airlines	16
Ethiopia Airlines	17
Falkland Is Airlines	20
Fiji Is Airlines	16
France Airlines	15
Gabon Airlines	14
Georgia Airlines	16
Ghana Airlines	14
Gibraltar Airlines	18
Greece Airlines	15
Guadeloupe Airlines	19
Haiti Airlines	14
Honduras Airlines	17
Hungary Airlines	16
Iceland Airlines	16
India Airlines	14
Iran Airlines	13
Isla De Pascua Airli	20
Italy Airlines	14
Ivory Coast Airlines	20
Jamaica Airlines	16
Jerusalem Airlines	18
Johnston Atoll Airli	20
Kazakhstan Airlines	19
Kenya Airlines	14
Kiribati Airlines	17
Korea Airlines	14
Kuwait Airlines	15
Kyrgyzstan Airlines	19
Laos Airlines	13
Lebanon Airlines	16
Liberia Airlines	16
Luxembourg Airlines	19
Macau Airlines	14
Melilla Airlines	16
Micronesia Airlines	19
Moldova Airlines	16
Myanmar Airlines	16
Namibia Airlines	16
Nepal Airlines	14
Nicaragua Airlines	18
Northern Mariana Is	20
Oman Airlines	13
Pakistan Airlines	17
Peru Airlines	13
Philippines Airlines	20
Poland Airlines	15
Puerto Rico Airlines	20
Qatar Airlines	14
Reunion Airlines	16
Romania Airlines	16
Russia Airlines	15
Rwanda Airlines	15
San Andres Airlines	19
Senegal Airlines	16
Sierra Leone Airline	20
Slovakia Airlines	17
Solomon Is Airlines	19
Spain Airlines	14
Sri Lanka Airlines	18
St Kitts Airlines	17
Sudan Airlines	14
Swaziland Airlines	18
Syria Airlines	14
Taiwan Airlines	15
Thailand Airlines	17
Togo Airlines	13
Trinidad Airlines	17
Tunisia Airlines	16
Uganda Airlines	15
Ukraine Airlines	16
United Arab Emirates	20
Uruguay Airlines	16
Uzbekistan Airlines	19
Vanuatu Airlines	16
Venezuela Airlines	18
Vietnam Airlines	16
Wake I Airlines	15
Western Samoa Airlin	20
Yemen Airlines	14
Yugoslavia Airlines	19
Zambia Airlines	15
Zimbabwe Airlines	17

[fortunewalla]

One possible way is to manipulate the source data and complete the airlines names manually and then update the sql file and then update the database.

[fortunewalla]

Used sql to get incomplete airline names and then excel concat to fix the list properly. It was maximum 29 characters.

Then reinserted it into the database.

Now airline names seem complete.