[Ritesh]

Our developers has confirmed it as bug.

It happens only when the Source Columna and the Reference Column have different name.

We will be releasing SQLyog 3.02 withing 48 hrs which will have this bug fixed. Sorry for the inconvenience caused and thanks for your patience.

[Ritesh]

Quote:

Insert/Update Date screen does not allow you to edit custom queries, but only the full query result set for a particular table. For example, if I wanted to edit filtered down subset of a table, as opposed to the entire shebang.

This is possible in SQLyog 3.0. To do this just execute the query by pressing F8 instead of F5 or Shift+F5. You can find this option in the Execute Query(s) dropdown in the toolbar.

[Ritesh]

We have removed the Flood Control option. Now you can post as many suggestions as you want.

[Ritesh]

The MySQL help docs will be a good place.

[Ritesh]

Bothe the mysql client and SQLyog uses the same way i.e. the MySQL C API to connect to host.

Dont know about other products.

[Ritesh]

Quote:

Besides typing in raw SQL, is there a way to create a table with enum fields in the GUI-based table creation utility? If so how?

Start the create table dialog…( press Insert after selecting a DB in the object browser or select Create Table In The Database… in DB menu )

In the DATATYPE column table select ENUM and insert the ENUM values in LENGTH column.

For eg if you want to create a field month with value January, February etc. then select enum in the DATATYPE column and give the following value in Length column –

'January','February','March','April','May','June','July' etc.

Hope it helps.

[Ritesh]

Our development team has confirmed the bug.

We will be releasing a fix soon which will have the bug fixed.

[Ritesh]

Quote:

Table with mixed fields, more than one of which is of type TEXT.

The development team has confirmed the bug.

We will be releasing a fix to it soon. In the meantime could you please send us your table stucture and what you are doing so that we can positively reproduce the error.

You can mail them to [email protected]

[Ritesh]

Even if you write RAW SQL to create a table of InnoDB type, are you are able to do that?

After creating the table try changing its table type to InnoDB using Change Table Type To option from the table menu.

Hope it helps.

[Ritesh]

Thanks. I have sent it to my development team.

[Ritesh]

SQLyog logs all the query it executes in the History Tab. Please check the query which SQLyog generates in the History tab for creating the table.

We checked your problem on our side and we are able to create InnoDB table without any fuss.

In the Create Table dialog…there will be a Other Properties… button. Please click on it and in the Advanced Table Properties dialog select InnoDB table type.

Hope it helps.

[Ritesh]

When are you getting the error?

Even if you dont have access to any database, SQLyog will show you the all the database object.

Quote:

error 1045 : access denied for user '[email protected]' (Using password : YES). So I can't see the database structure, etc…

What are you giving for Host Address and UserName in the connection details dialog box?

[Ritesh]

Thanks for the suggestion

[Ritesh]

I think you are not allowed to access your MySQL server from a remote host. Contact your network administrator. You can also try the following:

– Try pinging to the IP / Host.

– If ping is OK try telnet to that IP & Port

[Ritesh]

Hi,

The omission of this “feature” is intentional.

SQLyog is optimized for remote connections and it is the tool of choice if you want to access MySql databases hosted with your ISP.

We dont want to generate unnecesary traffic everytime a user clicks on a table. If you want to insert / update data you need to do go thru an extra step.

In fact, other MySQL front-ends that bring up the update window “very quickly” even if the the result set if huge use mysql_use_result() which requires you to retrieve *all* the rows even if you determine in mid-retrieval that you've found the information you were looking for. Therefore if you are have not scrolled till the last row of the table, the entire table remains *locked*. Other connections cannot update the table.

This is unacceptable for production servers. If you want to perform insert / updates on a table, the best way is to write a query which filters the rows that you want to update and press F8 to perform updates on the resultset.

Hope this helps

[Author]

Posts