Home  >  Article  >  Database  >  How to use phpmyadmin to modify data in the data table

How to use phpmyadmin to modify data in the data table

王林
王林Original
2019-12-13 15:10:154687browse

How to use phpmyadmin to modify data in the data table

1. First open the database where the data needs to be modified

How to use phpmyadmin to modify data in the data table

2. Then open the data table where the data needs to be modified, and then click the menu [SQL] option in the column

How to use phpmyadmin to modify data in the data table

3. Finally enter the SQL statement to modify the data and click Execute

For example:

UPDATE table_name SET field1=new-value1, field2=new-value2 [WHERE Clause]

Related article tutorial recommendations: phpmyadmin tutorial

The above is the detailed content of How to use phpmyadmin to modify data in the data table. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn