windows下恢复Bugfree中删除的用户

最新推荐文章于 2024-09-24 15:24:59 发布

置顶 vcstorm

最新推荐文章于 2024-09-24 15:24:59 发布

阅读量1.2k

点赞数

文章标签： windows mysql warnings email query

本文链接：https://blog.csdn.net/vcstorm/article/details/2514779

版权

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;

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

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

| 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;+--------+----------+----------------------------------+-----------+----------------------+----------+

| 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

关注