摘要:
方法一: 在my.ini的[mysqld]字段加入:skip-grant-tables重启mysql服务,这时的mysql不需要密码即可登录数据库 然后进入mysqlmysql>use mysql; mysql>更新 user set password=password('新密码') WHERE U 阅读全文
摘要:
例如 :WHERE(" use_id =(select user_id from store_staff where store_id="+ store_id + ")"); 改为 WHERE(" use_id =any(select user_id from store_staff where s 阅读全文
摘要:
级联查询 where store_id in(select store_id from store_staff where user_id = #{user_id}) 判断赋值 (case when (select use_name from users s where use_id = p.op_ 阅读全文