Monthly Archives: January 2016

Tips to Pick the Best Domain for Your Blog

Hi all,
In this article provide some useful information related to tips to pick the best domain for your blog. Selecting the right domain name for your blog is an essential step to success your blog.


Keywords is an important role in a domain. In the domain name, the keyword described your site. The best domain name describes exactly what the site is about.
So, the keyword is an important factor in domain name. Good keywords in the domain also assist in ranking higher in the search engine. It’s very important for visitors get an idea about your blog.


Make sure your domain is catchy and easy to memorize so the user can come back to your website and not forget about it. So keep in mind about branding while registering the domain name.


Your domain name is a huge part of your organization’s identity – so make sure that it is as unique as your organization.

Easy to remember

The domain name should easy to remember. Choosing the domain name based on blog content. The domain name should be easy to spell, pronounce, remember and type.

A domain name should be short with less than 10 characters. It also helps the “Easy to remember” point when the name is short.

Domain Extension

Try to get the “.com” Top Level Domain (TLD) extension as it is the most popular. It is also the most widely accepted domain name extension. When people think about an website, their mind automatically pictures “” as the address. You can also use the “.net” and “.org” extensions if you cannot find a “.com” extension.

Make it Easy to Type

If a domain name requires considerable attention to type correctly, due to spelling, length or the use of un-memorable words or sounds, you’ve lost a good portion of your branding and marketing value.

Keep the Name as Short as Possible

Short names are easy to type and easy to remember (see the previous two rules). They also allow for more characters in the URL in the SERPs and a better fit on social networks, print media, and every form of offline marketing (including the essential Word-of-Mouth).

Think Local

If your business is local then think about adding your region, city or state in the domain name.

If anyone has doubts on this topic then please do let me know by leaving comments or send me an email.

How to copy one table data into another table using Mysql Query?

Hi friends,
Today I’m going to tell you “how to copy table values from one database table values to another database table using MYSQL.” We can easly copy the one table values to another table in same database. This is easy and this purpose is used in allproject.

But in a big company keep the duplicate of existing database fully. But nobody try to copy the specified column or full column from the corresponding table in database to another database table in MYSQL. This concept is very easy and more useful.

You can copy data within a table and between tables with same database. And also you can copy the table data between different database in mysql. Here, can copy full data to another table or to copy specified field or column.


INSERT INTO databasename2.tablename(fieldname) select fieldname from databasename1.tablename

Step1:Create database and table

First create orginal database name as custa1. And also create table name orginal_table with id,table_name and sub_name. After creating table we insert the values to orginal table.

The orginal_table in custa1 is look like this:


Step2: Create second database and table

In second step: first create database “cusat2” and create table “table_copy” with id and name field for copying.

The table_copy in cusat2 is look like this:


Step3:Copy the first databse tablevalues to second database table.

Now we copy data of orginal_table from database custa1 to table_copy in cusat2 database. The mysql query is:

INSERT INTO cusat2.table_copy(name) select table_name from custa1.orginal_table


We can copy the full table details(full field) or we can copy specified fieldname from orginal database table to another database table.

If anyone has doubts on this topic then please do let me know by leaving comments or send me an email.

SQL Query Interview Questions with Answers

Hi all,
Today I share one important topic related to SQL. SQL query is very important. This article mainly focus sql query related to interview questions and answer.

In this article, I am giving some examples of SQL queries with answer which is frequently asked when you go for a programming interview.

The main advantages of sql queries are: retrieve large amount of data from database very fast, the high speed is positive advantage in SQL queries.

