When using the MySQL DBMS for "manual" operations, it is most convenient to use the PhpMyAdmin application. Today it is the most common program offered by hosting companies to their customers for performing database operations. Its interface is loaded directly into the user's browser, and the operation of deleting a record from a table in the database is quite simple.
Instructions
Step 1
Load the application into the browser, log in and click in the left frame the link to the database to which the table with the data you are interested belongs to. As a result, the list of tables in the selected database will be loaded into this frame.
Step 2
Click the one you need in the list of tables, and the application will load a page with controls related to it in the right frame. By default, this page will open in the "Structure" tab, and to find the record you want to delete, you must go to the "Search" tab - click the corresponding link in the menu of the right frame.
Step 3
Set a limit on the number of lines displayed on one page, specify the sort order and the field by which the data should be ordered - these controls are placed in the top section. Click the "OK" button in this section to display the contents of the table on the screen and select the required row. There is another option for searching for a string - in the section below you can specify the values to be searched for in the fields of the table. In this case, you should click the "OK" button assigned to this section, after which the application will send a request to the server and the data filtered in accordance with the parameters you specified will be displayed in a table in the same frame.
Step 4
Click the red cross in the row of the data table to be deleted. If you need to delete several records, then put a check in the checkbox of each of the unnecessary more lines, and then click on the red cross, placed under the data table next to the inscription "With marked".
Step 5
Confirm the delete operation by clicking "Yes" on the next page loaded by the application into the right frame. After that PhpMyAdmin will send the corresponding SQL query to the server, and the received report on the operation will be displayed on the screen.
