Tag Archives: 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

Oracle-Sun: What will be the fate of MySQL?

Posted on 20. Apr, 2009 by Nikhil Sheth.

0

Oracle Corp. announced today that it will purchase Sun Microsystems for $7.4 billion. Sun Microsystems has agreed to the terms of the deal.
While primarily known for its database software, Oracle has in recent years acquired more enterprise and infrastructure applications through purchases of other companies, such as PeopleSoft (which offered human resource management system [...]

Continue Reading

MySQL Admin and Development Tools

Posted on 28. Mar, 2009 by Nikhil Sheth.

0

The most popular and best open source database is MySQL. Simple as that. It is consistently fast , reliabile and very, very easy to use. One of MySQLs main features is its cross-platform support, it will run on almost all operating systems, including Windows, OSX, Linux and many more. So, MySQL is the best database, [...]

Continue Reading

Filtering input data

Posted on 22. Sep, 2008 by Nikhil Sheth.

0

This guide goes over the basics of cleaning user input for safe use. This includes escaping strings correctly, stripping html and tags, preventing SQL injection, and other security issues. Anytime you use a $_POST, $_GET, or are receiving any information that the user can modify, you must be sure that you properly escape it, and [...]

Continue Reading

Get Adobe Flash playerPlugin by wpburn.com wordpress themes