Inserting Or Modifying Data

[peterlaursen]

this is a sql-mode issue.

Please refer to: http://webyog.com/faq/28_72_en.html

Please understand that it is the server that behaves like that in 'non-strict' mode – not SQLyog.

SQLyog does not alter data itself. It only sends SQL to the server.

We do intend to improve the handling of sql_modes, but have not yet fully annalyzed what is possible form a grid-based program. The problem is that if a column is defined as NOT NULL and does not have a DEFAULT, there are some issues when updating from the RESULT tab. That also will affect Usr management as the user table has some BLOB fields defined as NOT NULL (and BLOBs cannot have defaults).

One solution couild be only to SET sql_mode = '' for those operations where it is required and switch back again after that.

[idroj]

Thanks a lot, for the answer, it works OK.

The new Question is:

Is posible to change sql-mode when I start a conection in SQLyog with statement set session sql_mode ='TRADITIONAL' or …?

[peterlaursen]

Yes .. just write the “SET sql_mode = ” yourself.

But when updating from RESULT tab if not all columns are shown and if the columns not shown are defined as NOT NULL and have no DEFAULT, then the UPDATE (and INSERT) statement may fail. That is true for the 'strict_all_tables' mode and the 'strict_trans_tables' with transactional tables (InnoDB tables). And maybe other modes too.

[Author]

Posts