windows下恢复Bugfree中删除的用户

D:/xampp/mysql/bin>mysql -uroot -p

此行 为说明:直接回车,因为密码为空

mysql>use BugFree;

mysql>show tables;

mysql>select * from bugfree_testuser;

 +-----------------------+

| bugfree_buginfo       |

| bugfree_caseinfo      |

| bugfree_resultinfo    |

| bugfree_testaction    |

| bugfree_testfile      |

| bugfree_testhistory   |

| bugfree_testmodule    |

| bugfree_testproject   |

| bugfree_testuser      |

| bugfree_testusergroup |

| bugfree_testuserlog   |

| bugfree_testuserquery |

+-----------------------+

12 rows in set (0.00 sec)

mysql> select * from bugfree_testuser;

+--------+----------+----------------------------------+-----------+----------------------+----------+

| UserID | UserName | UserPassword                     | RealName  | Email          | IsDroped |

+--------+----------+----------------------------------+-----------+----------------------+----------+

|      1 | admin    | e10adc3949ba59abbe56e057f20f883e | admin     | admin@yourserver.com | 0        |

|      2 | yourname    | 87857376a2434b575a239e623e27ab26 | 春鍐?| yourname@com.cn     | 1        |

2 rows in set (0.01 sec)

此行 为说明:IsDroped为1的那个记录表明已经被删除。

mysql> update bugfree_testuser set IsDroped = '0' where UserID =2;

Query OK, 1 row affected (0.00 sec)Rows matched: 1  Changed: 1  Warnings: 0

mysql> select * from bugfree_testuser;+--------+----------+----------------------------------+-----------+----------------------+----------+

| UserID | UserName | UserPassword                     | RealName  | Email          | IsDroped |+--------+----------+----------------------------------+-----------+----------------------+----------+

|      1 | admin    | e10adc3949ba59abbe56e057f20f883e | admin     | admin@yourserver.com | 0        |

|      2 | yourname    | 87857376a2434b575a239e623e27ab26 | 春鍐?| yourname@com.cn     | 0        |

+--------+----------+----------------------------------+-----------+----------------------+----------+

2 rows in set (0.00 sec)

mysql> commit;

Query OK, 0 rows affected (0.00 sec)

mysql> exit

Bye    

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值