Ability to do simple mass changes to all records at one time
I would really like a way to make mass changes to all the records in my table at one time. At least a way to (1) Set a field in all records to a certain value; (2) A way to take a certain field in a record and copy it to another field in the same record (this makes sense, for instance, if you add a new field that is going to replace another field but you want the new field to contain the data from the old field); and (3) If you could do some expressions on that a field in all the records (like maybe truncating it, combining it with other records, etc) that would be even better. Really just some way to automate running through all the records in your table and performing some kind of replacement/calculation/addition/etc. would be VERY helpful! Maybe having a small SQL type language to use??