Need assistance with "ORA-00904: invalid identifier"

Hello all,

I'm working with MySQL DML.
I'm trying to create this table with a primary key and has worked with the previous 2 tables.
Here is my first attempt with date INT

[To see links please register here]

Here is my second attempt with date VARCHAR2(*)

[To see links please register here]

You can see, "Date" doesn't wanna work for me. @Mothered

Thanks,
- Mimi

I assume you wish to store the date value In the form of YYYY-MM-DD, so replace the INT & VARCHAR datatypes with the DATEdatatype. If you're using a FOREIGN KEY In the child table, make sure that also has the same datatype (and column name) as the PRIMARY KEY In the parent table.

If It's not relative to the above, create the table by adding the PRIMARY KEY like this (select whatever you wish as the PRIMARY KEY):

Hidden Content

You must

[To see links please register here]

or

[To see links please register here]

to view this content.