PDA

View Full Version : insert data

alaios
10-21-2002, 08:24 PM
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?
Jeewhizz
10-22-2002, 12:40 AM
Date has to be in the format YYYYMMDD or YYYY-MM-DD

so you will need

19880910 as your insert :)

Jee
alaios
10-22-2002, 05:06 PM
thx for help...but this does not work....what are the differneces between mysql and oracle sql
I am using oracle 8i personal edition?
Spookster
10-22-2002, 05:32 PM
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?
alaios
10-22-2002, 07:55 PM
do u know where i can fine a forum for my sql?
Spookster
10-22-2002, 07:57 PM
is that a trick question? this is a forum for mysql.
alaios
10-22-2002, 08:06 PM
i mean oracle sql//////:o :o :o
Spookster
10-22-2002, 09:32 PM
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?