Altering, cleaning and merging tables
Mistakes happens, and tables need to be altered or updated occasionally. You can alter
data manually in the MCC, but as your tables become larger, it becomes impractical to
correct values by hand. The simplest way of altering a table is to apply a change to an
entire field, e.g.,
Update my_syllables set cluster=0;
is going to erase all your cluster values, setting them to zero. So, if you actually like most
of your clusters, but not cluster 4, you could type:
Update my_syllables set cluster=0 where cluster=4;
In short, you can alter subset of your data using the exact same method for selecting
subset of your data.
Eliminating duplicates:
Finally, it is quit easy to merge two tables into a single, large table:
Insert into my_first_table select * from my_second_table;
Created using Helpmatic Pro HTML