Collections:
Updating Values in a Table in MySQL
How To Update Values in a Table in MySQL?
✍: FYIcenter.com
If you want to update some values in one row or multiple rows in a table, you can use the UPDATE statement. The tutorial script below shows a good example:
mysql> UPDATE fyi_links SET counts = 999, notes = 'Good.' WHERE id = 101; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql> SELECT id, url, notes, counts, DATE(created) FROM fyi_links WHERE id = 101; +-----+-------------------+-------+--------+---------------+ | id | url | notes | counts | DATE(created) | +-----+-------------------+-------+--------+---------------+ | 101 | dev.fyicenter.com | Good. | 999 | 2006-04-30 | +-----+-------------------+-------+--------+---------------+ 1 row in set (0.00 sec)
⇒ Update Column Values on Multiple Rows in MySQL
⇐ Insert Multiple Rows with 1 INSERT Statement in MySQL
2018-01-13, 1317🔥, 0💬
Popular Posts:
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is ...
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...