[Cialug] Problems with Mariadb insert

[Ralph Kessel]

Thank you for your help. I didn't see the obvious since I copied this sql from a book (PHP & MySQL Everyday Apps for Dummies).I guess I was theDummy. I'm glad I could depend on you guys for help.  This is how I learn.

Thanks,
Ralph

I was going to use this in PGSQL too.  I'm always happy to learn.



________________________________
 From: jim kraai <jimgkraai at gmail.com>
To: Central Iowa Linux Users Group <cialug at cialug.org> 
Sent: Sunday, March 3, 2013 4:05 PM
Subject: Re: [Cialug] Problems with Mariadb insert
 
> INSERT INTO `Food` VALUES (1,"Navel","2005-01-03","Fruit","Oranges","Sweet, juicy.","2.10","Missing.jpg");
> INSERT INTO `Food` VALUES (3,"Romaine","2005-01-03","Vegetables","Lettuce","Leafy, crispy.","1.10","Missing.jpg"),

needs a semicolon, not a comma

> INSERT INTO `Food` VALUES (4,"Delicious","2005-01-05","Fruit","Apples","Bright red, sweet, fresh, crispy.","1.10","Missing.jpg")
_______________________________________________
Cialug mailing list
Cialug at cialug.org
http://cialug.org/mailman/listinfo/cialug