Inserting values into a table with two timestamp fields

[praveena mani]

how to insert values in this table for these two timestamps???
[code=mysql]
create table s_details(
SELECT_ID INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
TITLE varchar(4) NOT NULL,
FIRST_NAME varchar(20) NOT NULL,
MIDDLE_NAME varchar(20),
LAST_NAME varchar(20) NOT NULL,
DATE_OF_BIRTH date NOT NULL,
NATIONALITY varchar(20) ,
E_MAIL varchar(30) NOT NULL,
DATE_OF_ENTRY_O F_DETAILS TIMESTAMP DEFAULT 0,
MODIFIED_DATE timestamp NOT NULL DEFAULT CURRENT_TIMESTA MP ON UPDATE CURRENT_TIMESTA MP,
);[/code]

[pbmods]

Heya, Praveena. Welcome to TSDN!

Please use CODE tags when posting source code:

[CODE=My SQL]
MySQL code goes here.
[/CODE]

Changed thread title to better describe the problem (did you know that threads whose titles do not follow the Posting Guidelines actually get FEWER responses?).

Are you asking how to issue an INSERT query?

[praveena mani]

yeah,how to insert values for this table?
jus gimme an example to insert values..

[pbmods]

Heya, Praveena.

Well, I'd guess it would work something like this:
[code=mysql]
INSERT
INTO
`s_details`
(
`TITLE`,
`FIRST_NAME`,
`MIDDLE_NAME`,
`LAST_NAME`,
`DATE_OF_BIRTH` ,
`NATIONALITY`,
`E_MAIL`,
`DATE_OF_ENTRY_ OF_DETAILS`
)
VALUES
(
'title',
'first name',
'middle name',
'last name'
'date of birth',
'nationality',
'email',
CURRENT_TIMESTA MP
)
[/code]

You don't need to specify a value for the `SELECT_ID` and `MODIFIED_DATE` fields; they will be automatically set for you.

[praveena mani]

thanx..
it helped me alot..