I've just upgraded MySQL server to 8.0, which means I've also imported my databases recently and installed the newest version of Heidi. When I click on the data tab for a view, the columns are displaying in alphabetical order rather than by the ordinal number of the column. The data stays in the same order, so the results look crazy (commas in a varchar column). When I do a select from, the results look fine. What could be causing this? I am attaching the scrambled view, the results of a select, and the show columns output.
Ads were blocked by your webbrowser.
This is not a problem, but keep in mind that developing HeidiSQL, user support and hosting takes time and money.
You may want to send a donation instead.
Scrambled columns in views
ansgar posted 1 year ago
Could you please post the CREATE TABLE code in a new issue on the bugtracker? I never saw that issue, so I have to dive deeper into it. Only I need a ticket.
Please login to leave a reply, or register at first.