LinkedInTwitterFacebook

Tag Archives: sql

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 set up your 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 […]

Replace words in the fields of table using SQL.

If you trying to apply a global text string with an replace , than 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 find and repleced words. The wrong_word is the word search and replace by good_word

Export the database in phpmyadmin – setting name and filetype.

Always save a backup of your data. An important aspect is the 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 […]