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


Popular posts from this blog

Enable offline mode to improve Android Studio speed

How to remove last commit from Git