Cannot Create Table

[TomBez]

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.

[peterlaursen]

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`))

[TomBez]

peterlaursen 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=dynamic

so it is the missing ',' between field definitions

[peterlaursen]

exactly!

It is fixed in the development tree now.

we will probably release beta4 tonight.

[VFRDaddy]

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. 😮

[peterlaursen]

Quote:

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.

[Author]

Posts