Results 1 to 7 of 7

Thread: Syntax to insert data in the table

  1. 04-12-2007 #1
    Geek_Guest
    Guest

    Syntax to insert data in the table

    Question asked by visitor Kishor

    How to insert value in SQL Table?
    I have created a table stime etime both of data type is datetime
    What is syntax of insert the data in the table?

    Reply With Quote Reply With Quote
  2. 04-12-2007 #2
    rohit dwivedi9450
    rohit dwivedi9450 is offline
    Contributing Member
    Join Date
    Mar 2007
    Answers
    34

    Re: Syntax to insert data in the table

    insert into values ('name','address',.....................);
    this is one of syntex

    Reply With Quote Reply With Quote
  3. 05-02-2007 #3
    jainbrijesh
    jainbrijesh is offline
    Moderator
    Join Date
    Sep 2006
    Answers
    920

    Re: Syntax to insert data in the table

    insert into
    4. column's name(column_1, column_2,....) values ('name','address',.....................);

    example:-

    INSERT INTO EMPLOYEE_TBL (EMP_ID, LAST_NAME, FIRST_NAME, MIDDLE_NAME, ADDRESS, CITY, STATE, ZIP, PHONE)

    VALUES ('123456789', 'SMITH', 'JOHN', 'JAY', '12 BEACON CT','INDIANAPOLIS', 'IN', '46222', '3172996868');

    Last edited by jainbrijesh; 05-02-2007 at 01:27 AM.
    Regards,
    Brijesh Jain
    ---------------------------------------------------------
    Connect with me on Skype: jainbrijesh
    Google Plus : jainbrijeshji
    Reply With Quote Reply With Quote
  4. 09-04-2007 #4
    yagnam ramesh babu
    yagnam ramesh babu is offline
    Junior Member
    Join Date
    Feb 2007
    Answers
    6

    Re: Syntax to insert data in the table

    eg:-insert into mca values(&sid,'&sname',&dob);

    Reply With Quote Reply With Quote
  5. 09-07-2007 #5
    N SRIRAM K
    N SRIRAM K is offline
    Contributing Member
    Join Date
    May 2007
    Answers
    45

    Re: Syntax to insert data in the table

    Adding to the above friend's suggestion:

    Use same above they mentioned the syntax. but value must be like '21-Sep-2007'

    Thx
    SRIRAM N
    Hope Everything Good
    Reply With Quote Reply With Quote
  6. 09-11-2007 #6
    yagnam ramesh babu
    yagnam ramesh babu is offline
    Junior Member
    Join Date
    Feb 2007
    Answers
    6

    Re: Syntax to insert data in the table

    as our friend said the date format is must be in like '21-aug-2007' but it depends on the dbmsystem to verify which format is supported type the command




    sysdate



    my friend sriram is it correct?
    please kindly mail me the correct one if it is worng

    Reply With Quote Reply With Quote
  7. 09-18-2007 #7
    raja219
    raja219 is offline
    Junior Member
    Join Date
    Aug 2007
    Answers
    3

    Re: Syntax to insert data in the table

    Insert into table values('18-sep-2007','18-sep-2007');

    Reply With Quote Reply With Quote
    8. « Previous Thread | Next Thread »

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •  

    Forum Rules

    About us
    Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
    GeekInterview
    Interact