Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 8 of 8

Thread: insert data

  1. #1
    Regular Coder
    Join Date
    Aug 2002
    Posts
    433
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Lightbulb insert data

    what i am doing wrong
    INSERT INTO EMP
    VALUES(7512,"andreou","adasasd",7890,"10-NOV-88",

    1000000,NULL,30);

    I am having problem with the date 10-nov-88 ... how i must insert the date?

    I Can combine in the same alter command add and drop?
    I can combine modify and add but i cannot combine the drop ...why?

  • #2
    Regular Coder
    Join Date
    May 2002
    Location
    London, England
    Posts
    369
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Date has to be in the format YYYYMMDD or YYYY-MM-DD

    so you will need

    19880910 as your insert

    Jee
    Jeewhizz - MySQL Moderator
    http://www.sitehq.co.uk
    PHP and MySQL Hosting

  • #3
    Regular Coder
    Join Date
    Aug 2002
    Posts
    433
    Thanks
    3
    Thanked 0 Times in 0 Posts

    thx but....

    thx for help...but this does not work....what are the differneces between mysql and oracle sql
    I am using oracle 8i personal edition?

  • #4
    Supreme Overlord Spookster's Avatar
    Join Date
    May 2002
    Location
    Marion, IA USA
    Posts
    6,273
    Thanks
    4
    Thanked 83 Times in 82 Posts

    Re: thx but....

    Originally posted by alaios
    thx for help...but this does not work....what are the differneces between mysql and oracle sql
    I am using oracle 8i personal edition?
    As far as the SQL goes not a whole lot of differences except that mysql doesn't support all the sql that oracle or other RDBMS's support. Main difference between them would be datatypes. Each DBMS has slight differences in what kind of datatypes it has. DateTime datatype is probably different between the two if I recall correctly. I use oracle db's at work and mysql for my web developing at home. Date fields are the trickiest datatype to work with when working with databases.

    What is your date field set to? Which datatype and what constraints if any have you set on it?
    Spookster
    CodingForums Supreme Overlord
    All Hail Spookster

  • #5
    Regular Coder
    Join Date
    Aug 2002
    Posts
    433
    Thanks
    3
    Thanked 0 Times in 0 Posts

    oracle forum?

    do u know where i can fine a forum for my sql?

  • #6
    Supreme Overlord Spookster's Avatar
    Join Date
    May 2002
    Location
    Marion, IA USA
    Posts
    6,273
    Thanks
    4
    Thanked 83 Times in 82 Posts
    is that a trick question? this is a forum for mysql.
    Spookster
    CodingForums Supreme Overlord
    All Hail Spookster

  • #7
    Regular Coder
    Join Date
    Aug 2002
    Posts
    433
    Thanks
    3
    Thanked 0 Times in 0 Posts

    xaxa sorry

    i mean oracle sql//////

  • #8
    Supreme Overlord Spookster's Avatar
    Join Date
    May 2002
    Location
    Marion, IA USA
    Posts
    6,273
    Thanks
    4
    Thanked 83 Times in 82 Posts
    Well we can answer your question here unless you don't want us to. If not you can do a search on google for oracle forums.


    But in order to help you we would need more information such as the questions i asked earlier which you didn't answer. Also when inserting data into your database the proper way would be to explicitly state which fields such as:

    INSERT INTO EMP (field1, field2, field3, field4, field5, field6, field7, field8) VALUES(7512,"andreou","adasasd",7890,"10-NOV-88",1000000,NULL,30);

    Your date is in the proper default format for oracle so there should not be any problem with it assuming it is set to the date datatype.

    Why are you so sure the date is the problem?
    Spookster
    CodingForums Supreme Overlord
    All Hail Spookster


  •  

    Posting Permissions

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