[Zendak]

Quote:

Which version of MySQL are you using?

Currently using 4.0.14-nt on WinXP locally

I've also tested this connecting to one of my remote sites using 3.23.55-Max-log on Linux, and encountered the exact same behaviour.

[Zendak]

Ritesh wrote on Oct 12 2004, 12:04 PM:

SQLyog logs up all the queries that it executes in the History Window.

Do you find anything unusual?

Sorry about the delay..

Here's a test case with a very simple table containing a VARCHAR column:

Code:

CREATE TABLE `test` (                                                        
         `example_col` varchar(100) default NULL                                    
       ) TYPE=MyISAM

Here's the output from the History window when copying this table:

Code:

[19:17:36][  10 ms] use `medialagoon`
[19:17:36][  10 ms] show full fields from `medialagoon`.`test`
[19:17:36][  10 ms] show table status from `medialagoon` like 'test'
[19:17:45][  10 ms] show keys from `medialagoon`.`test`
[19:17:45][  20 ms] create table `medialagoon`.`test_copy` () type=MyISAM select `example_col` from `medialagoon`.`test` where 1 = 0
[19:17:45][  20 ms] show full fields from `medialagoon`.`test`
[19:17:47][  10 ms] show full fields from `medialagoon`.`test_copy`
[19:17:47][  10 ms] show keys from `medialagoon`.`test_copy`
[19:17:47][   0 ms] show create table `medialagoon`.`test_copy`
[19:17:47][   0 ms] use `medialagoon`

In the new table 'test_copy' the field 'example_col' now strangely has CHAR(100) as the type.

Thanks

[Author]

Posts