MySQL Forums
Forum List  »  Triggers

Re: ERROR: Unknown column in WHERE clause
Posted by: Lester Cutchall
Date: January 04, 2022 05:17PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: ERROR: Unknown column in WHERE clause
165
January 04, 2022 05:17PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.