如何在mac中修改mysql的sql_mode

chefjuicy 2017-10-19 10:01:42
各位朋友，我是在mac里面装的mysql
然后我想把sql_mode改为ANSI宽松模式，请问我该怎么搞呀？
...全文
639 2 打赏 收藏 转发到动态 举报
AI 作业
写回复
用AI写文章
2 条回复
切换为时间正序
请发表友善的回复…
发表回复
weihao9939 2017-11-09
  • 打赏
  • 举报
 回复
针对mac端，并且没有my-default.cnf的用户 修改期间必须关闭mysql 我们要在/etc下新建my.cnf $ cd /etc $ sudo vim my.cnf 输入: 内容见此链接 http://www.jianshu.com/p/90b5a749b3b0 保存并退出 重启mysql。
OwenZeng_DBA 2017-10-20
  • 打赏
  • 举报
 回复
[mysqld] sql_mode='你想要的模式' 修改配置文件my.cnf，mac应该也有对应的文件
MySQL中SQL Mode的查看与设置详解
MySQL中SQL Mode的查看与设置 MySQL可以运行在不同的模式下，而且可以在不同的场景下运行不同的模式，这主要取决于系统变量 sql_mode 的值。本文主要介绍一下这个值的查看与设置，主要在Mac系统下。 对于每个模式的意义和作用，网上很容易找到，本文不做介绍。 按作用区域和时间可分为3个级别，分别是会话级别，全局级别，配置（永久生效）级别。 会话级别： 查看- select @@session.sql_mode; 修改- set @@session.sql_mode='xx_mode' set session sql_mode='xx_mode' session均可省略，默
mac下的mysql连接工具，navicat，支持最新的mojave版本
mac下的mysql连接工具，navicat，支持最新的mojave版本。亲测可用。希望大家能用的给个好评。
详解Mysql数据库date, datetime类型设置0000-00-00默认值(default)报错问题
现象:MySQL5.7版本之后,date, datetime类型设置默认值”0000-00-00″,出现异常:Invalid default value for ‘time’ 原因:在命令行窗口查看当前的sql_mode配置: select @@sql_mode; 结果如下: ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE,  ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, and NO_ENGINE_SUBSTITUTION  其中NO_Z
MySQL V5.5帮助文档
Preface and Notes 1. General Information 1.1. About This Manual 1.2. Typographical and Syntax Conventions 1.3. Overview of the MySQL Database Management System 1.3.1. What is MySQL? 1.3.2. History of MySQL 1.3.3. The Main Features of MySQL 1.4. MySQL Development History 1.5. What Is New in MySQL 5.5 1.5.1. Scalability Improvements 1.5.2. InnoDB I/O Subsystem Changes 1.5.3. Enhanced Solaris Support 1.5.4. Diagnostic and Monitoring Capabilities 1.6. MySQL Information Sources 1.6.1. MySQL Mailing Lists 1.6.2. MySQL Community Support at the MySQL Forums 1.6.3. MySQL Community Support on Internet Relay Chat (IRC) 1.6.4. MySQL Enterprise 1.7. How to Report Bugs or Problems 1.8. MySQL Standards Compliance 1.8.1. What Standards MySQL Follows 1.8.2. Selecting SQL Modes 1.8.3. Running MySQL in ANSI Mode 1.8.4. MySQL Extensions to Standard SQL 1.8.5. MySQL Differences from Standard SQL 1.8.6. How MySQL Deals with Constraints 1.9. Credits 1.9.1. Contributors to MySQL 1.9.2. Documenters and translators 1.9.3. Packages that support MySQL 1.9.4. Tools that were used to create MySQL 1.9.5. Supporters of MySQL 2. Installing and Upgrading MySQL 2.1. General Installation Guidance 2.1.1. Operating Systems Supported by MySQL Community Server 2.1.2. Choosing Which MySQL Distribution to Install 2.1.3. How to Get MySQL 2.1.4. Verifying Package Integrity Using MD5 Checksums or GnuPG 2.1.5. Installation Layouts 2.1.6. Compiler-Specific Build Characteristics 2.2. Installing MySQL from Generic Binaries on Unix/Linux 2.3. Installing MySQL on Microsoft Windows 2.3.1. MySQL Installation Layout on Microsoft Windows 2.3.2. Choosing An Installation Package 2.3.3. Installing MySQL on Microsoft Windows Using an MSI Package 2.3.4. MySQL Server Instance Configuration Wizard 2.3.5. Installing MySQL on Microsoft Windows Using a noinstall Zip Archive 2.3.6. Troubleshooting a MySQL Installation Under Windows 2.3.7. Upgrading MySQL on Windows 2.3.8. Windows Postinstallation Procedures 2.4. Installing MySQL on Mac OS X 2.4.1. General Notes on Installing MySQL on Mac OS X 2.4.2. Installing MySQL on Mac OS X Using Native Packages 2.4.3. Installing the MySQL Startup Item 2.4.4. Installing and Using the MySQL Preference Pane 2.4.5. Using the Bundled MySQL on Mac OS X Server 2.5. Installing MySQL on Linux 2.5.1. Installing MySQL from RPM Packages on Linux 2.5.2. Installing MySQL on Linux using Native Package Manager 2.6. Installing MySQL on Solaris and OpenSolaris 2.6.1. Installing MySQL on Solaris using a Solaris PKG 2.6.2. Installing MySQL on OpenSolaris using IPS 2.7. Installing MySQL on HP-UX 2.7.1. General Notes on Installing MySQL on HP-UX 2.7.2. Installing MySQL on HP-UX using DEPOT 2.8. Installing MySQL on FreeBSD 2.9. Installing MySQL from Source 2.9.1. MySQL Layout for Source Installation 2.9.2. Installing MySQL from a Standard Source Distribution 2.9.3. Installing MySQL from a Development Source Tree 2.9.4. MySQL Source-Configuration Options 2.9.5. Dealing with Problems Compiling MySQL 2.9.6. MySQL Configuration and Third-Party Tools 2.10. Postinstallation Setup and Testing 2.10.1. Unix Postinstallation Procedures 2.10.2. Securing the Initial MySQL Accounts 2.11. Upgrading or Downgrading MySQL 2.11.1. Upgrading MySQL 2.11.2. Downgrading MySQL 2.11.3. Checking Whether Tables or Indexes Must Be Rebuilt 2.11.4. Rebuilding or Repairing Tables or Indexes 2.11.5. Copying MySQL Databases to Another Machine 2.12. Environment Variables 2.13. Perl Installation Notes 2.13.1. Installing Perl on Unix 2.13.2. Installing ActiveState Perl on Windows 2.13.3. Problems Using the Perl DBI/DBD Interface
MySQL数据库详细教程
mysql 数据库详细教程
疑难问题

22,300

社区成员

121,734

社区内容

发帖
与我相关
我的任务
社区描述
MS-SQL Server 疑难问题
社区管理员
  • 疑难问题社区
  • 尘觉
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章