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

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

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