Jump to content


Photo

strange :s


  • Please log in to reply
2 replies to this topic

#1 convinceme

convinceme
  • Members
  • PipPip
  • Member
  • 16 posts

Posted 22 March 2006 - 08:53 AM

Thats how i rem always entering data into a mysql table but now suddenlyit doesnt appear to work :S thats real weird....
SQL-query:
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'
) 
[!--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


#2 wickning1

wickning1
  • Members
  • PipPipPip
  • Advanced Member
  • 405 posts

Posted 22 March 2006 - 12:51 PM

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

#3 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 23 March 2006 - 08:12 AM

Agreed -- but if you feel the need to put it in, use NULL or 0, not a string value.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users