• To see your databases command-
  SHOW DATABASES
• To see your tables in a database command-
  SHOW TABLES
• To see all the column names in a table named customer command-
  SHOW COLUMNS FROM customers
• If you want to select a column named city from the table customer then command-
  SELECT city FROM customers

I am going to make a few tutorials about MySQL to let you know how to create it and access it. Before going to make that I want to let you know something which is important about SQL and MySQL. MySQL is the world's most popular open source database. Here you can ask-What is database? A database is a collection of data made up of tables to store similar information. It is very much organized to handle data in it.  For example we can say about YouTube. YouTube doesn't hold data in a single table in database. You Tube holds data of its users, videos and comments by creating several tables. These  tables are made up of columns and rows. Here columns are like categories, and rows are like each separate entry ie, each entry goes on a separate row. In this way database works. In a nutshell, we can say that database is a collection of organized data. As I am going to make some tutorials about SQL, I want to tell you some basics about SQL and MySQL. These are-

It is always a very good practice to link Facebook page to your blog. If you have a Facebook page which talks as similar as your blog does then you may want to let your blog readers know that you have a Facebook page regarding the topic of this blog by adding Facebook Popup Like Box Widget. It will not only help you to raise the followers of your Facebook page but it also will help you to convey your message to the vast number of people. I have shown you here how to add this Facebook like widget, just follow my steps and you will be successful to add this widget in your blog.

Steps to add code box in blogger:

• Go to the Dashboard of your blog and select Template.
  
•  Click on Customize.
  
• From the new window select Advanced and click on Add CSS.
• Copy-Paste the below codes in the CSS empty box and apply to the blog.

Command Prompt Shortcut Creation:

I have embedded here a very easy tutorial to create desktop shortcut of Command Prompt for windows PC. Watch the tutorial and learn it within a minute.
Best of luck !

Desktop Shortcut of Command Prompt Commands:

 If you want to create a shortcut for your specific command that you always have use then follow the steps I've shown in this video tutorial. Just the two things I want to mention here, one is write-  C:\Windows\System32\cmd.exe /c YOUR COMMAND in the text file and rename the final file extension .txt to .bat

 

Create Tab/Page in Blogger:

If you are looking for a way to create tab in your blog then I believe that this video tutorial will help you. If you face any problem, or if you have any suggestion then please feel free to let me know leaving comments or contacting with me.
Thanks for visiting my blog. 

Java Keywords:
It is very important to know about the Java keywords before you go to develop Java program. These keywords are part and parcel of Java program. In this article I will introduce you with some Java keywords. There are almost 50 keywords in java. Some of them are explained below:

Class: It is used to define an implementation of a particular kind of object. A class can have class fields, methods and inner classes.

Import: This keyword is used at the beginning of a source file( before class ) to import classes or even entire java packages.

Public: It is used to declare methods and fields public.

Static: It is used to declare a field, method or inner class as a class field.

Void: It is used to declare a method that does not return any value.

Double: It is used to declare a double field. A double is primitive data type that is capable of storing decimal number.

Int: Int is a primitive data type that is capable of storing a 32-bit whole number.

If: It is used to create an if statement. The if statement test a boolean expression.

Case: This keyword is used to create individual individual cases in a switch statement.

Switch: The switch keyword is used in conjunction with the case and default keywords. It evaluates a variable and matches it to a specific case.

Else: It is used in conjunction with the if keyword to create an if-else statement.

While: It is used to create a while and do-while loop, which tests a boolean expression and keeps running the same block of code until the boolean expression returns false.

Private: It is used to declare methods and fields private.

Boolean: A boolean is a primitive data type that can store only two values: true or false.

Break: Break is used to immediately breakout of the loop or switch statement it is inside of.

Abstract: It is used to declare a class or method abstract.

Assert: This keyword was added in J2SE 1.4 and is used primarily in the debugging phase of programming.

Byte: This keyword is a primitive data type that is capable of storing 8-bit whole number.

Float: It is a primitive data type that is capable of storing a 32-bit floating point number ie, decimal number.

For: It is used to create a for loop. There are three parts of a for loop- initialization, boolean expression and incrementation.

 Remove Loading Gear :

If you are blogging in Blogger and using its Dynamic theme then you may experience that it always shows a Loading Gear whenever it gets load. It is sometimes disturbing. So if you want to eradicate this problem then just follow the below steps-

1. At first go to the Dashboard of your Blog and and then in the left side you will find an option saying Template.

2. Now click on Template and there you will find a Customize option beside Edit HTML button.

3. Click on Customize and after clicking on that in the left side you will find an option saying Advanced, click on that option.

4. Now you should get an option saying Add CSS, click on that.

5. Now an empty box should appear in the right side. In this box copy paste the following codes and Press enter button after the last character of the last line ie, } .
–Now, Apply it to your Blog.

.ss,.blogger-gear{ display: none; }

Remove Dynamic View Options :

 >>>>  If you want to remove Dynamic Blogger view options like this  >>>>

In the same way as I have shown in the removal of loading gear part, at first go to the Dashboard of your Blog and and then in the left side you will find an option saying Template. Now click on Template and there you will find a Customize option beside Edit HTML button. Click on Customize and after clicking on that in the left side you will find an option saying Advanced, click on that. Now you should get an option saying Add CSS, click on that. Now an empty box should appear in the right side. In this box copy paste the following codes and Press enter button after the last character of the last line ie, } .
–Now, Apply it to your Blog.

#views{ display: none !important; } #header #pages, #header #pages:before{ border-left: 0px !important; }