Selecting Data with SQL IN SQL IN allows us to select values which match any one of a list of values. The use of SQL IN is as follows:
SELECT column_list
FROM table_name
WHERE column IN ("list_item1","list_item2".)The column in WHERE clause
Posted : Sep/24/2009 By:
nikhil Category:
MySQL Total Views :
96 Vote Up:
0 Vote Down:
0 Creating and Removing Index » MySQL Tutorial » Creating and Removing Index Creating and Removing Index
Creating Indexes
Database indexes help to speed the retrieval of data from MySQL database server faster. When retrieving the data, MySQL first c
Posted : Sep/24/2009 By:
nikhil Category:
MySQL Total Views :
77 Vote Up:
0 Vote Down:
0 Working with Tables - Part I Creating Tables
To create table we use the CREATE TABLE statement. The usual form of this statement is:
CREATE TABLE [IF NOT EXISTS] table_name(
column_list
) type=table_type
Posted : Sep/24/2009 By:
nikhil Category:
MySQL Total Views :
78 Vote Up:
0 Vote Down:
0 Creating and Using a Database Once you know how to enter commands, you are ready to access a database.
Suppose that you have several pets in your home (your menagerie) and you would like to keep track of various types of information about them. You
Posted : Sep/24/2009 By:
nikhil Category:
MySQL Total Views :
93 Vote Up:
0 Vote Down:
0