lei___2011的专栏

启动/暂停mysqlnet start mysqlnet stop mysql登录Mysql 连接本地mysqlmysql -u sonar -p连接远程mysqlmysql -h主机地址 -u用户名 －p用户密码退出mysqlexit基础使用 创建数据库设置编码格式：create database test character set utf8;查看数据库 show databases;

mysql使用update UPDATE zt_project b SET b.deleted=’1’ WHERE b.id IN (SELECT p.id FROM zt_projectproduct pp, zt_project p WHERE pp.product IN (20) AND p.id = pp.project AND p.deleted = ‘0’)报错： You can

想要同时统计bug表的激活bug数量，与已完成bug数量。 SELECT p.name ‘所属项目’, COUNT(b.status) ‘激活状态BUG总数’ FROM zt_bug b ,zt_project p WHERE b.project IN (464,465,466) AND p.id=b.project AND b.status=’active’ GROUP BY projec