MYSQL primary key issue on localhost

Hi Folks, I hope you are all doing well.

I need some help.

I installed MySQL, php and the apache webserver.

I am using the myPhp Admin to create the database for the ijdb in the book Novice to Ninja.

I am using the GUI to create the table and its columns.

When I go to structure, the interface shows the 3 columns, but it shows the jokeDate as the primary key.

When I go to the SQL window and run the describe command it shows the 3 columns, in this view, it does show the ID as the primary key.

I took a couple of screen shots, I am going to see if I can attach them for every one to view.

Thanks for the help.

Jorge Muralles
info@locopro.com

Null = No, Default = NULL
vs.
Null = No, Default = None

??

Thank you very much.

When the box for NULL is checkek, it allows null values.

Correct?

Thank you

I don’t know what you mean by “the null checkbox”

If you mean the checkbox to the left of each row under the Structure tab, try checking the one next to id and clicking primary.

Hi there, I hope you are well.

Did you get a chance to see the document I attached to the original message?

The options looked good for the columns.

The ID is an INT, not null, auto increment and is listed as the primary key.

Actually it shows as the primary key when I run the describe command.

It does not show as the primary key when I use the myPHP admin area.

Take a look at the attachment, let me know what you think.