[sathish]

Hello,

If your table that does not have a primary key then SQLyog uses data from ALL columns of the edited row to construct the WHERE clause. This is done to minimize the chances of duplicate updates.

Please read this FAQ:

http://webyog.com/faq/28_70_en.html

You can turn ON this warning setting by checking Tools->Preferences->Others->Prompt if multiple rows are getting updated.

Regards,

Sathish

[sathish]

Hello Mitch,

I have added this in our issue tracker here: http://code.google.com/p/sqlyog/issues/detail?id=1713 We will schedule this according to our priority.

Thanks and Regards,

Sathish.

[sathish]

Hello,

Its the MySQL server that modifies the letter case. The behavior can be controlled by setting lower_case_table_names.

Please execute SHOW VARIABLES LIKE 'lower_case_table_names'; and compare the result with the documentation given here.

http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html

Refer http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_lower_case_table_names to see how you can set this variable to match your requirements.

However it is advised to use this variable set to 1 in case insensitive file systems and use only lowercase to name your database and tables for maximum portability. In short, MySQL recommends the use of delimiter_separated naming convention over CamelCase naming convention.

Regards,

Sathish

[sathish]

Hello,

We already have this request here in our issue tracker : http://code.google.com/p/sqlyog/issues/detail?id=1435 We will schedule this according to our priority.

Thanks and Regards,

Sathish.

[sathish]

Hello,

We already have this request here in our issue tracker : http://code.google.com/p/sqlyog/issues/detail?id=1664 We will schedule this according to our priority.

Thanks and Regards,

Sathish.

[sathish]

Hello,

I have added this in our issue tracker here: http://code.google.com/p/sqlyog/issues/detail?id=1704 We will schedule this according to our priority.

Thanks and Regards,

Sathish.

[sathish]

Hello,

I have added this in our issue tracker here: http://code.google.com/p/sqlyog/issues/detail?id=1700

We will schedule this according to our priority.

Thanks and Regards,

Sathish

[sathish]

Hello,

We have an option- Copy Database To Different Host/DB base.

Select the Database you want to copy and then Right click -> Copy Database to different Host/DB to copy a database (with all or selected items of its table structure as well as the data) to another database (which may be located in another host).

Note: To specify a database on another host as the target database, you must first connect to that host using File -> New Connection (or the corresponding icon).

Thanks and Regards,

Sathish

[sathish]

Hello,

I have added this in our issue tracker here: http://code.google.com/p/sqlyog/issues/detail?id=1676 We will schedule this according to our priority.

Regards,

Sathish.

[sathish]

Hello,

I have added this in our issue tracker here: http://code.google.com/p/sqlyog/issues/detail?id=1675

We will schedule this according to our priority.

Regards,

Sathish

[sathish]

Hello,

The error 1045 is MySQL Server's user authentication error.

The most likely problem why you cannot connect directly is described in our SQLyog FAQ:

http://webyog.com/faq/content/23/18/en/error-no-1045-connection-denied.html

Thank you.

Regards,

Sathish

[sathish]

Hello,

This is an issue with the ODBC text driver. For csv there is no data type associated with the values so the driver has to perform a sampling on the data to identify the data type. This is 25 by default. so If you dont have any “double” value inside that 25 rows it will identify as integer or whatever apporiate. However you can modify this in ODBC configuration wizard in the source. So you have to change the sampling rate manually.

Please follow the steps below to change the sampling rate:

Start-> Run-> ODBC data source administrator-> User DSN-> Select the text driver->Click Configure->Options-> Define Format->Rows to scan- change the format to larger value(say 100)

Please refer the screen shot for more information.

Thanks,

Sathish

[Author]

Posts