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