Archive for 'MySql'

Last inserted ID in MYSQL

Posted on 15. Dec, 2009 by Nikhil Sheth.

0

Whenever you are doing multiple inserts in a single INSERT query, LAST_INSERT_ID() OR mysql_insert_id will return you id for the first insert of the query and not the last. So take care while doing multiple inserts in a single query. A work around would be, you get the value of last inserted ID and add [...]

Continue Reading

MySQL Librarian

Posted on 29. Jul, 2009 by Nikhil Sheth.

0

The MySQL Librarian is an initiative aimed to collect links to the best MySQL-related material on the web. The MySQL Librarian initiative is very young, at the moment there are about 217 items, 140 of them are presentations, 33 videos plus pictures and books. We need to wait for sometime before seeing if this new initiative [...]

Continue Reading

Automated MySQL Backups: phpMyBackupPro

Posted on 24. Jul, 2009 by Nikhil Sheth.

0

phpMyBackupPro is an open source application for taking scheduled backups of MySQL databases & FTP files. It offers a flexible usage as backup jobs of multiple databases/files from multiple servers can be scheduled, completed & compressed. Backups can be taken to any location including remote FTP servers. Besides taking backups, phpMyBackupPro can restore & e-mail backups. As a third [...]

Continue Reading

MySQL Events

Posted on 27. May, 2009 by Nikhil Sheth.

0

What are MySQL Events? Events are just like cronjobs in Linux or or task scheduler in windows. They are similar to triggers but it fires at particular time or periodically. You have flexibility of setting start date and end date too. MySQL supports Event from version 5.1.6 onwards. CREATE EVENT [ IF NOT EXISTS ] event_name ON SCHEDULE schedule [ [...]

Continue Reading

1 2 »
Get Adobe Flash playerPlugin by wpburn.com wordpress themes