Home Sql Mysql-example Mysql Where Statement
Questions:Ask|Latest


 
 

Share on Google+Share on Google+

Mysql Where Statement

Advertisement
Mysql Where Statement is useful when we want to return the records on the basis of specified condition in Where Clause.

Mysql Where Statement

     

Mysql Where Statement is useful when we want to return the records on the basis of specified condition in Where Clause. The Where Clause restricts the records and select only those records specified in it.

Understand with Example

The Tutorial illustrate an example from 'Mysql Where Statement'. To understand and grasp this example we create a table 'employee' whose fieldnames and datatypes are specified. 

Create table "employee" :

CREATE TABLE `employee` ( 
`username` varchar(200) default NULL, 
`emp_name` varchar(200) default NULL 

Describe the table "employee":

The Describe table is used to describe the fieldnames, datatypes, Null,  Key, Default etc of the table employee.

mysql> describe employee;
+----------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+--------------+------+-----+---------+-------+
| username | varchar(200) | YES | | | |
| emp_name | varchar(200) | YES | | | |
+----------+--------------+------+-----+---------+-------+
2 rows in set (0.00 sec)

Query to insert the record in table "employee":

The Query insert into is used to add the records or rows to the table 'employee'.

insert into employee (username,emp_name) values('vin','Vineet Bansal')
insert into employee (username,emp_name) values('srbh','Saurabh');;

Query to display the record of table "employee":

The Query select helps you to return the records from table 'employee'.

mysql> select * from employee;
+----------+---------------+
| username | emp_name |
+----------+---------------+
| srbh | Saurabh |
| vin | Vineet Bansal |
+----------+---------------+
2 rows in set (0.00 sec)

Query to display the record of table "employee"  using  "where"  statement:

The Query  Where Clause returns only those records from table specified in Where Clause. In this example the table returns only those records   whose username is 'srbh' as specified in Where Clause.

mysql> select * from employee where username='srbh';
+----------+----------+
| username | emp_name |
+----------+----------+
| srbh | Saurabh |
+----------+----------+
1 row in set (0.02 sec)
Advertisement

Liked it!  Share this Tutorial


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: January 20, 2009

Ask Questions?    Discuss: Mysql Where Statement  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments
DMCA.com