Tag Archives: sql

Fix error: mysql error 1140 (42000).

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

Posted in All, Errors, SQL Databases. Tagged with , , , , , .

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 web interface is simple and intuitive for those who have already worked with database queries.

Posted in All, SQL Databases, web. Tagged with , , , , , .

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

Posted in Programming, SQL Databases. Tagged with , .

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 one table, you only backup that table.

export database

I prefer a format like this:

If you accidentally selected a table then you will see:

Here is how to select the format name.

format name

You can also choose the output format sql, zip or other archive.

sql zip formats

These are just some settings that you should know.

The phpmyadmin offers multiple possibilities for setting up and configuring

Posted in Programming, SQL Databases. Tagged with , .