Does Heidi handle MySQL 5 views. If so, where please?

[expired user #4216]'s profile image [expired user #4216] posted 14 years ago in General Permalink
Hi there

I have a series of master data tables with multi-lingual texts for stuff like description stored in another table with the same key + an extra key field for language.

I plan to create views for stuff like text searches, but I cannot find anything in Heidi to help me to define them.

Please can somebody update me on this.

John
ansgar's profile image ansgar posted 14 years ago Permalink
If you cannot find anything you're likely not using HeidiSQL 4.0 are you? In 4.0, views are displayed in the same context as tables, and also stored procedures and functions. Rightclick anywhere, click "New" > "View" to create a new one, or rightclick a view and click "Edit..." to edit an existing one. The "Data" tab is also available for views.

This is the View editor:
[expired user #4240]'s profile image [expired user #4240] posted 14 years ago Permalink
Hi,

I'm using Heidi x.y Revsion 2656 with mySQL 5 and I cannot edit view with the view editor.

Is this a bug?

Greets

Georg
ansgar's profile image ansgar posted 14 years ago Permalink
What means "cannot edit"?
[expired user #4240]'s profile image [expired user #4240] posted 14 years ago Permalink
If I want to edit an existing view the box with the select statement is empty.
[expired user #4240]'s profile image [expired user #4240] posted 14 years ago Permalink
If I want to edit an existing view the box with the select statement is empty.
ansgar's profile image ansgar posted 14 years ago Permalink
I think you're facing a bug in the server here. See issue #958.

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