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

Milind
Follow / 12 Apr 2010 at 7:49pm / MySQL
Latest post by on 22 May 2015 at 10:15am

Connecting to remotely hosted MySQL

Expand content
Hi, I have installed TOAD for MySQL on Windows Vista. MySQL instance is hosted on remote server by web hosting company. TOAD can not show Procedures since it looks into informaction_schema to which the...

Hi,

I have installed TOAD for MySQL on Windows Vista. MySQL instance is hosted on remote server by web hosting company. TOAD can not show Procedures since it looks into informaction_schema to which the login does not have access to.

However can see all tables.

Any idea how to view / create / edit procedures in TOAD?

Thanks in advance

737 1 / Create an account to join the discussion.
Malky
Follow / 20 May 2015 at 12:52am / MySQL

Why is Toad freezing when I try and use the SQL Editor?

Expand content
Dear All I am very new to all of this and I am having a nightmare getting started. Slowly overcoming problems as they arise but I cannot seem to get round the fact that despite inital successes of building...

Dear All

I am very new to all of this and I am having a nightmare getting started. Slowly overcoming problems as they arise but I cannot seem to get round the fact that despite inital successes of building my test database and populating it via the SQL Editor Toad is now hanging/freezing.

I can use all other functions but as soon as I try and use the SQL Editor it locks up and I have to "End Task".

Using Toad 7.3 Freeware

MySQL 5.7.7

Is this a known bug or am I being very dumb over and over again?

Any help or information would be gratefully received.

Malky

Unanswered 31 0 / Create an account to join the discussion.
xmedeko
Follow / 5 May 2015 at 8:05am / MySQL

Toad 7.5 hangs when alter procedure or function

Expand content
Hi, I have Toad 7.5.0.966 for MySQL. When I open popup meno in Object Explorer Functions or Procedures, and choose Alter Function (Alter Procedure), then Taod hangs. I have to go to Task manager and kill...

Hi, I have Toad 7.5.0.966 for MySQL. When I open popup meno in Object Explorer Functions or Procedures, and choose Alter Function (Alter Procedure), then Taod hangs. I have to go to Task manager and kill the Toad.

52 0 / Create an account to join the discussion.
jkpalmer
Follow / 29 Apr 2015 at 3:14pm / MySQL

Is it possible to use Toad for MySQL to use the visual builder and...

Expand content
I am attempting to use Toad for MySQL v7.3 to visually construct an update using an inner join. If I use the Query Builder and visually construct the inner join and then attempt to select Update (below...

I am attempting to use Toad for MySQL v7.3  to visually construct an update using an inner join.

If I use the Query Builder and visually construct the inner join and then attempt to select Update (below the Query Builder option), the option is not available.

Help appreciated.

Jim P.

49 0 / Create an account to join the discussion.
odar1291
Follow / 9 Dec 2014 at 3:50pm / MySQL
Latest post by on 9 Dec 2014 at 6:23pm

do not appear decimals value

Expand content
When I tried do calculation where the result are in decimals, this are not displaying. (SQL EXPRESS) I tried: select cast(3/4 as decimal(8,2)) example but the result is example 0.00 and...

When I tried do calculation where the result are in decimals, this are not displaying. (SQL EXPRESS)

I tried:

select cast(3/4 as decimal(8,2)) example

but the result is 

example

     0.00

and the real value do not appear

Unanswered 179 1 / Create an account to join the 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

634 0 / 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

689 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

808 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?

835 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

1027 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.
975 1 / 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
1311 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.

1225 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!

1255 0 / Create an account to join the discussion.
frankk
Follow / 8 May 2012 at 4:05pm / MySQL
Latest post by on 8 May 2012 at 8:32pm

ubuntu 8.04 server

Expand content
trying to connect to mysql (installed on a windows machine) to a database on a ubuntu server and i get this message: Unable to connect to any of the specified MySQL hosts. Any ideas? Thanks, Frank
trying to connect to mysql (installed on a windows machine) to a database on a ubuntu server and i get this message:

Unable to connect to any of the specified MySQL hosts.

Any ideas?

Thanks,
Frank
987 1 / Create an account to join the discussion.