This means you'll have to query and update all existing rows in all tables associated with the fields by the type defined in your .An example of this can be found here: All in all quite a bit of work., command to update a table from a single data source, you can perform a merge operation by creating a staging table and then using one of the methods described in this section to update the target table from the staging table.Note You should run the entire merge operation, except for creating and dropping the temporary staging table, in a single transaction so that the transaction will roll back if any step fails.Update database tables for new versions using a hook_update_N() function.Note that when you create a hook_update_N() function, you should add a documentation header to the function, whose first line concisely describes the update(s) to be performed.Using Field API, you've already created a new field and it works great. The original schema, using hook_field_schema(): If you want to update a custom field, say to change the precision of the underlying column (or columns) from single to double, you often face the problem of not knowing what its associated table and column names are, as they're based on the machine name as entered by the user in the "Manage Fields" section of the entity in question.In addition to this, you may want to re-calculate and re-store existing data as double precision numbers.
Visit Stack Exchange Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. In the above table, i want to update the values "SALES" to "SALES (ROB)" or FINANCE to FINANCE (John) . I tried splitting the columns but i am unable to get the manager name associated to the rows where the entry is missing.