The error message is probably wrong. I can't see any mistake where it mentions there is one.
Add a comment
|
1 Answer
The problem looks like you are trying to create a table with two primary keys, one on column ID and one on column TIMESTAMP. A table is only allowed to have one primary key. You can have multiple keys, they can be unique or not unique (referring to the column values), they can index the combined values of multiple columns, etc., but there can ONLY be one (or none) primary key.
If this answers your question, please click on the check to accept. Let's keep up on forum housekeeping. ;-)
-
I solved it afterall by bypassing phpMyAdmin - through adding additional rows. Why couldn't I use 2 PRIMARY KEYS? I did it in the portfolio table before as the incstructions on pset7 had told me. Oct 16, 2015 at 19:40
-
While you may have resolved your problem, I suspect that your description isn't accurate. Adding rows won't affect table construction. A table has to exist before you can add rows of data to it. You may have added columns, but that's something totally different. As for having two primary keys, I'm more likely to believe that you created a single primary key using two or more columns. You can create a single primary key that spans multiple columns. But as long as it works, that's what's important.– Cliff BOct 16, 2015 at 19:54