MySQL – SQL FAQ

1. What is MySql ?

MySQL is very popular relational database Management System on the web. The MySQL has become the world’s most popular open source  Database, because it is free and available on almost all the full  platforms. The MySQL can run on many OS like Unix , window, and Mac OS MySQL is used for the internet applications as it provides good speed and is very secure. MySQL was developed to manage large volumes of data with very high speed to overcome the

2.What is SQL ?

SQL (Structured Query Language) is a specialized language for updating, deleting, and requesting information from databases. A variety of established database products support SQL, including other products from Oracle and Microsoft SQL Server. It serves both industry-level and academic needs and is used on both individual computers and corporate servers. In the progress in database technology SQL based applications have become increasingly affordable for the regular useres. This is due to the introduction of various open-source SQL database solutions such as MySQL, PostgreSQL, Firebird, and many more. SQL is a language designed for store data, but the data stored in an SQL database is dynamic. It can be modified at any time in the use of several very simple commands. SQL Developer supports migrating databases to Oracle.

3. In Whisc default port  on working MySql and SQL ?

We probably know that by default, the SQL Server Database Engine listens on port number 1433 for TCP/IP connections and port 1434 is used for UDP connection. MySql default port number is 3306.

4. What is difference between mysql and sql ?

SQL stands for Structured Query Language. It is a standard language for accessing and manipulating databases. It product of Microsoft.
MySQL is also a database management system, like SQL Server 2003, Informix, Oracle, Postgres etc. MySQL is a RDMS. SQL use all types of RDMB.
SQL is used to manipulate database. It is actually a common language. MySQL like an actual computer application. we must need to download or collect it and install it. MySQL is one of the most popular open source and freely available database management system.
MySQL can be used as the back engine database for several kinds of applications and it is one of the best choice for many web programmers for web-base application, and also we can use in desktop application.

5. Basic query of Mysql and SQL ?

For SQL Basic Query you can visit on http://www.epa.gov/ttn/airs/airsaqs/training/SQL%20Basics.pdf 

Or you can visit on http://msdn.microsoft.com .  For MySql basic Query, you can visit on http://www.artfulsoftware.com/infotree/queries.php

6. How to install Mysql ?

We can install the mysql simply like all application in MS windows. For more detail you can visit on http://www.sitepoint.com/how-to-install-mysql/

7. How can I retrieve data from a database using SQL?

The SELECT command is the most commonly used in SQL. It allows database users to retrieve the specific information they desire from a database. In a moment, we will take a look at a few examples. First, you need to take a brief look at an example database tables here.

Imagine that we are building a database of student for our company. We might want this database to contain contact information, payroll details, job history, supervisor relationships, performance reviews and other information. For this example, we will focus on a single table, called contact_info, which contains contact information for all of our employees.