forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Cannot Create Table
- This topic is empty.
-
AuthorPosts
-
-
September 19, 2006 at 7:02 am #9885TomBezMember
Hi there,
got a problem with the 5.2 beta 2. when i try to add a simple table (id int auto_inc, field1 varchar(250), field2 varchar(250)) with myisam, isam or innodb engine on a mysql 4.0.18-nt (windows 2000 server) the following error is raised:
error no 1064
You have an error in your SQL syntax. check manual that corresponds …
the funny thing is, on a mysql 5 it works without a problem, same values.
from the error-message i would suppose, that ',' is missing between the field definitions.
-
September 19, 2006 at 4:23 pm #22449peterlaursenParticipant
You do not have to guess – look in HISTORY tab!
this is generated when connected to 4.0 (beta3)
Code:create table `test`.`TableName1` ( `id` bigint NOT NULL AUTO_INCREMENT UNIQUE `t1` varchar (50) `t2` varchar (50) PRIMARY KEY ( `id`))this works (and is also genereated when connected to 5.x)
Code:create table `test`.`TableName1` ( `id` bigint NOT NULL AUTO_INCREMENT UNIQUE, `t1` varchar (50), `t2` varchar (50), PRIMARY KEY ( `id`)) -
September 20, 2006 at 7:03 am #22450TomBezMemberpeterlaursen wrote on Sep 19 2006, 06:23 PM:this is generated when connected to 4.0 (beta3)Code:create table `test`.`TableName1` ( `id` bigint NOT NULL AUTO_INCREMENT UNIQUE `t1` varchar (50) `t2` varchar (50) PRIMARY KEY ( `id`))Code:create table `crm`.`TableName1` ( `id` int NOT NULL AUTO_INCREMENT `field1` varchar (250) `field2` varchar (250) PRIMARY KEY ( `id`)) Type=MyISAM comment='' row_format=dynamic
i don't know why, but this does not work in 4.0.18.
but this works:
Code:create table `crm`.`TableName1` ( `id` int NOT NULL AUTO_INCREMENT UNIQUE, `field1` varchar (250), `field2` varchar (250), PRIMARY KEY ( `id`)) Type=MyISAM comment='' row_format=dynamicso it is the missing ',' between field definitions
-
September 20, 2006 at 8:01 am #22451peterlaursenParticipant
exactly!
It is fixed in the development tree now.
we will probably release beta4 tonight.
-
October 6, 2006 at 9:02 pm #22452VFRDaddyMember
I am having a problem importing a .sql structure and data. Also creating a simple table. The history is showing this:
/*[3:49:53 PM][0 ms]*/ show tables from `attseo`
/*[3:50:04 PM][0 ms]*/ create table `attseo`.`articles` (
`ID` int (11) NOT NULL AUTO_INCREMENT PRIMARY KEY ( `ID`))
/*[3:50:04 PM][0 ms]*/ show create table `attseo`.`articles`
More information:
SQLyog version = 5.19
MySQL = 3.23.58
Please advise. I am stumped. It works with a higher version of MySQL. 4.1.20, but not on 3.23.58.
Thanks in advance. 😮
-
October 7, 2006 at 8:29 pm #22453peterlaursenParticipantQuote:Also creating a simple table
Do you mean that you cannot create a table form SQLyog GUI?
about the import problem: Please copy a COMPLETE 'create statement for a table' from the file in here.
-
-
AuthorPosts
- You must be logged in to reply to this topic.