HeidiSQL Automatically Adding Variables When Clicking on Data Tab

Escondido's profile image Escondido posted 6 years ago in General Permalink

I'm really not sure what's going on with Heidi, but one of my databases is adding additional sorting criteria when it shouldn't. Normally the output per table after clicking on the DATA tab is as follows.

SELECT * FROM 'MYDATABASE'.'MYTABLE' LIMIT 1000;

However, a new database I added is showing the following output.

SELECT * FROM 'NEWDATABASE'.'NEWTABLE' ORDER BY 'SOURCE' ASC, 'BIRTH_YEAR' ASC LIMIT 1000;

It shouldn't be adding the bolded information and I have no idea why it's doing that. The only thing I did differently with this database was adding "Source" as a column and designating a mandatory text field of "ABC"

Am I incorrect that Heidi will not automatically add the custom text to column fields even though I made it a requirement when it's not present in the source file?

Does anybody know why the program is automatically adding more sorting criteria options when displaying the data?

Thanks.

ansgar's profile image ansgar posted 6 years ago Permalink

You most probably clicked the column headers of "source" and "birth_year". You can manage the sorting options by clicking the upper right "Sorting" button on the "Data" tab.

Please login to leave a reply, or register at first.