![]() ![]() ![]() We can also use the following if we don't have any mode activated: mysql -u root -p -e 'SET sql_mode = ' ' ' To disable it from the terminal temporarily, we must have to run the following command, replacing root with our user: mysql -u root -p -e 'SET sql_mode = 'NO_ENGINE_SUBSTITUTION ' ' Temporarily disabledĬonsidering that NO_ENGINE_SUBSTITUTION was already activated, and we do not want to deactivate it, we only execute the first line of each code, in case of not having any previous mode, we use the last line of each code according to each case. Procedure: It is recommended that when deactivating this mode, it is necessary to copy the other modes that were activated, and only subtract STRICT_TRANS_TABLES and STRICT_ALL_TABLES, the modes must be separated with comma and without spaces. Instead, the permanent solution could be useful when we use systems that require it, such as when installing Directus (a Headless CMS), which in the documentation mentions that it is necessary to deactivate this mode. ![]() ![]() The temporary way could be useful for debugging or for executing problematic SQL statements. There are two ways to disable this mode, the first is temporary, and the second is permanent. Deactivate the 'Strict Mode' temporarily or permanently In any case, if the text STRICT_TRANS_TABLES or STRICT_ALL_TABLES appears, it means that strict mode is enabled. STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION | sql_mode | STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION | ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |