Copy all mobile numbers from "phone" to "smsalertnumber".

Often mobile number of patron entered in the "phone" field in "borrowers" table. Koha users need SMS notifications have to install driver. After the installation of SMS driver, an additonal field "smsalertnumber" will generate. The field does not contain phone number. Where we have to enter the mobile number. Its tedious task to copy each mobile number from the field "phone" to "smsalertnumber". 

Here is an easy method to copy all mobile number from "phone" field to "smsalertnumber". Apply following SQL query:

sudo su
mysql -uroot -p

use koha_library;
UPDATE `borrowers` SET smsalertnumber=phone;
quit


Reference
http://stackoverflow.com/questions/9001939/copy-values-from-one-column-to-another-in-the-same-table

No comments:

Post a Comment