Kaplan Komputing
Category Archives: MySQL
MySQL IGNORE INTO

So the other day, I went to restart MySQL on my server. When I did that, it stopped but would not turn back on. What I quickly found out was innoDB Is VERY picky about its settings and if any setting is off, mysql will not start. To fix this...

Posted on: Sep 12th, 2015
MySQL IGNORE INTO

When using MySQL, using INSERT IGNORE INTO is a great way to prevent duplicates in a table. The way IGNORE INTO works is it first auto_increments the column and THEN checks to see if that record is already in the table. Because of this, your...

Posted on: Sep 10th, 2015