Posts Tagged ‘database’
phpMyAdmin – Invalid field count in csv input on line 1
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 csv file. Select CSV using LOAD DATA (rather than just CSV) Change “Fields terminated by”…
mySQL select multiple ids
SELECT * FROM tablename WHERE `active`=’1′ AND `id` IN (’107′ , ’125′ ) ORDER BY `id` DESC LIMIT 12
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/
