duplicate table structure don't work on mysql 4.1

[babocom]

i use mysql 4.1.10 and default character set is euckr (yes, i'm korean)

and SQLyog version is 4.0

there's a table named Contents

'show full fields from Contents' return

Field Type Collation Null Key Default Extra Privileges Comment

---

---

---

---

---

---

---

---

---

idx int(11) NULL PRI (NULL) auto_increment select,insert,update,references

name varchar(30) euckr_korean_ci MUL select,insert,update,references

depth tinyint(4) unsigned NULL 0 select,insert,update,references

parents int(11) NULL MUL 0 select,insert,update,references

code1 smallint(11) unsigned NULL MUL 0 select,insert,update,references

code2 smallint(11) unsigned NULL 0 select,insert,update,references

code3 smallint(11) unsigned NULL 0 select,insert,update,references

code4 smallint(11) unsigned NULL 0 select,insert,update,references

code5 smallint(11) unsigned NULL 0 select,insert,update,references

code6 smallint(11) unsigned NULL 0 select,insert,update,references

code7 smallint(11) unsigned NULL 0 select,insert,update,references

code8 smallint(11) unsigned NULL 0 select,insert,update,references

code9 smallint(11) unsigned NULL 0 select,insert,update,references

code10 smallint(11) unsigned NULL 0 select,insert,update,references

sort tinyint(4) NULL 0 select,insert,update,references

inform1 tinytext euckr_korean_ci select,insert,update,references

inform2 tinytext euckr_korean_ci select,insert,update,references

html enum('Y','N') euckr_korean_ci Y select,insert,update,references

permission tinyint(1) NULL 0 select,insert,update,references

keyword varchar(255) euckr_korean_ci MUL select,insert,update,references

contents mediumtext euckr_korean_ci select,insert,update,references

wdate datetime NULL 0000-00-00 00:00:00 select,insert,update,references

hit mediumint(9) NULL 0 select,insert,update,references

offer tinytext euckr_korean_ci select,insert,update,references

has_sub char(1) euckr_korean_ci N select,insert,update,references

and 'show keys from Contents' return

Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment

---

---

---

---

---

---

---

---

---

---

---

---

Contents 0 PRIMARY 1 idx A 921 (NULL) (NULL) BTREE

Contents 1 keyword 1 keyword A 460 (NULL) (NULL) BTREE

Contents 1 parents 1 parents A 184 (NULL) (NULL) BTREE

Contents 1 name 1 name A 460 (NULL) (NULL) BTREE

Contents 1 code1 1 code1 A 6 (NULL) (NULL) BTREE

Contents 1 code1 2 code2 A 35 (NULL) (NULL) BTREE

Contents 1 code1 3 code3 A 153 (NULL) (NULL) BTREE

Contents 1 code1 4 code4 A 460 (NULL) (NULL) BTREE

Contents 1 code1 5 code5 A 921 (NULL) (NULL) BTREE

Contents 1 code1 6 code6 A 921 (NULL) (NULL) BTREE

Contents 1 code1 7 code7 A 921 (NULL) (NULL) BTREE

Contents 1 code1 8 code8 A 921 (NULL) (NULL) BTREE

Contents 1 code1 9 code9 A 921 (NULL) (NULL) BTREE

Contents 1 code1 10 code10 A 921 (NULL) (NULL) BTREE

and 'duplicate table structure' return

create table `Coremed`.`Contents_copy` ( primary key ( idx ) ,FULLTEXT KEY `keyword` ( `keyword` ), FULLTEXT KEY `parents` ( `parents` ), FULLTEXT KEY `name` ( `name` ), FULLTEXT KEY `code1` ( `code1`, `code2`, `code3`, `code4`, `code5`, `code6`, `code7`, `code8`, `code9`, `code10` ) )type=MyISAM select `idx`, `name`, `depth`, `parents`, `code1`, `code2`, `code3`, `code4`, `code5`, `code6`, `code7`, `code8`, `code9`, `code10`, `sort`, `inform1`, `inform2`, `html`, `permission`, `keyword`, `contents`, `wdate`, `hit`, `offer`, `has_sub` from `Coremed`.`Contents` where 1 = 0

there's no 'FULLTEXT KEY' in Contents table

why it produce such create query??

[babocom]

oh…

i've just downloaded SQLyog 4.05 edition

and it fixed.. k….

4.05 has no problem~

[peterlaursen]

do you know if it is an issue realted to sqlyog ?

Try

[peterlaursen]

GGRRRR .. I really have prob's with my mouse. I'd better get a new one!

With Sqlyog 4.06 an latin1 charset I can't reproduce it.

[peterlaursen]

Oh .. you were there allready!

Good thing that problems are fixed! 🙂

[Author]

Posts