| 1234567 |
- --根据会员卡号来修改会员消费密码;
- --USE [db]
- --UPDATE [dbo].[membermanage] SET [psw] = '新密码' WHERE [memberno] = '会员卡号'
- --示例,会员卡号'ABC123456789',消费密码遗忘,要重新设置为'888888'
- USE [db]
- UPDATE [dbo].[membermanage] SET [psw] = '888888' WHERE [memberno] = 'ABC123456789'
|
