[Resolved] duplicate entry?!

[tuf-web_co_uk]

hey, i am trying to add alot of information to a database about 200/300 rows at once (i dont know if this has any significance!)

but, when i add the rows i get this error message

Error

SQL-query :

INSERT INTO waypoints
VALUES (

'', 'other', '#', '001_cs_skyx.zip', 'http://homepage.ntlworld.com/wendy.levett/waypoints/other/'
)

MySQL said:

Duplicate entry '127' for key 1

although none of my data is the same, i dont know if that means this but could anyone help me get around this please!

thanks very much!

[jnuneznyc]

Not really sure but it could be that the table has a primary or unique field and you are trying to add a similar entry into it.

Post the MySQL table structure for more help

[tuf-web_co_uk]

CREATE TABLE waypoints (
id tinyint(10) NOT NULL auto_increment,
type text NOT NULL,
letter text NOT NULL,
name text NOT NULL,
url text NOT NULL,
UNIQUE KEY id (id)
) TYPE=MyISAM;

any other info needed just ask!

thanks again

[tuf-web_co_uk]

thanks for the brief help but i have fixed it now,

i changed the id to a INDEX

works fine now thanks anyway! 😃

[jnuneznyc]

First change

CREATE TABLE waypoints ( 
    id tinyint(10) NOT NULL auto_increment, 
    type text NOT NULL, 
    letter text NOT NULL, 
    name text NOT NULL, 
    url text NOT NULL, 
    UNIQUE KEY id (id) 
) TYPE=MyISAM; 

to

CREATE TABLE waypoints ( 
    id tinyint(10) NOT NULL auto_increment, 
    type text NOT NULL, 
    letter text NOT NULL, 
    name text NOT NULL, 
    url text NOT NULL, 
    PRIMARY KEY id (id) 
) TYPE=MyISAM; 

(Not really essential just better)

Second...

INSERT INTO waypoints 
VALUES (
'', 'other', '#', '001_cs_skyx.zip', 'http://homepage.ntlworld.com/wendy.levett/waypoints/other/'
) 

to

INSERT INTO waypoints 
( type, letter, name, url )
VALUES 
( 'other', '#', '001_cs_skyx.zip', 'http://homepage.ntlworld.com/wendy.levett/waypoints/other/' ) 

[tuf-web_co_uk]

i still getting the error message :S

hhmm.... i wonder :S

please help, 🙂

thanks dude

[jnuneznyc]

Change your insert statements... Do not enter a value for the ID... MySQL will automatically increment it.

[Sxooter]

Do yourself a favor and NEVER use tinyint again.

Look it up, it's an 8 bit int. I.e. +127 to -128 is it's range.

[Arc]

Yah, for ID fields/auto_increment fields always use int(6) or greater. This will assure that you will never run out of room to add new rows..

[Sxooter]

I truly consider tinyint to be a "misfeature" If MySQL support proper constraints, you could just user a normal int and constrain it to whatever size you wanted in the odd case of when you need a smaller range.

For most folks, tiny int is just a pitfall.

[tuf-web_co_uk]

thanks alot people

that worked great 😃

lots of room for my records now 🆒

thanks again