MySQL

MySQL Community

NOTE: This forum is for non-product questions and discussions on the MySQL database platform.
 
Please post Toad-family product questions in their respective product forums.  Thanks!

Community Discussion

chin tan oza
Follow / 24 Feb 2014 at 6:02am / MySQL

How to create local table .. like we have convert to local table option...

Expand content
Hi , Is there any way i can copy tables from Database( I only have read access) and convert it to local table?? why i need this... because i am not allowed to use join functions in queries as tables...

Hi ,

Is there any way i can copy tables from Database( I only have read access) and convert it to local table??

why i need this... because i am not allowed to use join functions in queries  as tables are large. hence i want to save some of database tables to local table and then i can define relationships and use join function.

Please help.

Regards,

Chintan Oza

290 0 / Create an account to join the discussion.
StickleFish
Follow / 14 Jun 2013 at 10:12pm / MySQL
Latest post by on 28 Jun 2013 at 1:30pm

Where and how do we report bugs or other issues with Toad for MySQL...

Expand content
Just ran into an issue with Toad for MySQL and enhanced functionalities with MySQL 5.6.x, namely MySQL 5.6 support for fractional seconds. Just wondering who/where/how to report these issues other than...

Just ran into an issue with Toad for MySQL and enhanced functionalities with MySQL 5.6.x, namely MySQL 5.6 support for fractional seconds.  Just wondering who/where/how to report these issues other than spewing them around the forums and the wiki's?

Answered 2213 1 / Create an account to join the discussion.
jagbirsingh25_062
Follow / 20 May 2013 at 9:03am / MySQL

mysql query format

Expand content
i have two database values 1. runs 2. overs e.g. runs have value 1 and overs have 3 i want mysql query to display above two values in format 1/3 suggest me query , how to get this output. thanks jagbir

i have two database values
1. runs
2. overs

e.g. runs have value 1 and overs have 3

i want mysql query to display above two values in format 1/3

suggest me query , how to get this output.
thanks
jagbir

512 0 / Create an account to join the discussion.
njorger
Follow / 11 May 2013 at 8:46am / MySQL

case sensitivity on constraint references in export utility

Expand content
I have noticed that the export utility does not enforce case sensitivity in the constraint references clause. Is this a bug? Or does case matter in this instance? Is there a 'switch' or setting...
I have noticed that the export utility does not enforce case sensitivity in the constraint references clause.

Is this a bug?
Or does case matter in this instance?
Is there a 'switch' or setting to enforce case sensitivity for this?
Is this an issue with MySql itself?

I am using TOAD in a Windows environment and I realize that case is not supported for table names. However I have set the lower_case_table_names switch to 0 in my MySql databases my.ini file to recognize case and for the most part case is recognized.

I want to be able to use the resulting exported sql to rebuild database tables, but this 'anomaly' is causing extra work in that I must go through the script file and manully check for proper case in table name references. I hope there is a simple solution to this or if it is a bug that there is a fix in the works.

Thanks.

Message was edited by: njorger
572 0 / Create an account to join the discussion.
sparc
Follow / 11 May 2013 at 1:25am / MySQL

check constraint

Expand content
How to set check constraint for column, for example, was provided year from the employer greater than 15 and less than 45

How to set check constraint for column, for example, was provided year from the employer greater than 15 and less than 45

576 0 / Create an account to join the discussion.
Kariadill
Follow / 3 Apr 2013 at 2:10pm / MySQL
Latest post by on 9 Apr 2013 at 8:14am

Unable to load file

Expand content
In the Data Import wizard I can select a range in a xlsx format excel file but when I highlight and accept the input range, I get, "error reading from data file, check the file format and file encoding"...

In the Data Import wizard I can select a range in a xlsx format  excel file but when I highlight and accept the input range, I get, "error reading from data file, check the file format and file encoding" "Unable to Loadfile".

Grateful if someone would help me on working through this.

I am a total newbie and have so far just created a new database with the above as first step undertaken.

909 1 / Create an account to join the discussion.
ony12
Follow / 20 Mar 2013 at 7:07pm / MySQL
Latest post by on 25 Mar 2013 at 5:43pm

Can't set variable in data tab of Toad Report

Expand content
I created a report in TOAD but I need to set a variable in the query. I modified my code and it executed fine in the MySQL backend, but when I edit the data section of the report and add the same code...

I created a report in TOAD but I need to set a variable in the query.
I modified my code and it executed fine in the MySQL backend, but when
I edit the data section of the report and add the same code, it gives
me an error and keeps my set statement and erases all code associated with the select
statement that built the report.

I know you can in MySQL:

set @variable = 1;

select * from table

where value = @variable;

all at the same time but not letting me in TOAD report...any help or ideas?

