Mysql restores ONLY_FULL_GROUP_BY after restart

-

Mysql restores ONLY_FULL_GROUP_BY after restart


I must add a new line into /etc/mysql/mysql.conf.d/mysqld.cnf
At the end of the section [mysqld], I added
sql_mode = "STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
Then restarted
sudo systemctl restart mysql
My settings now is preserved after restart.

Popular posts from this blog

Using the new noCAPTCHA reCAPTCHA with Node.js and Express

-
Image
Using the new noCAPTCHA reCAPTCHA with Node.js and Express   Google recently released a  new version of reCAPTCHA  that eliminates typing for many users. Here's a quick how-to for integrating it in your Node.js application. We're going to use Express for simplicity, but these steps are mostly agnostic and could be wrapped into any application. Step 1: Register your site Head over to the  reCAPTCHA site  and add your website to the list. You'll be presented with a screen like this: Copy down the secret and site keys, you'll need them soon. Step 2: Integrate it   Build out a basic Node.js application. The key point is that your HTML view will contain the div listed on the reCAPTCHA settings page, along with the reCAPTCHA client-side JavaScript. On the server, a function similar to the following is needed to verify the submitted claim with the reCAPTCHA server: function verifyRecaptcha(key, callback) { https.get("http...
Read more

Rebuild all indexes in a Database

-
Image
Manually Rebuild Indexing   Indexes can be rebuilt/reorganize in SQL Server Management Studio using the following steps; 1- In Object Explorer locate the table that holds the intended index and expand it. 2- Expand Indexes. 3- Right-click on the index and click on Rebuild or Reorganize. Rebuild All Table Indexing By Script Try the following script: Exec sp_msforeachtable 'SET QUOTED_IDENTIFIER ON; ALTER INDEX ALL ON ? REBUILD' GO Also I prefer(After a long search) to use the following script, it contains  @fillfactor  determines how much percentage of the space on each leaf-level page is filled with data. DECLARE @TableName VARCHAR ( 255 ) DECLARE @sql NVARCHAR( 500 ) DECLARE @fillfactor INT SET @fillfactor = 80 DECLARE TableCursor CURSOR FOR SELECT QUOTENAME(OBJECT_SCHEMA_NAME([object_id])) + '.' + QUOTENAME(name) AS TableName FROM sys.tables OPEN TableCursor FETCH NEXT FROM TableCursor INTO @TableName WHILE @ @FETCH _STATUS = 0 BEGIN SET ...
Read more

Get C# Enum Description from Name And Value

-
enum with Description attributes like this: public enum MyEnum { Transaction = 1 , [ Description ( "Transaction Detail" )] TransactionDetail = 2 , [ Description ( "Transaction Reference Number" )] TransactionRefno = 3 } I put the code together from the accepted answer in a generic extension method, so it could be used for all kinds of objects: public static string DescriptionAttr < T >( this T source ) { FieldInfo fi = source . GetType (). GetField ( source . ToString ()); DescriptionAttribute [] attributes = ( DescriptionAttribute []) fi . GetCustomAttributes ( typeof ( DescriptionAttribute ), false ); if ( attributes != null && attributes . Length > 0 ) return attributes [ 0 ]. Description ; else return source . ToString (); } Using an enum like in the original post, or any other class whose property is decorated with the Description attribute, ...
Read more