mysql> use member;
Database changed
mysql> update member set member_email = concat(member_id, '@123.com'), member_password='e10adc3949ba59abbe56e057f20f883e';
Query OK, 7100 rows affected (0.63 sec)
Rows matched: 7100 Changed: 7100 Warnings: 0
mysql> use yoohouse_alpha;
Database changed
mysql> update member_broker set member_email = concat(member_id, '@123.com');
Query OK, 6867 rows affected (0.24 sec)
Rows matched: 6867 Changed: 6867 Warnings: 0
mysql> update broker_company set company_account = concat(company_id, '@123.com'), company_password='e10adc3949ba59abbe56e057f20f883e';
Query OK, 79 rows affected (0.01 sec)
Rows matched: 79 Changed: 79 Warnings: 0
mysql> update broker_shop set shop_account = concat(shop_id, '@123.com'), shop_password='e10adc3949ba59abbe56e057f20f883e';
Query OK, 1320 rows affected (0.09 sec)
Rows matched: 1320 Changed: 1320 Warnings: 0
mysql> update company_areamgr set mgr_account = concat(mgr_id, '@123.com'), mgr_password='e10adc3949ba59abbe56e057f20f883e';
Query OK, 35 rows affected (0.01 sec)
Rows matched: 35 Changed: 35 Warnings: 0
阅读(828) | 评论(0) | 转发(0) |
