SQL, how to update data
How to update data stored in a SQL database table
AI workshop
join cohort #1
The data stored in a table can be updated using the UPDATE command:
UPDATE people SET age=2 WHERE name='Roger'It’s important to add the WHERE clause, otherwise this instruction:
UPDATE people SET age=2would update all rows in the table.
I wrote 20 books to help you become a better developer:
- Astro Handbook
- HTML Handbook
- Next.js Pages Router Handbook
- Alpine.js Handbook
- HTMX Handbook
- TypeScript Handbook
- React Handbook
- SQL Handbook
- Git Cheat Sheet
- Laravel Handbook
- Express Handbook
- Swift Handbook
- Go Handbook
- PHP Handbook
- Python Handbook
- Linux Commands Handbook
- C Handbook
- JavaScript Handbook
- CSS Handbook
- Node.js Handbook