Need assistance with "ORA-00904: invalid identifier"

Need assistance with "ORA-00904: invalid identifier" - Printable Version

+- Sinisterly (https://sinister.ly)
+-- Forum: Design (https://sinister.ly/Forum-Design)
+--- Forum: Tutorials (https://sinister.ly/Forum-Tutorials--78)
+---- Forum: Requests (https://sinister.ly/Forum-Requests--827)
+---- Thread: Need assistance with "ORA-00904: invalid identifier" (/Thread-Need-assistance-with-ORA-00904-invalid-identifier)

Need assistance with "ORA-00904: invalid identifier" - Vultra - 08-12-2018

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
https://gyazo.com/6e60174fad0ddc2b96f666fb2a10f0ad

Here is my second attempt with date VARCHAR2(*)
https://gyazo.com/4de7341cce898739404aca071184f46c

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

Thanks,
- Mimi

RE: Need assistance with "ORA-00904: invalid identifier" - mothered - 08-12-2018

I assume you wish to store the date value In the form of YYYY-MM-DD, so replace the INT & VARCHAR datatypes with the DATE datatype. 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):

Spoiler:

You can add your values to each column thereafter.