随笔分类 -  07Mysql

摘要：select job_name, ft_brch,LINE_cover,incre_cover,commit_id, compa_with,create_date from functest_buids_info,hole_functest,incre_functest where functest 阅读全文

摘要：数据库优化 网上参考方法如下： $d = mysql_fetch_row($r); $rand = mt_rand(0,$d[0] - 1); $r = mysql_query("SELECT username FROM user LIMIT $rand, 1"); $d = mysql_fetch 阅读全文

摘要：常用函数 总数：select count as totalcount from table1 求和：select sum(field1) as sumvalue from table1 平均：select avg(field1) as avgvalue from table1 最大：select m 阅读全文

摘要：数据操作 插入数据 insert into test (id,email,ip,state) values(2,'qq@qq.com','127.0.0.1','0'); 删除数据 delete from test where id = 1; 修改数据 update test set id='1', 阅读全文

摘要：用户操作 创建用户 create user ‘username’@’host’ identified by ‘password’ host：本地：localhost，任意远程主机登陆：通配符% 用户授权 普通用户授权 GRANT privileges ON databasename.tablenam 阅读全文

摘要：mysql 登录本机 mysql -u root -p password 数据库操作 创建数据库 命令：create database <数据库名> 例如：mysql> create database xhkdb; 显示数据库 show databases; 连接数据库 use examples; 阅读全文