Re: [PHP] phpmyadmin duplication of sql

2003-02-25 Thread David Eisenhart
have you attempted to simply create the table and column using the sql text box (ie not using the create table interface)? eg pasting and submitting something like: CREATE TABLE t2 ( y varchar(5) ) TYPE=MyISAM; (I appreciate this does not address the reason behind the actual problem you are hav

Re: [PHP] phpmyadmin duplication of sql

2003-02-24 Thread Michael Gaab
"Daniel Guerrier" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Duplicate column name 'y' > Back > > It means what it said. You are trying to create a > table with two columns with the same name. no i use the textfields presented with the interface. i create a new table with 1 f

Re: [PHP] phpmyadmin duplication of sql

2003-02-24 Thread Daniel Guerrier
Duplicate column name 'y' Back It means what it said. You are trying to create a table with two columns with the same name. --- Michael Gaab <[EMAIL PROTECTED]> wrote: > i am using the phpmyadmin interface to develop a > small web based > application. > when i create a table i get the following

[PHP] phpmyadmin duplication of sql

2003-02-24 Thread Michael Gaab
i am using the phpmyadmin interface to develop a small web based application. when i create a table i get the following error. for some reason the query inserts a duplicate. any help appreciated, mike Error SQL-query : CREATE TABLE `t2` ( `y` VARCHAR( 5 ) NOT NULL , `y` VARCHAR( 5 ) NOT NUL