Re: ERROR: Unknown column in WHERE clause

[Lester Cutchall]

SELECT * FROM `song_entry`


Song_Entry_id Song_id Song_Name Music_Maker_id Genre_id Contest_id Transaction_id Song_Entry_Date
1 2 Better Off Crying Now 1 8 202150 0 2021-12-14 06:00:28
2 1 Sweet Young Delight 1 1 202150 0 2021-12-14 06:00:28
3 3 Big Toe Blues 1 2 202150 0 2021-12-14 06:03:27
4 4 Mad Kharma Blues 1 2 202150 0 2021-12-14 06:03:27


SHOW CREATE TABLE song_entry;

song_entry CREATE TABLE `song_entry` (
 `Song_Entry_id` int(...


In the select query, everything that is there shows up, but in the show create table query, I get that crap.