Tag Archives: sql

sql

FREE MySQL hosting and phpMyAdmin.

If you want to use and test with a FREE MySQL hosting and phpMyAdmin interface then the team development come with this intro: Within a few minutes you could have your own MySQL hosting up and running. All we need is you email address and we will do the rest. Your new hosting details will… Read More »

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 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 »

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