Results 1 to 7 of 7

Thread: Syntax to insert data in the table

  1. #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?


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


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

  5. #4

    Re: Syntax to insert data in the table

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


  6. #5
    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

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


  8. #7
    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');


  9.  Sponsored Ads
    Ad


     
  10. Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •  
    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.
    Interact