1013 3 / Create an account to join the discussion.
GGSoft
Follow / 22 Mar 2013 at 3:30pm / MySQL

I have found a bug in toad for my sql

Expand content
Hi all! I use a free version of toad for mysql ver 6.3. I have found a bug. When I later add constraints (foriegn key) to a table that has already defined other one. Error occurs similar this: Table ....
Hi all!
I use a free version of toad for mysql ver 6.3.
I have found a bug.
When I later add constraints (foriegn key) to a table that has already defined other one. Error occurs similar this:
Table ...... Already exists. and I can't add new constraints.
I have tryed to drop and create table again, but error still occurs.
Then I found the alternate way to fix this problem:
I copied script and edit it as necessary.
After running script constraints was added.
541 0 / Create an account to join the discussion.
Milind
Follow / 12 Mar 2013 at 4:43am / MySQL

Procedures with DEFINER localhost not visible

Expand content
I am using Beta and do not see Procedures and Functions from remote (ISP) database whose definer is localhost. Only the procedures with definer '%' are seen. Is there a workaround for this?

I am using Beta and do not see Procedures and Functions from remote (ISP) database whose definer is localhost. Only the procedures with definer '%' are seen.

Is there a workaround for this?

658 0 / Create an account to join the discussion.
RobGill
Follow / 5 Mar 2013 at 4:32pm / MySQL

Scheduled Tasks / Automation Scripts

Expand content
I created an Automation Script 'Automation_Script_HH_Data.tas' which runs several other Automation Scripts. This script runs well when I click Run Automation Script. However, if I add it to the...
I created an Automation Script 'Automation_Script_HH_Data.tas' which runs several other Automation Scripts. This script runs well when I click Run Automation Script. However, if I add it to the Scheduled Tasks, only the first Export Automation Script runs.

Please let me know what I am doing wrong. Thank you for your assistance.
Rob

HH_Book.tsm

HH_Book_Company.tsm

HH_Code_Description.tsm

Operation is not valid due to the current state of the object.

Server Error in '/' Application.

Operation is not valid due to the current state of the object.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: Operation is not valid due to the current state of the object.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[InvalidOperationException: Operation is not valid due to the current state of the object.]
   System.Web.HttpValueCollection.FillFromString(String s, Boolean urlencoded, Encoding encoding) +4008959
   System.Web.HttpUtility.ParseQueryString(String query, Encoding encoding) +213
   Telligent.Evolution.Rest.Framework.Infrastructure.RestPluginHttpHandler.ProcessRequest(HttpContext context) +325
   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +625
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +270


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.272
">HH_Furniture.tsm

Operation is not valid due to the current state of the object.

Server Error in '/' Application.

Operation is not valid due to the current state of the object.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: Operation is not valid due to the current state of the object.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[InvalidOperationException: Operation is not valid due to the current state of the object.]
   System.Web.HttpValueCollection.FillFromString(String s, Boolean urlencoded, Encoding encoding) +4008959
   System.Web.HttpUtility.ParseQueryString(String query, Encoding encoding) +213
   Telligent.Evolution.Rest.Framework.Infrastructure.RestPluginHttpHandler.ProcessRequest(HttpContext context) +325
   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +625
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +270


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.272
">HH_Pattern.tsm

HH_Pattern_Alias.tsm

Operation is not valid due to the current state of the object.

Server Error in '/' Application.

Operation is not valid due to the current state of the object.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: Operation is not valid due to the current state of the object.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[InvalidOperationException: Operation is not valid due to the current state of the object.]
   System.Web.HttpValueCollection.FillFromString(String s, Boolean urlencoded, Encoding encoding) +4008959
   System.Web.HttpUtility.ParseQueryString(String query, Encoding encoding) +213
   Telligent.Evolution.Rest.Framework.Infrastructure.RestPluginHttpHandler.ProcessRequest(HttpContext context) +325
   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +625
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +270


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.272
">HH_Pattern_Color.tsm

Operation is not valid due to the current state of the object.

Server Error in '/' Application.

Operation is not valid due to the current state of the object.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: Operation is not valid due to the current state of the object.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[InvalidOperationException: Operation is not valid due to the current state of the object.]
   System.Web.HttpValueCollection.FillFromString(String s, Boolean urlencoded, Encoding encoding) +4008959
   System.Web.HttpUtility.ParseQueryString(String query, Encoding encoding) +213
   Telligent.Evolution.Rest.Framework.Infrastructure.RestPluginHttpHandler.ProcessRequest(HttpContext context) +325
   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +625
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +270


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.272
">HH_Pattern_Color_Book.tsm

Operation is not valid due to the current state of the object.

Server Error in '/' Application.

