3 votes

SQL breaking my query where there is NULL value

Error was thrown because of trying to insert NULL values in the COUNTRY column, not COUNTRY_CODE. You did not specify any value for COUNTRY column, an INSERT like that would insert NULL values in ...
Balazs Papp's user avatar
  • 40.4k
1 vote

SQL breaking my query where there is NULL value

Since all three columns of country are defined as NOT NULL, you have to provide a value for all three columns when you insert a new row. To load that table using distinct values from airportdemodata, ...
Paul W's user avatar
  • 510

Only top scored, non community-wiki answers of a minimum length are eligible