Showing posts from 2019

How to remove last commit from Git

Sometimes while committing codes to Git, we end up doing wrong commits and hence would like to reverse the commit.

Here are the 3 commands which would be handy:

These commands are applicable when you are doing reverse commits in non-master branch:
Open Git Bash and type the following command:

1. git reset HEAD^               
This will remove the recent last commit from the active branch.

2. git push origin :branch_name  This command would delete the branch from remote location of the git.

3. git push origin branch_name  
Now this command will push all the commits from your local to remove by creating the deleted branch again but without the last commit since you deleted it in local git.

If you want to reverse the commit in Master branch, it is little different, Here in non-master branch we deleted the whole branch in remote, but since Master branch is default branch and cannot be deleted, so the trick is little different. If you want to reverse your commit in Master branch, you can  re…

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

Enable offline mode to improve Android Studio speed

If you are starting with Android Studio or have upgraded to the newer version of Android studio, you might experience, the IDE sometimes gets stuck or freezes during the process of compilation.

This might be probably the gradle is working online and trying to download. There are many ways available to boost up the performance of Android Studio, one of them is by enabling Offline Work Mode.

You can achieve significant performance boost by enabling offline mode in Android Studio. Here are the steps to do that:

Please note, I am currently using Android Studio 3.2.1

1. Go to File> Settings.

2. In Settings dialog box, Go to Build, Execution and Deployment section. Under that go to Gradle section.

3. Check the box which mentions "Offline Work" as shown in the below image and click on Apply button.

4. Next go little below under Compiler section and check for the text input area which mentions "Command-line Options.

5. In the command-line Options type, "--offline"…