I found where the data went by exporting the sites database. Rather than create a new table named content_field_street_name, as I would have expected, it created content_type_[content_type_name]. This table has fields: vid, nid and field_street_name_value. I'm about out of time today but I wonder what would've happened had I added two new fields to this CCK type.
On Fri, 2009-11-20 at 12:07 -0800, Scott wrote:
I've created a new field for a CCK type and it works fine in my drupal site. My problem is that it does not show up in mysql command line interface or with phpmyadmin. This is confusing to me. I can modify, add and delete data using the edit node function when viewing a page, so I know the data is somewhere, however, I wish to do a batch load of this field with mysql.