1) Edit my.cnf
For Debian :
located at /etc/mysql/my.cnf , add to my.cnf
2) Restart mysql
3) Check it by running this query
For Debian :
located at /etc/mysql/my.cnf , add to my.cnf
[mysqld]If you want strict mode with full group by use this
sql_mode="STRICT_ALL_TABLES"
[mysqld]
sql_mode="STRICT_ALL_TABLES,ONLY_FULL_GROUP_BY"
2) Restart mysql
3) Check it by running this query
SELECT @@GLOBAL.sql_mode;Note: If you want turn off strict mode on run time just run this query
SET @@global.sql_mode='STRICT_ALL_TABLES'Thats it.
OR
SET @@session.sql_mode='STRICT_ALL_TABLES'
2 comments:
escorts in lucknow
lucknow escorts
call girls in lucknow
escort service in lucknow
russian escorts in lucknow
lucknow escort services
lucknow call girls
russian escorts in gurgaon
housewife escorts in gurgaon
gurgaon escort services
gurgaon escorts
escorts in gurgaon
escort services in gurgaon
gurgaon call girls
call girls in gurgaon
Post a Comment