Category Archives: SQL Databases

Fix error: mysql error 1140 (42000).

This query will fix the error mysql error 1140 (42000).

Database online tool .

This tool can help you to deal with many databases and share it online for help. For example to share your query to 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 »

Replace words in the fields of table using SQL.

If you trying to apply a global text string with a replacement, then use this:

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