RSS
magnify
Home Posts tagged "database"
formats

phpMyAdmin – Invalid field count in csv input on line 1

Published on April 9, 2010 by in CSV, error, phpMyAdmin

I was trying to import a massive csv dataset into phpMyAdmin and it kept throwing error: Invalid field count in csv input on line 1 This was very annoying as it was all being done the way it always works for me! To solve this I had to do the following: Import Browse for your

Read More…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
115 Comments  comments 
formats

mySQL select multiple ids

Published on December 18, 2009 by in General

SELECT * FROM tablename WHERE `active`=’1′ AND `id` IN (‘107’ , ‘125’ ) ORDER BY `id` DESC LIMIT 12

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 
formats

mySQL Development Tools

Published on December 9, 2009 by in General

I came across a very interesting article about mySQL Development Tools. http://www.smashingmagazine.com/2009/03/25/mysql-admin-and-development-tools-round-up/

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 
© Copyright © 2012 · Web Development London UK · All rights reserved · Site hosted on the hsmoore.com network
By using the site and/or making use of any of our services you agree to our Terms and Conditions