Why do you use the single quotes around your field names. I have never used them when I build my schemas. That way you don't have to worry about spaces.
HTH -----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