/SQL/Sql update where id

Sql update where id

Sql update record

SQL> UPDATE CUSTOMERS
SET ADDRESS = 'Pune'
WHERE ID = 6;

6

Source: tutorialspoint.com

Sql update where id

UPDATE Supplier
   SET Phone = '(03) 8888-5011'
 WHERE id = '513'

1

Sql update where id

UPDATE `table_name` SET `status` = '555' WHERE `product_id` = 2386

0

Similar codes

1 vote160 views1 answer
How to get alternate records from a table in sql
SQL
1 vote170 views2 answers
Mysql join two tables
SQL
0 vote161 views2 answers
Mysql regexp match word
SQL
0 vote159 views1 answer
Increment id in mysql
SQL
0 vote175 views1 answer
Exectuer myssql .sql
SQL
5 votes179 views1 answer
Find table from column name in sql
SQL
2 votes180 views1 answer
Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
SQL
0 vote157 views1 answer
Dasebase_url-postgres for windows
SQL
0 vote185 views1 answer
Virtuoso sql query tutorial
SQL
0 vote190 views1 answer
Mysql 5.7 in centos 7
SQL

Share