Re: INSERT - very newbie question probably...

2001-01-23 Thread Peter Pentchev
On Tue, Jan 23, 2001 at 11:19:20AM +0100, Gustav Wiberg wrote: > Hi > > Why can't I do like this? > > insert into tbnamn (fornamn, efternamn) values('g1','g2','g3','g4'); > > where fornamn and efternamn is the only fields in the table tbnamn Try: insert into tbnamn (fornamn, efternamn) values

Re: INSERT - very newbie question probably...

2001-01-23 Thread Rafael Pastor
The number of fields must be the same as the number of values... otherwise: Syntax Error. - Original Message - From: "Gustav Wiberg" <[EMAIL PROTECTED]> To: "MYSQL List" <[EMAIL PROTECTED]> Sent: Tuesday, January 23, 2001 11:19 AM Subject: INSERT - very ne

INSERT - very newbie question probably...

2001-01-23 Thread Gustav Wiberg
Hi Why can't I do like this? insert into tbnamn (fornamn, efternamn) values('g1','g2','g3','g4'); where fornamn and efternamn is the only fields in the table tbnamn /Gustav Wiberg - Before posting, please check: http://ww