SQL update - SQL update select - SQL update multiple rows
The SQL UPDATE Query is used to modify the existing records in a table from database. You can use WHERE with the UPDATE query to update the selected rows from your database, otherwise all the rows would be affected.
SQL update - SQL update select - how to create? - example
UPDATE Syntax
UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;
The following SQL statement update "Customers" table:
Example 1:
UPDATE: Updates the first customer (ID = 1) with a new Contact person and a new Address.
| ID | Name | Contact | Address | City |
|---|---|---|---|---|
| 1 |
Jones Cruise | Ana Maria | Will Str. 57 | Paris |
| 2 | Robert Caine | Ana Trujillo | Avda. Larga 24 | Roma |
| 3 | Brad Bale | Antonio mauro | Mataderos 19 | Madrid |
UPDATE Customers
SET Contact = 'Meryl Streep', Address= 'Avenida 34a'
WHERE CustomerID = 1;
SET Contact = 'Meryl Streep', Address= 'Avenida 34a'
WHERE CustomerID = 1;
UPDATE: Updates the first customer (ID = 1) with a new Contact person and a new Address.
| ID | Name | Contact | Address | City |
|---|---|---|---|---|
| 1 |
Jones Cruise | Meryl Streep | Avenida 34a | Paris |
| 2 | Robert Caine | Ana Trujillo | Avda. Larga 24 | Roma |
| 3 | Brad Bale | Antonio mauro | Mataderos 19 | Madrid |
Note: WHERE clause specifies which record(s) that should be updated
sql update, select, multiple rows, join, multiple columns, date, set null, column value, php
SQL update - SQL update select - sql tutorial
Online Editor
This tool makes it easy to create, adjust, and experiment with custom colors for the web.
HTML Templates
Magnews2 is a modern and creative free magazine and news website template that will help you kick off your online project in style.
CSS HTML Layout
Find here examples of creative and unique website layouts.
Free CSS HTML Menu
Find here examples of creative and unique website CSS HTML menu.