Re: Error "row xxxx doesn't contain data for all columns"
In the 2 rows after 2010, the string value 'KRAMESSTAYWELL\' occurs; the trailing backslash escapes the following comma, which MySQL therefore ignores.
There are absurdities in the table structure ...
- spaces in column names are illegal; you can get round that with backticks, but it's bad practice
- text for person and place names is wasteful & inefficient; use the smallest varchar size required
- sets of columns whose names end in ..1, ..2 ..3 &c indicate indicates "subtables" that should be normalised, ie projected to child tables
Subject
Written By
Posted
Re: Error "row xxxx doesn't contain data for all columns"
August 16, 2015 11:25AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.