To modify records, you can use the UPDATE statement. The syntax format is as follows: UPDATE data table name Set column_name = new_value1, column_name2 = new_value2,...[where condition] Among them, the Set clause indicates the column to be modified. With their given values, the where clause is optional. If given it specifies which rows in the record should be updated. Otherwise, all rows in the record will be updated. For example, suppose there is a table called admin, and we want to change the password of Tom in the table from 111 to 222. The statement is as follows: UPDATE admin Set password = '222' where user = 'Tom'; Note: Be sure to ensure that when updating The correctness of the where clause. Once the where clause is wrong, all changed data will be destroyed. Delete records in the database. If some data have lost their meaning or are wrong, they need to be deleted. At this time, you can use the DELECT statement, which
1. MySQL modification and delete statement operations ( MYSQL statement operation tutorial 2)
## Introduction: Modify records. To perform modification operations, you can use the UPDATE statement. The format of the syntax is as follows: UPDATE data table name set column_name = new_value1, column_name2 = new_value2,...[where condition] Among them, the set clause indicates the columns to be modified and their given values, and the where clause is optional. If given it specifies which rows in the record should be updated, otherwise, all rows in the record will be updated. For example, suppose there is a table called admin. We want to change the password of Tom in the table from 111 to 222. The statement is as follows:
2. mysql statement, what should I do? Processing
Introduction: mysql statement I would like to ask a mysql delete statement to delete all the URLs... For example, an article contains URL links. I want to delete all URLs. Delete this URL, http://www.baidu.com or www.baidu.com. How to write this deletion statement------Solution------------ --------update table s
Introduction: PHP batch delete Batch delete the id of the data to be deleted to form an array deletion statement: delete from `user` where id in ($ID_Dele) as follows: