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

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 40 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

451 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

570 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

667 0 / 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.
585 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?

738 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

884 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.
836 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 !!!!

3173 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
1141 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.

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

1085 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
889 1 / Create an account to join the discussion.
Guy_M
Follow / 7 May 2012 at 8:46pm / MySQL

How to use set from au stored procedure

Expand content
Hi, I created a stored procedure that return a set of data. Some time, I would like to filter this set. Its can be done within the pane result, I would like to do this within a SQL script. Best regards...

Hi,

I created a stored procedure that return a set of data.

Some time, I would like to filter this set. Its can be done within the pane result, I would like to do this within a SQL script.

Best regards
Guy

625 0 / Create an account to join the discussion.
Inupgames
Follow / 16 Mar 2012 at 3:36am / MySQL

Connecting to Amazon RDS

Expand content
I've set up my connection to Amazon's RDS to the best of my ablility through your blog posting but still can't get it to work. I selected TCP then added my host name, DB name and passwords...

I've set up my connection to Amazon's RDS to the best of my ablility through your blog posting but still can't get it to work. I selected TCP then added my host name, DB name and passwords with the right password to the main login. The message I get is this:

Unable to connect to any of the specified MySQL hosts.

Is there something that I've done wrong?



Message was edited by: Inupgames
1175 0 / Create an account to join the discussion.