In this section you will find the SQL examples using MySQL Database Server.
These MySQL example SQL's tutorial is very useful in learning the concept of
SQL. You will learn how to use the different types of SQL Statements for
managing you data. Few examples are also developed using the PHP scripting
tool. You can use PHP to connect to MySQL Database and fetch the data stored in
MySQL is one of the most used Databse server for storing the data. Aapache,
PHP and MySQL is the best combination for creating the dynamic web applications
Wordpress is one of the most used blogging and content management tool used
for running the website is also based on PHP and MySQL.
Here are the example of MySQL which explains you the SQL concepts in depth:
Mysql Switch CASE Mysql Switch Case perform one of several different actions based on several
Mysql Check Mysql Check is used to check the existence of table in the database.
Mysql Length Function The Tutorial already illustrate you an example to find the length
of the String. Now this section of tutorial helps you to find the
Length Function in Mysql.
Mysql Like Operator Mysql Like is used to retrieve the records on the basis of pattern matching
in select query. The like comparison Operator in SQL allows you to match any
single character or any arbitrary character enclosed in a single quotes.
Mysql Like Command Mysql Like Command is used for retrieving the records from a table on the
basis of pattern matching.
Mysql Like Operator Mysql Like Operator is used to compare a part of string using the % wild card
Mysql like syntax Mysql Like is used to retrieve the records on the basis of pattern matching
in select query.
Mysql Limit Mysql Limit is used to limit your query result to those which fall within a
Mysql List Mysql List elaborate you an Query for listing databases, tables,
Procedure, columns, usernames and its password.
Mysql List Tables The Tutorial illustrate an example from 'Mysql List Tables'. To
understand this example we use show tables query that return the list of
tables in database name 'Table_in_girish'.
Mysql Multiplication Columns Mysql Multiplication Columns is used to provide the column that is the
outcome product of all the records in the respective columns of a table.
Mysql Multiply Mysql Multiply is used to define the product of any two or more numbers in a
MySQL random In MySQL we can get the random records by using the method
RAND() of MySQL. There are two versions of RAND() function : first RAND()
and second is RAND(X).
MySQL random number You may fall in the condition when you want to create random number for your
program to process some logic, here is the solution for such condition.
MySQL random order In MySQL we can get the rows records in a random order by using the method
RAND() of MySQL. In the following example, we will describe how you can
use RAND() function to fetch records from the database.
MySQL range May times the programmer needs to find out some specific data which lies in
the particular range of values but there is not any predefined function in MySQL.
MySQL rank Many times there is a need to rank the records according to some specific
field values but there is not any specific method provided in the MySQL
to rank the records.
ROUND() function of MySQL rounds the number to the upwards or
downwards to the nearest whole number or to the specified decimal places. For
getting the whole rounded number ROUND() function uses "round
Mysql where Mysql Where returns only those records from table which are
specified in the WHERE Clause.
Mysql As Mysql As is used to specify the another name for the existing column and
table name.The Alias Name is helpful for database that makes it easy to write
MySQL by In the following example you will see the how to use the MySQL by.
Here, we will use GROUP BY clause. It displays the data in the group of employee
MySQL Case If you want to implement a complex conditional construction
then you can use MySQL case statement. It performs the work as programming type.
MySQL Cast Here, you will learn about the MySQL CAST() function.
MySQL Commands In this section, we are going to read about the mysql commands. Each
statement is sent to the server for the execution by MySQL. MySQL provides lots
MySQL Case In Where Clause If you want to implement a complex conditional
construction then you can use MySQL case statement. It performs the work as
MySQL Case Sensitive Here we are going to read about the MySQL case sensitivity. The case sensitive
is a term that tells you to check lettercase either upper case or lower
MySQL Convert This section describes about the MySQL convert. It provides a way for converting
the data of one type to another type.
MySQL Count This example illustrates how to use count() in MySQL database.