The column's name is 'name ' not 'name' run an alter to get rid of the space at the end.
> -----Original Message----- > From: Insanely Great [mailto:insanely420@;PunkAss.com] > Sent: Thursday, October 24, 2002 8:59 AM > To: MySQL List > Subject: Insert Error > > > Greetings... > > I have a table in database ch whose create statement is as follows - > > CREATE TABLE `chn1` ( > `id` int(10) NOT NULL auto_increment, > `chn` varchar(10) NOT NULL default 'Pagal', > `name ` varchar(50) default '', > `chn3` text, > PRIMARY KEY (`id`) > TYPE=ISAM ; > > Now when I giving a insert statement like this - > insert into chn.chn1 ( id, chn, name , chn3 ) values ( '10', 'Pagal', > 'Chagal', 'I am a bad boy' ) > > MySQL is giving me an error : > > Error Code : 1054 > Unknown column 'name' in 'field list' > > As you see there exists a column name field ? I checked out and > there was a > space after name in the column defination. If I remove the space > it works ? > How come a space causes an error because I am giving space after > the column > field also ? > > Can anybody shade a light on it. > > Thanks in advance. > > Rgds > Insane > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
