HOME | PHP Tutorial | CSS
facebook icon
AgerNic.com
WEB DEVELOPER SITE, HTML, CSS, PHP
PHP Tutorial

PHP forms
HTML Tutorial

CSS Tutorial

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:
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;

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

2581. SQL ORDER BY - SQL Tutorial

http://www.sql-tutorial.net/SQL-ORDER-BY.asp

3290. SQL delete row - SQL delete table, sql tutorial
SQL delete row - SQL delete table sql tutorial
https://www.agernic.com/sql-tutorial/sql-delete-row-sql-delete-table.html

2817. PL/SQL Tutorial
We provide you with a comprehensive PL/SQL tutorial to help you learn PL/SQL quick and fun.
http://www.zentut.com/plsql-tutorial/

3283. Insert into SQL - Insert into table SQL - Insert data in sql, sql tutorial
Insert into SQL - Insert into table SQL - Insert data in sql sql tutorial
https://www.agernic.com/sql-tutorial/insert-into-sql-insert-into-table-sql-data-in-sql.html

3289. SQL create table primary key autoincrement, sql tutorial
SQL create table primary key autoincrement sql tutorial
https://www.agernic.com/sql-tutorial/sql-create-table-primary-key-autoincrement.html

48. SQL Tutorial - An Ultimate Guide for Beginners
SQL Tutorials for Beginners - Learn the concepts of world
https://www.tutorialrepublic.com/sql-tutorial/

Your add here
PHP htmlspecialchars() function

PHP htmlspecialchars_decode() function

PHP strlen() function

PHP strtolower() function

PHP count() Function

PHP strip_tags() function

PHP wordwrap() function

PHP str_replace() function

PHP ltrim() function

PHP str_split() function

PHP str_repeat() function

PHP md5() function

PHP print() function

PHP printf() function

PHP html_entity_decode() function

PHP rtrim() function

HTML Color Text
PHP delete an element from an array
HTML image, size, link and image background
How to prevent sql injection in php mysqli
CSS Class and ID, The Difference Between ID and Class
How to add text, paragraf in HTML