|INSERT ... ON DUPLICATE KEY UPDATE|
| The other day I found out about MySQL's INSERT ... ON DUPLICATE KEY UPDATE statement. It allows you do do an INSERT when a given key doesn't exist, or to do an UPDATE statement when it does.|
I have a lot of code that does a query to see if the given ID exists, and then does an INSERT or UPDATE depending on the condition. This statement should simplify such code nicely. Good thing I know about it now.
I'm not sure if this is MySQL specific or general SQL. I'm pretty firmly locked into MySQL already though, so it doesn't really matter to me.
|RSSMailingList: a free combination RSS feed creator and mailing list manager|
| For the Sillysoft Newsletter I wanted an email mailing list that also had an RSS feed of itself. This way users could subscribe whichever way they want. I didn't find anything that did what I wanted so I created my own using PHP and a MySQL database.|
I mentioned it on the macsb mailing list offering to share my code. A few people seemed interested, so I cleaned it up a bunch and hereby release it as RSSMailingList!
If you want a combination RSS feed generator and mailing list manager then check it out.
|Importing database backups into MySQL|
| Reminder to self: The command to run an SQL file into MySQL is:|
mysql -u USER -p DBNAME < dump.sqlMore info to be found at google answers page.
|the MS SQL equivalent to MySQL's 'limit' command|
| The MS SQL eqivalent of MySQL's LIMIT clause is TOP. Example: |
SELECT TOP 10 * FROM stuff;
Will return the top ten rows, effectively doing the same thing as
SELET * FROM stuff LIMIT 10;
This was found here and has been verified by me that it actually works.