如何在mac中修改mysql的sql_mode

chefjuicy 2017-10-19 10:01:42
各位朋友，我是在mac里面装的mysql
然后我想把sql_mode改为ANSI宽松模式，请问我该怎么搞呀？
...全文
600 2 打赏 收藏 转发到动态 举报
写回复
用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均可省略，默
My SQL group by取同组第一条
5.6测试满足。 8.0测试不OK。 网上说的一套一套的，基本都是低版本MySQL5.6。 前情提示： Mac OS10.14； MySQL8.0.18；localhost；这里插一句，MySQL高版本5.7以后，sql_mode有变化，其中之一体现为，group by写法。可查看文章了解： 远程centOS6.8final，MySQL5.6； 表结构，数据都是一样； 测试SQL语句： SELECT SwipeID,MemberID,AddTime FROM ( SELECT * FROM front_membercardswipe fmcs ORDER BY fmcs.AddTime AS
MySQL版SQL优化
本课程通过Centos版的MySQL讲解了SQL优化的一些常见手段。其中讲解了MySQL的分层、存储引擎等底层逻辑，并讲解了常见的索引优化手段。在讲解时，先通过理论对先关的优化知识进行了铺垫，然后使用实际的案例详细的演示了每一次的优化操作。并且在课程的最后，还讲解了如何使用MySQL实现主从同步功能。本课程大致包含了以下几方面的内容：1.MySQL底层逻辑2.常见的优化手段3.常见的优化原则4.优化工具的使用5.主从同步相信通过本课程的学习，大家可以对MySQL的性能优化有一定的理解和认识。为后续高性能系统的开发打下良好的基础和准备。
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
unidac64src 6.4.15
6.4.15 01-Nov-16 Bug with raising 'Argument out of range' error on TCRDBGrid creating in RAD Studio Berlin with Update 1 is fixed Bug with QueryRecCount when ORDER clause contains CASE..END is fixed Bug with processing parameters on setting of an SQL query is fixed Oracle data provider Bug with using DATEADD function in UnifiedSQL is fixed Bug with parameters that contain empty strings in the Direct mode is fixed Bug with memory leak in the Direct mode is fixed SQLServer data provider Bug with processing varchar fields when AutoTranslate is True in the Direct mode is fixed Bug with processing parameter name when a name begins from a number is fixed MySQL data provider Bug with processing TIMESTAMP and DATETIME fields is fixed Bug with loading data from a pipe is fixed SSL support is fixed InterBase data provider Support for international characters in a role name is added Bug with international characters in a database path name in Interbase is fixed Bug with handling the "Connection shutdown" error is fixed Bug with setting query parameters as a string is fixed PostgreSQL data provider SSL support is fixed SQLite data provider Now the Direct mode is based on the SQLite engine version 3.15.0 Bug with batch operations in the Direct Mode on Android is fixed Bug with batch operations in the Direct Mode on Mac OS X is fixed Bug with handling comments in a SQL statement is fixed
疑难问题

22,209

社区成员

121,730

社区内容

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

加载中

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

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

+ 用AI写文章