03 2017 档案

sublime 3 配置参考
摘要：{ "draw_white_space": "selection", "font_size": 9, "ignored_packages": [ "Vintage" ], "fallback_encoding": "UTF-8", "default_encoding": "UTF-8", "defa 阅读全文
posted @ 2017-03-25 09:41 zergling9999 阅读(143) 评论(0) 推荐(0)
加个order by使得查询效率提高500倍
摘要：很简单的三个表： p248_user记录用户信息 CREATE TABLE `p248_user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `list_ids` varchar(4000) NOT NULL DEFAULT '', `email` varcha 阅读全文
posted @ 2017-03-17 18:06 zergling9999 阅读(3673) 评论(0) 推荐(0)
yii2 migration里使用Query的例子
摘要：use yii\db\Migration; class m170119_031753_add_list_id_index_on_user_list_table extends Migration { public function up() { $projectIds = (new \yii\db\Query()) ->select... 阅读全文
posted @ 2017-03-08 11:10 zergling9999 阅读(194) 评论(0) 推荐(0)