Jump to content

Archived

This topic is now archived and is closed to further replies.

convinceme

strange :s

Recommended Posts

Thats how i rem always entering data into a mysql table but now suddenlyit doesnt appear to work :S thats real weird....
SQL-query:
[code]
CREATE TABLE cities (

  id int(11) NOT NULL auto_increment,

  city_name varchar(50) NOT NULL default '',

  latitude varchar(15) NOT NULL default '',

  longitude varchar(15) NOT NULL default '',

  population int(11) NOT NULL default '0',

  country_code char(2) NOT NULL default '',

  PRIMARY KEY  (id)

) TYPE=MyISAM AUTO_INCREMENT=1;


INSERT INTO `cities` ( `id` , `city_name` , `latitude` , `longitude` , `population` , `country_code` )
VALUES (

'', 'Sherbrooke', '45 23 59.00', '-71 46 11.00', 125000, 'ca'
)
[/code]
[!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]
Mysql Error:
#1264 - Out of range value adjusted for column 'id' at row 1 [/quote]

can someone please tell me what went wrong there :S

Share this post


Link to post
Share on other sites
That should be fine, but you're better off leaving `id` out of the insert:

INSERT INTO cities (city_name, latitude, longitude, population, country_code)
VALUES ('Sherbrooke', '45 23 59.00', '-71 46 11.00', 125000, 'ca')

Share this post


Link to post
Share on other sites
Agreed -- but if you feel the need to put it in, use NULL or 0, not a string value.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.