[navyashree.r]

AlanT wrote on Apr 21 2009, 11:17 PM:

Please see my attached script which was failed when I did a 'Restore'.

Hi,

Please confirm whether have you edited manually the SQL dump which u have attached.

It has only Insert statement but not the CREATE TABLE Structure for “LOCATION” table. So, please attach fresh dump using Tools –> Backup as SQL dump which helps to verify at our end.

Thank You in advance.

Regards,

Navya

[navyashree.r]

navyashree.r wrote on Apr 21 2009, 02:20 PM:

There is no ErrorMsg that the content is cutted or something else.

Regarding 'Error message' we will discuss regarding this.

Thank You.

Regards,

Navya

[navyashree.r]

Hi Marcus,

We are sending query to the MySQL server and just retrieving the result from it. So, it doesn't show any error message of truncation of data if the field length is less than field value.

For Example,

CREATE TABLE `test_city` (

`ID` INT(11) NOT NULL AUTO_INCREMENT,

`Name` CHAR(3) NOT NULL DEFAULT '',

PRIMARY KEY (`ID`)

) ENGINE=MYISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 ;

So, in Table data when we add data which is of more length than specified i.e. 'AMSTERDAM' in 2nd column it just truncates to three characters 'AMS' when we refresh the table. We retrieved data from server.

Regards,

Navya

[navyashree.r]

AlanT wrote on Apr 20 2009, 11:28 PM:

I generated the script with 'Structure and Data', when I import the script in my home pc, it got the error because the 'primay' table 'Employee' script is before the lookup table 'Position'. That is it cannot insert the records into 'Employee' table before the 'Position', it is due to the Foreign key constraint.

So I need to place the script generating the 'Position' and the insert data script first.

Hi AlanT,

We should check the option SET FK_CHECKS = 0 while exporting if Foreign key is present. This avoids an error when importing or restoring the SQL dump. See image “sqldump.JPG”.

Have you checked this option please make sure?

Quote:

In addition, I noticed the script generated was in alphabetical order according to the table names.

While exporting we are not checking whether its lookup table or primary table. We add the statements to script in the order the MySQL returns result for “show full tables”.

Regards,

Navya

[navyashree.r]

AlanT wrote on Apr 19 2009, 07:25 AM:

I would like to define a table field as enum with values 'One', 'Two' and 'Three'. How do I define these 3 values?

Hi,

You can create table through GUI i.e Table menu –> Create Table,

1. Type the fieldname and select datatype.

2. In Length field type 'one','two','three' and save it.

Another way is to Execute SQL statement from editor. The following is the structure to define a table field as enum with values 'One', 'Two' and 'Three',

CREATE TABLE `film` (

`film_id` SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,

`title` VARCHAR(255) NOT NULL DEFAULT '',

`rating` ENUM('One','Two','Three') DEFAULT 'Three',

PRIMARY KEY (`film_id`)

) ENGINE=INNODB AUTO_INCREMENT=1001 DEFAULT CHARSET=utf8

In future we have plans to define Enum values from GUI where the priority is set High.

Thank You.

Regards,

Navya

[navyashree.r]

Saulo Benigno wrote on Apr 15 2009, 01:21 AM:

Using a counter would be really nice. I think that's what MSSQL do.

There's a request already? I didn't saw it on the forum, sorry.

Hi,

The issue is already in our tracker,

http://code.google.com/p/sqlyog/issues/detail?id=821

Regards,

Navya

[navyashree.r]

SQLyog issue. So, moved to SQLyog Bugs/Features section. Please post in correct thread. Thank You.

Regards,

Navya

[navyashree.r]

navyashree.r wrote on Apr 9 2009, 06:15 AM:

When trying to add a column in an existing table in SQLyog v6.55, after I select 'Alter table' (F6), the error message in the title appears:

Could not read data for the table!

Hi,

We tried with your case in 6.55 and also 8.05. Its working fine for us. So, please tell us the exact case to reproduce at our end.

1. Please attach the structure of table which is throwing this error.

2. And also the MySQL version.

Regards,

Navya

[navyashree.r]

Hi,

Thank You for reporting. We will look into the issue.

Regards,

Navya

[navyashree.r]

Hi,

Issue is confirmed and added in our issue tracker,

http://code.google.com/p/sqlyog/issues/detail?id=1035

Thanking you.

Regards,

Navya

[navyashree.r]

Hi,

Issue is added in the list,

http://code.google.com/p/sqlyog/issues/detail?id=1034

Thank You.

Regards,

Navya

[navyashree.r]

Hi Silentstar,

This issue was already known and fixed in 8.04 which was released yesterday. See our blog,

http://www.webyog.com/blog/

And also you can download the latest version 8.04 and can see the bug fix,

http://webyog.com/en/downloads.php

Please let us know the status here. Thank You.

Regards,

Navya

[navyashree.r]

Hi,

Thank You for your interest. 1st issue already in our list,

http://code.google.com/p/sqlyog/issues/detail?id=295

We will discuss regarding the 2nd and 3rd requests.

Regards,

Navya

[navyashree.r]

Hi,

Yes, you can use SQLyog on both PC as long as if you are the sole user.

Regards,

Navya

[navyashree.r]

Hi,

We reorganized our SQLyog with new icons for better GUI look and appearance in 8.0. Here, we arranged the toolbar and removed the Add user, Table diagnostics, Flush and other icons. So, we are waiting for our user suggestions and few users requested this “Add user” back.

This will be discussed with our team for reconsideration. Thank you for your suggestion.

Regards,

Navya

[Author]

Posts