| Author: KVGaneshBabu 01 Dec 2007 | Member Level: Diamond | Rating:  Points: 2 |
Step by Step Process:
1. Right click on Database -> Click New database
2. Give the name -> click Ok
The same way select that db and go thro table
1. Right click on Table -> Click New Table
2. It will ask a.ColumnName b. FieldName c. Allow Nulls
a. Field as you want
b. DataType (ex. varchar(10),int and so on)
c. Allow nulls (check whether allow null or not)
Give the name -> Click ok
YOu can insert record by using simple insert query
INSERT INTO TableName (slno, empname) values('1','Ganesh')
Regards,
K.V.GaneshBabu
|
| Author: payal 01 Dec 2007 | Member Level: Gold | Rating: Points: 2 |
Creating table:
Create table table_name (column_name1 datatype(size), column_name2 datatype(size),...)
Inserting values:
insert into table_name values(1,2,3...)
|