Operation is not valid due to the current state of the object.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: Operation is not valid due to the current state of the object.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[InvalidOperationException: Operation is not valid due to the current state of the object.]
   System.Web.HttpValueCollection.FillFromString(String s, Boolean urlencoded, Encoding encoding) +4008959
   System.Web.HttpUtility.ParseQueryString(String query, Encoding encoding) +213
   Telligent.Evolution.Rest.Framework.Infrastructure.RestPluginHttpHandler.ProcessRequest(HttpContext context) +325
   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +625
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +270


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.272
">HH_Pattern_Color_Stock.tsm

SQL.zip

TAS.zip

TXP.zip

746 0 / Create an account to join the discussion.
Becky
Follow / 26 Jan 2013 at 12:40am / MySQL
Latest post by on 28 Jan 2013 at 8:56pm

Getting Chinese Characters to work.

Expand content
Recently we've started receiving data in Chinese and are having trouble getting it to show up properly in our Databases. I'm generally importing CSV files from excel. But I've tried getting...
Recently we've started receiving data in Chinese and are having trouble getting it to show up properly in our Databases.

I'm generally importing CSV files from excel. But I've tried getting this to work by exporting the file from excel as unicode but that hasn't produced any results.

I've done some research but so far none of the solutions I've found work for me. I'm currently running version 6.3 of Toad. I can't get any changes in collation to save on the database level. And I've tried setting the collation to utf8 on every level that I can reach but it's still not working. Everything ends up reverting back into latin.

I've read a few places that I'd potentially need to change the collation on the server level. Which seems to only be something you can do when you create the server.

If anyone could give me some insight on what to try next I'd really appreciate it.
768 1 / Create an account to join the discussion.
thaoho
Follow / 13 Dec 2012 at 6:46am / MySQL

Step by step debug stored procedure in Toad for MySQL

Expand content
I begin to use Toad for MySQL. I don't know how to debug Stored Procedure, Function. How do I debug step by step ? (press what key, ex.) Please help me !!!!

I begin to use Toad for MySQL.
I don't know how to debug Stored Procedure, Function.
How do I debug step by step ? (press what key, ex.)
Please help me !!!!

2718 0 / Create an account to join the discussion.
Belfor
Follow / 26 Jul 2011 at 7:41pm / MySQL
Latest post by on 12 Sep 2012 at 11:28am

No puedo Ver los Scrit de usuario en la optio "ver detalles"

Expand content
Hola Todos, cuando intento ver el script de cualquier usuario por la opcion de "ver detalles" el toad me saca este error: You have an error in your SQL syntax; check the manual that corresponds...
Hola Todos, cuando intento ver el script de cualquier usuario por la opcion de "ver detalles" el toad me saca este error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@f0@@f1' at line 1

La version del motor de MySQL 5.1.41
Version del Toad es 5.0.0.345

Les agradezco la ayuda.

Saludos
1015 5 / Create an account to join the discussion.
MMaximov
Follow / 9 Jul 2012 at 4:36pm / MySQL

Access denied for user ''@'localhost' to database...

Expand content
Hi, Yesterday I downloaded and installed "Toad for mysql 6.3.0.642'. My installation is under Trial Version license. I'm using MySQL 5.5.20 After trying to debug a function, I received the...

Hi,

Yesterday I downloaded and installed "Toad for mysql 6.3.0.642'.
My installation is under Trial Version license.
I'm using MySQL 5.5.20
After trying to debug a function, I received the following messages:

1. MySQL Database Error: Access denied for user ''@'localhost' to database 'questsoftware'
2. MySQL Database Error: Access denied for user ''@'localhost' to database 'questdebug'

I don't know how to solve this issue.
I would be glad if anybody could help me in solving this issue.

Thank you in advance.

860 0 / Create an account to join the discussion.
hsmail_281
Follow / 5 Jun 2012 at 10:25pm / MySQL

TOAD for MySQL 6.3 compatibility with MySQL 5.5.25

Expand content
I'd like to install TOAD for MySQL version 6.3 and use it along with MySQL 5.5.25, but the TOAD documentation only mentions support to the old versions of MySQL (list below). It's not clear if...
I'd like to install TOAD for MySQL version 6.3 and use it along with MySQL 5.5.25, but the TOAD documentation only mentions support to the old versions of MySQL (list below). It's not clear if it would be fine to use it with higher versions of MySQL.

Database Support: 
    • MySQL® Network™ version: 4.1.18, 5.0.19
    • MySQL® Pro™ versions: 4.1.18, 5.0.19
    • MySQL® Classic™ versions: 4.1.18, 5.0.19


    I would appreciate if someone could confirm it, so I can avoid instalation in case it's not fully compatible with MySQL 5.5.25.

    Thank you so much!

907 0 / Create an account to join the discussion.