how to insert the data [message #36515] |
Sun, 02 December 2001 13:44 |
Eli
Messages: 3 Registered: December 2001
|
Junior Member |
|
|
I already have the table. Right now, I have a problem how to insert the data to the table.
the data is like this :
sectionno=12001, courseno=ITSE1345, day=M, time=5:30PM, hours=4.5
the statement would be like this :
values ('12001','ITSE1345,.......
I don't know how to continue to the "day"
any idea for this?
----------------------------------------------------------------------
|
|
|
Re: how to insert the data [message #36528 is a reply to message #36515] |
Mon, 03 December 2001 04:48 |
Suresh Vemulapalli
Messages: 624 Registered: August 2000
|
Senior Member |
|
|
write insert statement according to datatypes , not looking at data.
insert into table_name values('12001','ITSE','M','5:30PM',4.5);
----------------------------------------------------------------------
|
|
|
|