Re: [PHP] phpmyadmin duplication of sql

[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 having but it should get the job done)

David





-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] phpmyadmin duplication of sql

[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 NULL
)

MySQL said:


Duplicate column name 'y'
Back



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] phpmyadmin duplication of sql

[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 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 NULL
 )
 
 MySQL said:
 
 
 Duplicate column name 'y'
 Back
 
 
 
 -- 
 PHP General Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php
 


__
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] phpmyadmin duplication of sql

[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 field and name that field 'y' ..., submit the request and then
phpmyadmin generates the error but i have only create a table with one
field.  i am simple trying to specify what that one field is.

thanks,mike



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php