Update a single row

Update a single row

Easy SQL DML 19 views
Explanation Complexity

Problem Statement

Update customer city to 'Delhi' where customer_id=101.

Input Format

SQL DML

Output Format

DML statement(s)

Example

Customers
Row updated

Constraints

None

Input / Output Format

Input Format
SQL DML
Output Format
DML statement(s)
Constraints
None

Examples

Input:
Customers
Output:
Row updated

Example Solution (Public)

SQL 
UPDATE Customers SET city = 'Delhi' WHERE customer_id = 101;

Official Solution Code

UPDATE Customers SET city = 'Delhi' WHERE customer_id = 101;
Please login to submit solutions.
Editor
Output

                                        

                                    

                                    

                                        

                                                                                    
Please login to submit solutions.