随笔分类 - [05]数据之库
摘要：DROP TABLE IF EXISTS `sys_config`; CREATE TABLE `sys_config` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `param_key` varchar(50) DEFAULT NULL COMMENT '
阅读全文
摘要：mysql> grant all privileges on e_government.* to jszw@'%' identified by 'jszw123456'; Query OK, 0 rows affected (0.00 sec) mysql> flush privileges; Qu
阅读全文
摘要：UPDATE person SET urls = (REPLACE(urls,'xh',id)); UPDATE person SET urls = (REPLACE(urls,'xh','hx'));
阅读全文
摘要：什么是大小写敏感 lower_case_table_names值为1的时候，查询mysql会自动将查询的表小写化。为0的时候，会去查询大写的表。 修改配置 如果不知道，可以用find查找 # find / -name my.cnf # vim /etc/my.cnf 添加如下内容 # 大小写敏感 1
阅读全文
摘要：$User = M("User"); // 实例化User对象 $map['name|title'] = 'thinkphp'; // 把查询条件传入查询方法 $User->where($map)->select(); $User = M("User"); // 实例化User对象 $map['na
阅读全文
摘要：CREATE TABLE `property_fee_config` ( `id` int(10) NOT NULL AUTO_INCREMENT, `village_id` int(11) NOT NULL COMMENT '小区id', `building_type_ids` text NOT
阅读全文
摘要：   && ($end_time = $this->input_data['end_time'])) { $where['create_time'] = [['gt',$start_time.' 00:
阅读全文
摘要：set password for 'root'@'localhost'=password('Sqkj123456');
阅读全文
摘要：sudo chown -R mysql /usr/local/mysql
阅读全文
摘要：/** * 获取企业 */ public function getCompany() { $company = M('company'); $company_list = $company->where(['type'=>1])->field('id,name')->order('CONVERT(n
阅读全文
摘要：/** * 更新昨日收益,流量主,业务员都更新 */ public function updateYesterdayEarnings() { $yestoday = strtotime('-1 day', strtotime(date('Y-m-d'))); $wx_user = M('wx_use
阅读全文
摘要：SELECT id FROM `tf_article` WHERE id BETWEEN 1 and 3; 实践证明，包含头和尾。
阅读全文
摘要：composer require lustre/php-dfa-sensitive use DfaFilter\SensitiveHelper; /** * 过滤敏感词 */ public function getSensitiveWord() { $json = new Json(); $red
阅读全文
摘要：$rec_code = Func::createInviteCode(); $r = true; while($r) { // 艹，语法错误导致,无限循环中，接口走不下去了 // $r = $user->where("rec_code",$rec_code)->find(); $r = $user-
阅读全文
摘要：$order_item = M('order_item'); $order_item_list = $order_item->field(['*','sum(num) as num'])->group('sku_id')->order('num desc')->limit(10)->select()
阅读全文
摘要：<?php $host = '127.0.0.1'; $user = 'root'; $pwd = '123456'; $dbname = 'test'; // sql $sql = "delete from user where id=1;"; try { // 连接数据库 $conn = new
阅读全文
浙公网安备 33010602011771号