This query will fix the error mysql error 1140 (42000).
1 2 3 4 | ... ; this is incompatible with sql_mode=only_full_group_by mysql> set global sql_mode=\'STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION\'; mysql> set session sql_mode=\'STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION\'; |
This tool can help you to deal with many databases and share it online for help. For example to share your query to dba.stackexchange.com. Just start with setting the work environment and Build Schema. Or just, you can put in your query, run it, and see the output and even the execution plan. The web… Read More »
If you trying to apply a global text string with a replacement, then use this:
1 2 3 4 5 6 | update `your_sql_table` set `field_from_your_sql_table` = replace( `field_from_your_sql_table`, 'wrong_word', 'good_word' ); |
The your_sql_table is the name of the table. The field_from_your_sql_table is the field with records where will be found and replaced words. The wrong_word is the word search and replace by good_word
Always save a backup of your data. An important aspect is a date when the backup was made. Today I will show you how to format the backup name so you know since you have. Select the database and go to the Export tag and Custom – display all possible options. If you select only… Read More »