![](https://img-blog.csdnimg.cn/20201014180756780.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
LilyMM_123
自己努力一下,相信自己的力量
展开
-
PHP使用外部命令导出数据库,备份到服务器并下载到本地
php // $dumpFileName目录要有可写权限 $DbHost = 'localhost'; $DbUser = 'root'; $DbPwd = '123456'; $DbName = 'a'; $fileName = $DbName . '_MySQL_data_backup_' . date('YmdHis) . '.sql'; $d转载 2015-04-28 15:22:43 · 651 阅读 · 0 评论 -
mysql,thinkphp模式查询返回健值对
M("user", 'kw_')->getField('id,real_name');原创 2015-05-14 16:50:40 · 647 阅读 · 0 评论 -
数据按天分类
public function show(){ $m = new Model(); $sql = "select *,FROM_UNIXTIME(created,'%Y-%m-%d') as created from table1 group by created ORDER BY created desc"; $result = $m->query($sql);原创 2015-05-14 17:02:26 · 474 阅读 · 0 评论