The output of "select * from film where film_id = 27" note:film_id is a primary key.

I get the NULL entry for all select statements. I can see it since the table is created.

CodePudding user response：

I believe that's just a quirk of MySQL Workbench that lets you insert rows if you click those NULL squares and enter values there. That row doesn't exist in your table.