zqifa的博客

我不管,反正我最萌~

当前分类:数据库
golang gorm报错[error] failed to initialize database, got error commands out of sync. Did you run multiple statements at once?问题解决

golang中使用gorm连接mysql数据库报错问题解决。报错信息:[error] failed to initialize database, got error commands out of sync. Did you run multiple statements at once?

阅读全文

mysql报错Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column问题解决

报错信息:Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'web_db.articles_tag.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

阅读全文

mysql报错Expression #2 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column问题解决

报错信息:Expression #2 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'web_db.articles_tag.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

阅读全文

win10下php安装mongodb扩展

今天做项目要使用mongodb,发现没有mongodb扩展,下面是win10下php安装MongoDB扩展的教程。

阅读全文

centos7 安装mongodb

一、安装步骤 安装的时候mongodb最新版为3.4 进入yum镜像配置目录 cd /etc/yum.repos.d/ 新建mongodb-org-3.4.repo vi mongodb-org-3.4.repo

阅读全文

windows上如何安装Sqlite

一、安装下载地址:`http://www.sqlite.org/download.html`将Precompiled Binaries for Windows下的包下载下来sqlite-dll-win64-x64-3150100.zip、sqlite-tools-win32-x86-3150100.zip。sqlite-dll-win64-x64-3150100.zip包含.def、.dll两个文件sqlite-tools-win32-x86-3150100.zip包含三个执行文件exe

阅读全文

mysql 中find_in_set()和in()用法比较

mysql 中find_in_set()和in()用法比较,在mysql中in可以包括指定的数字,而find_in_set()用于特定的数据类型。find_in_set 函数使用方法个例子来说:有个文章表里面有个type字段,它存储的是文章类型,有 1头条、2推荐、3热点、4图文...1,12,13 等等 。

阅读全文

Copyright © zqifa 联系方式:z___qf@163.com