Should I split a single table with an AUTO_INCREMENT PRIMARY KEY into two tables that can be joined on that PRIMARY KEY?
It's hard to look at a table that has this many columns, so I
  frequently use a SELECT statement to look at 34 of the fields that I
  mentally categorize as 'group 1' and 12 fields that I categorize as
  'group 2'.


Create a view.