One disadvantage are difficulty to interface and SQL database is more complex.

  1. What is primary key ?

    Answer:A primary key is a special relational database table column designated to uniquely identify all table records.
    The main features of primary key’s are:

    • It must contain a unique value for each row of data.
    • It cannot contain null values.

  2. What is a Foreign Key ?

    Answer:A foreign key is a single column or a multiple columns defined to have values that can be mapped to a primary key in another table.
    A FOREIGN KEY in one table points to a PRIMARY KEY in another table.

  3. SQL query to fetch all the employee Details from EmployeeDetails table

    Answer:Fetch all details from EmployeeDetails table:

    select * from EmployeeDetails;

    EmployeeID Salary
    1 4000
    2 8000
    3 8000
    4 14000
  4. SQL query to fetch EmployeeID from EmployeeDetails table:

    Answer:List all EmployeeID from EmployeeDetails table

    Select EmployeeID from EmployeeDetails;

  5. SQL query to fetch unique Salary from EmployeeDetails table

    Answer:For display unique values from table using DISTINCT keyword in sql query.

    select distinct Salary from EmployeeDetails

  6. Select first 3 characters of Salary from EmployeeDetails table

    Answer:Oracle Equivalent of SQL Server SUBSTRING is SUBSTR, Query.

    select substr(Salary,0,3) from EmployeeDetails;

  7. SQL Query to find second highest salary of EmployeeDetails:

    Answer: There are many ways to find second highest salary of EmployeeDetails in SQL, you can either use SQL Join or Subquery to solve this problem.
    Here is SQL query using Subquery:

    SELECT MAX(Salary) FROM EmployeeDetails WHERE Salary NOT IN (SELECT MAX(Salary) FROM EmployeeDetails);

    Running the SQL above would return us 8500, which is of course the 2nd highest salary in the EmployeeDetails table.
    Code Explanation:The SQL above, first find the highest salary values from the EmployeeDetails table using “Select MAX(Ssalary) from EmployeeDetails”. Then, adding the “WHERE Salary NOT IN” in front basically creates a new set of Salary values that does not include the highest Salary value. For instance, if the highest Salary in the EmployeeDetails table is 14000 then that value will be excluded from the results using the “NOT IN” operator, and all values except for 14000 will be retained in the results.

  8. SQL query to find the lowest salary from the table EmployeeDetails

    Answer:Running the SQL below would return us 4000, which is of course the 2nd highest salary in the EmployeeDetails table

    Select MIN(Salary) from EmployeeDetails;

  9. SQL Query to display the current date.

    Answer:SQL inbuilt function GetDate() display current date.

    SELECT GetDate();

  10. SQL Query to check whether date passed to Query is the date of given format or not.

    Answer:SQL has IsDate() function which is used to check passed value is a date or not of specified format, it returns 1(true) or 0(false) accordingly.

    SELECT ISDATE(‘1/08/13’) AS “MM/DD/YY”;

    It will return 0 because passed date is not in correct format.

  11. SQL Query to display the EmployeeID whose Salary is between 8000 to 14000.

    Answer:This SQL query is tricky, but you can use BETWEEN clause to get all records whose salary fall between two salary.

    SELECT EmployeeID FROM EmployeeDetails WHERE Salary BETWEEN ‘8000’ AND ‘14000’;

  12. SQL Query to find an EmployeeID whose Salary is equal or greater than 10000 from EmployeeDetails table.

    SELECT EmployeeID FROM EmployeeDetails WHERE Salary>=10000;

  13. SQL query to select dates between two dates (2011/02/25′ to ‘2011/02/27)

    select Date from exam where Date between ‘2011/02/25’ and ‘2011/02/27’;


    select Date from exam where Date >= ‘2011/02/25’ and Date <= '2011/02/27'

If anyone has doubts on this topic then please do let me know by leaving comments or send me an email.

mysql_close() function:PHP

To close an open MySQl connection in php, the mysql_close()helps to perform this function. The mysql_close() function is not the necessary part in our program. In non-persistent open links are automatically closed at the end of the script’s execution.




mysql_close($con); if ($con) { echo "
disconnected successfully at:".date("d/m/y : H:i:s", time()) ; } ?>

Output :

connected successfully at:26/07/10 : 09:31:14
disconnected successfully at:26/07/10 : 09:31:15

If anyone has doubts on this topic then please do let me know by leaving comments or send me an email.

Difference between HTTP and HTTPS

Hi Guys,
Today we are discuss one important topic related to HTTP and HTTPS. Everyone heard this HTTP and HTTPS. Most address begins with http, means hyper text transfer protocol. Call address on address bar then the address http automatically redirect to https, nobody knows what happens there.
HTTPS is secure protocol, our address bar http change to https then we can say that our information is safe. The HTTP and HTTPS protocol helps to communicate with web sites.

Hypertext Transfer Protocol (HTTP)is used in networking. It is used by the world wide web. HTTP is called a stateless protocol, because each command is executed independently.

Secured Hypertext Transfer Protocol(HTTPS) is the combination of two different protocol(Hypertext Transfer Protocol (HTTPS) and SSL/TLS protocol). It is the secure way to access the protocol.

HTTP(Hypertext Transfer Protocol) HTTPS(Secured Hypertext Transfer Protocol)
Is the mode of communication used in internet browsers where data transfers to and fro user and server. Is a secured mode of communication where data transfer happens using encryption.
URL begins with http://
URL begins with https://
It uses port 80 for communication It uses port 443 for communication
Unsecured Secured
It does not follow any authentication during its communication. It uses secured way to communicate.
Operates at Application Layer Operates at Transport Layer
No encryption Encryption is present
No certificates required Certificates required
HTTP performs its operation in application layer. HTTPS performs its operation in transport layer.
Performance wise it is bit faster. It becomes slower due to the encryption method used in SSL.
It has the ability to cache. Hence it is user friendly It does not allow to cache thus many websites avoid using it

If anyone has doubts on this topic then please do let me know by leaving comments or send me an email.