UPDATE STATEMENT - SQL , #SQL_IN_MARATHI,#PROGRAMMINGINMARATHI

Learn use of update statement in SQL #sqlinmarathi,#programminginmarathi --------------------------------------------- create table user_details (firstname varchar(50),lastname varchar(50),email varchar(50),username varchar(50), phonenumber BIGINT); insert into user_details(firstname,lastname,email,username,phonenumber) values ('john','clark','[email protected]','test123',9145768976); insert into user_details(firstname,lastname,email,username,phonenumber) values ('jason','wright','[email protected]','jason123',9178798976); insert into user_details(lastname,email,username,phonenumber) values ('wright','[email protected]','brian123',9178768976); select * from user_details order by username asc; create table user_details_with_constraints(firstname varchar(50) not null ,lastname varchar(50),email varchar(50),phonenumber bigint unique,city varchar(50) default "New York"); insert into user_details_with_constraints(firstname,lastname,email,phonenumber) values ('john','clark','[email protected]',9145768976); insert into user_details_with_constraints(firstname,lastname,email,phonenumber,city) values ('philip','clark','[email protected]',6145768976,"LA"); select * from user_details_with_constraints; select * from user_details where firstname='john' or firstname='jason'; select * from user_details where firstname='john' and username !='john123'; select * from user_details order by username asc; select * from user_details order by username desc;