Tuesday, January 15, 2019

Important SQL Query - Ready Reckoner

1. For Displaying records:

select * from [table_name];

select * from [table_name] where [field_name]='1';



2. Deleting specific records:

delete from [table_name] where [field_name]>0;



3. Insert Records

insert into [table_name] (field1, field2, field3,...) values (value1, value2, value3,...);

insert into [table_name] values (value1, value2, value3,...);



4. Update Records:

update [table_name] set [field1]=[new_value] where [field2]="1";


No comments:

Post a Comment

URL Redirection scenarios to be tested while installing SSL Certificates

If you are trying to install SSL certificates for the first time. Do ensure to test all possible scenarios of URL direction Ensure ht...