From here, you can get know how to run SQL-request (snippet) in a few ways. There is no need to read long tutorials!

Precautionary measures: You need to create a backup copy of your database in the following cases:

• before executing an unknown code
• before making big changes
• Just in case

Solutions:

You can run SQL-request with the help of:

• phpMyAdmin (web-interface)
• mysql program (SSH, command line)

phpMyAdmin (web-interface)

• If you have a request, you can simply run it. To do this:
  • Select database in phpMyAdmin,
  • Click SQL tab (“Run SQL request(s) on DB”),
  • Insert SQL-request to the appropriate field and
  • Click “Run”
• You can also make changes in tables and fields of database.

mysql program (SSH, command line)

It is very simple to use mysql. Run this in the command line:

shell> mysql db_name

Or:

shell> mysql –user=user_name –password=your_password db_name

Then enter SQL-request and end it with “;”, \g, or \G. Press Enter.

Note: use man mysql to specify the parameters.