You will no longer receive e-mail notifications from this forum.
Log-In to post
These people make Toad for MySQL great and have the most points for this month!
The new stable version of Toad for MySQL 7.2 is now available for immediate download.
Just head over to the download section and get it right now!
Is there a way to export into excel from the Job Manager? I have 120 reports automated and would like to see them in excel.
I am trying to use RANK() in TOAD SQL editor, it keeps saying there is no RANK function in the test schema I am working on. What I actually want is similar to DENSE_RANK or ANALYTIC rank function for my table... Any help in knowing the syntax, or using RANK function is much appreciated!
I am so thrilled to have found Toad and this forum!!!
First, a disclaimer: I am a novice at DB administration and everything I know is self taught through forums just like this one. That learning is out of necessity, but thank God I enjoy a challenge! My question may be "basic" and I apologize to the experts that may find my inquiry frustratingly simple. I have searched the forum and couldn't find the answer and thus, finally asking for help.
My Experience Level with Toad: maybe 6 hours of useMy DB Admin Skill Level: NoviceVersion of Toad: 126.96.36.19922Toad Feature I am have issues with: Compare SchemaError being encountered: Select command denied to user 'xxxx'@'yyyyy' for table 'db' Quest.Compare.Schema.MySQL.DBModelPrior to posting I made sure (using Toad)...
I also reviewed the "How to create multi-schema comparison" posted within the forum but that didn't help. As soon as I execute the compare, Toad returns the stated error. I suspect this is something truly simple and elementary but I, as I mentioned, I am a novice and would truly appreciate any guidance from anyone willing to point me in the right direction.
Thanks in advance!
I am NEW to TOAD. I just upgraded my ToadForMySQL client on my Windows 7 box from ToadForMySQL 188.8.131.528 to ToadForMySQL 184.108.40.20622. I have 4 databases that I currently connect to. Of the 4 connection entries that I have in my Connection Manager I can only connect to 3. When I try to connect to the 4th database using my connection entry I get this error:
MySQL Database Error
Authentication with old password no longer supported, use 4.1 style passwords.
Any suggestions on how to fix this issue would be appreciated. Nothing has changed regarding permissions or passwords in any of these connections. A reply would be appreciated ASAP.
I would like to run toad for mysql from my mremoteng tools.When I want to run toad with command line, it opens toad but does not connect to the database (only open editor's window)In a CMD, I use C:\Program Files\Quest Software\Toad for Oracle\TOAD.exe Connect=%Username%/%Password%@%dbName%Any idea to autorun and connect toad to a specific database?
I prefer to use older version (v5.x) of Toad for MySQL.Can I download them somewhere?on the main download page there is only the newest GA version available.Peter
Here is some silly example code to try to demonstrate my issue with collapsing.
CREATE PROCEDURE Test
DECLARE vCondition2 int;
DECLARE vCondition3 int;
SET vCondition2 = 3;
WHILE vCondition2 = 3 DO
IF vCondition3 = 2 THEN
SET vConditon2 = 1;
SET vCondition2 = 3;
If I collapse on the BEGIN, I get:
If I collapse on –region test:
It seems the WHILE is screwing up the collapse logic. Is there an error in my syntax? Is there a work around?
After upgrading to Toad for MySQL 7.2, I am no longer able to connect to my FTP server. I receive the following error after the connection times out:
Failed to accept connection within the timeout period
I've confirmed that my username/password is valid and the directory specified is correct.
How can I install Toad for MySQL on a stand-alone pc which is not connected to the internet?
I did a select * from a table with toad and the results were different from the same select command with mysql on the host linux box. I am attaching a screen capture to demonstrate. The select from mysql and from toad were both just seconds apart. check the third line down. in mysql all columns have data but in toad just about all the columns are NULL.
I tested this with toad 7.0 and with toad 7.2 and got the same results.
any help would be appreciated.
I received this message while trying to import an Excel file using Toad for MySQL's Import Wizard: "Object reference not set to an instance of an object" Nothing was imported. Can someone tell me what this means and how to resolve it? Thank you.
I'm having a persistent problem where whenever running any automated script building within Toad for MySQL, it is choosing to export binary data as a hexadecimal literal, which would be fine, but these appear to not be formatted correctly (data comparison for example).
As per http://dev.mysql.com/doc/refman/5.6/en/hexadecimal-literals.html literals must start with "0x", or "X'", neither of which is true.
Upon running the scripts, they will error out on the page with the following error code: http://dev.mysql.com/doc/refman/5.6/en/error-messages-server.html#error_er_bad_field_error
UPDATE `table1` SET `column1` = 3C703E3C7374726F6E673E43...
UPDATE `table1` SET `column1` = 0x3C703E3C7374726F6E673E43...
Disabling Hex literal usage in toad would fix it, or perhaps there is some setup/config that is incorrect? Any help would be appreciated. TIA.
Hi, i was looking for the chance to execute the same query on multiple MySql databases/schemas with Toad for MySql... I found this interesting link but it's for Toad for Oracle:
Does anybody know if there is a way to achieve the same with Toad for MySql?
Or would you consider to add this feature in future releases?
Help me please!When I put an alias for column in my SQL Query (SELECT MyColumn as 'Проверка' from MyBase) in the Foreign language (Russian for me), I see symbols shown on the picture. Any ideas?
After installer the Toad for MySQL 7.2 show the error message bellow.
Can anybody help-me?
Toad hangs when using "Send to Query Builder" from an editor window.I am using Toad for mySQL 220.127.116.118. It becomes completely unresponsive. The task manager shows that it is using 5-18% cpu with normal amounts of memory and must be killed through the task manager. Simplier queries can be sent to Query Builder with ease.
My query is below.
SELECT city, AVG(RATIO) as sAvgPayments, COUNT(RATIO) as sProperties,69.0 * DEGREES(ACOS(COS(RADIANS(latpoint))* COS(RADIANS(`prim_lat_dec`))* COS(RADIANS(longpoint) - RADIANS(`prim_long_dec`))+ SIN(RADIANS(latpoint))* SIN(RADIANS(`prim_lat_dec`)))) AS distance_in_miFROM i_usgs_geoname as ug, (SELECT p.property_id, p.number, p.street, p.city, MVnR.bedrooms, MVnR.bathrooms, (MVnR.value / MVnR.rentestimate) as RATIOFROM (SELECT p.property_id, zgds.bedrooms, zgds.bathrooms, zgds.rentestimate, mv.valueFROM z_gds zgds, property p, market_value mv, source_access saWHERE p.property_id = zgds.property_idand p.property_id = mv.property_idand zgds.error_code is nulland zgds.rentestimate is not nulland zgds.finishedSqFt is not nulland zgds.useCode <> 'Unknown'and zgds.useCode <> 'Mobile'and zgds.source_access_id = sa.source_access_idand sa.access_time >= ( CURDATE() - INTERVAL 3 DAY )and mv.value >= 0 # Min Priceand mv.value <= 125000 # Max pricegroup by p.property_idorder by mv.market_value_id desc) as MVnR, property pWHERE p.property_id = MVnR.property_idORDER BY RATIO) as DJOIN (SELECT 37.718253 AS latpoint, -122.406973 AS longpoint, 10.0 AS r) AS pWHERE feature_name = cityAND feature_class = 'Populated Place'AND state_alpha = 'CA'GROUP BY D.cityORDER BY sAvgPayments