[Manoj]

According to 10.1.4. Data Type Default Values no, you can't do that with date column.

But you can do it with timestamp.

create table test (

id int,

ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP);

[Manoj]

forgot to mention another point

We are not using this this method while doing “Backup Table as SQL dump” as well as Scheduled Backup. We are using this only in “Export table data/result as…” were we are sharing data.

[Manoj]

Hi Daniel,

Thanks for reporting this. We are sharing the mysql resultset for export as well as showing it in the grid if we are exporting from table data tab/result tab. So there is a chance that the result sets current row index may change if a paint fired during exporting. After a successfull export SQLyog will show the number of records exported in the dialog, if you don't mind can you double check the number of records exported is same in both case? Anyway we will check this in our end and will check what we can do to speed up.

Thanks again,

Manoj

[Manoj]

Duplicate.

posted in the other thread

[Manoj]

Hi,

Can you try installing SQLyog with out changing the default install path? I think using Wine you won't be able to install programs on different path other than c:program files…

[Manoj]

Thanks for your feedback,

We are working on the autocomplete optimization, the build that we given is an intermediate one, will be able to give another build late today.

If you turn off “Always rebuild tags database on startup” then autocomplete won't be able to show the changes made from other clients.

Regards,

Manoj

[Manoj]

Hi,

Can you try by enabling Autocomplete and disabling “Always rebuild tag files on startup”?

[Manoj]

What is your MySQL server version? 'select version()' will give that.

If version >= 5.0 then only it supports Stored Procedure/Function

[Manoj]

😮 , Issue one is reproducible. We need to check this with NSIS.

@Ritesh: It is nice to see you here again.

[Manoj]

Hi osolo,

Can you give the result of “Select version()” from both the servers?

[Manoj]

Hi,

Syntax for IF in stored procedure is like this

IF search_condition THEN statement_list

[ELSEIF search_condition THEN statement_list] …

[ELSE statement_list]

END IF;

and for comments read this link http://mirror.yandex.ru/mirrors/ftp.mysql….n/comments.html

Here is the corrected SP

CREATE PROCEDURE `spLoadAddrType`

(IN param1 TINYINT(1), IN param2 VARCHAR(11), IN param3 TINYINT(1))

MODIFIES SQL DATA

SQL SECURITY Definer

COMMENT 'Loads addrtype via insert or update'

BEGIN

IF ((SELECT COUNT(*) FROM addrtype WHERE addrtypeid = param1)=0) THEN

INSERT INTO

addrtype(addrtypeid,

addrtypename,

dispord)

VALUES

(param1,

param2,

param3); — this is line 15

ELSE

UPDATE

addrtype

SET

addrtypename = param2, — this is line 1

dispord = param3

WHERE

addrtypeid = param1;

END IF;

END;

[Manoj]

Hi,

We will send you the link once it is ready, it requires another 5-6 hours as this requires some code change that will affect some other modules too.

Thanks once again in helping us.

[Manoj]

Hi,

We will solve this with high priority(Actually we started working on this).

“I don't agree with Manoj's 'first time' comment.” — i am not getting it, what i meant is SQLyog is executing these queries to populate the export dialog, you can see this from the “History” tab.

[Manoj]

I noticed “select `TRIGGER_NAME` from `INFORMATION_SCHEMA`.`TRIGGERS` where `TRIGGER_SCHEMA` = 'tablename';” is performing very slow in 5.0.x servers when it is executed for the first time.

[Manoj]

Hi,

Thanks for your help, we are able to find the issue here. With latest we are executing some extra queries before populating the dialog. We are trying to optimize this. The following are the queries executing before the dialog is active, Could you please check these queries in your server and see how much time it is taking?

show full tables from `tablename` where Table_type = 'BASE TABLE';

show full tables from `tablename` where Table_type = 'view';

select `SPECIFIC_NAME` from `INFORMATION_SCHEMA`.`ROUTINES` where `ROUTINE_SCHEMA` = 'tablename' and ROUTINE_TYPE = 'PROCEDURE';

select `SPECIFIC_NAME` from `INFORMATION_SCHEMA`.`ROUTINES` where `ROUTINE_SCHEMA` = 'tablename' and ROUTINE_TYPE = 'FUNCTION';

select `TRIGGER_NAME` from `INFORMATION_SCHEMA`.`TRIGGERS` where `TRIGGER_SCHEMA` = 'tablename';

[Author]

Posts