Atomicorp

I have a workable solution: I altered my tables to that int columns have a default value of 0 and varchar columns have no default value. All columns are set to null=none. I added a record in months so that m_no = N/A and m_name = N/A. In persons I updated every record where the month fields had no v...

The concat statement works so that is not the problem. The problem is that the query does not test for a null value in the fathers_rn and mothers_rn. I have tried several methods for testing for a null value in both fathers_rn and mothers_rn so that I get a result set if one or the other is populate...

To be more clear, it is the inner join process concat(mo_name,' ', birth_day,', ', birth_year) from persons inner join months on persons.birth_month=months.mo_n that fails to find a value in table months if the birth_month = 0 or NULL. Here is the entire table months: MariaDB [ae]> select * from mon...

After considerable testing of all portions of my query and an examination of the data in table persons, I have come to the conclusion that the offending expression is concat (mo_name,' ', birth_day,', ', birth_year) A null set is returned when any of the elements in this expression are null. Therefo...

I am using MariaDB on debian/gnu/linux/stable. I have a database with three tables. Persons: +--------------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------------+-------------+------+-----+---------+-------+ | record_number | int(1...