Inserting values into a table with two timestamp fields

[praveena mani]

how to insert values in this table for these two timestamps???

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_OF_DETAILS TIMESTAMP DEFAULT 0,
    MODIFIED_DATE timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    );

[pbmods]

Heya, Praveena. Welcome to TSDN!

Please use CODE tags when posting source code:

[CODE=MySQL]
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:

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_TIMESTAMP
        )
 

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..