MySQL
Protect your website against SQL injection
SQL injection is one of the deadliest techniques attackers use to exploit the weakness in your database code of your website. Regardless of the technology/scripting language you must make sure your code is 100% perfect against SQL injection.
Here I will use PHP and MySQL examples for its wide usage and also I’m much more comfortable [...]
Restoring Large MySQL dumps
A lot of things influenced me to write this post. In fact I wanted to write on this sometime back but finally I was able to squeeze some time. Lately I have been moving data between servers and the main problem I had was with large MySQL dumps because I have been using PHPMyAdmin for [...]
Copying records in MySQL
Copying records from one table to another can be a very basic requirement. But writing queries to perform this task can be bit of a work around. But there is a very simple query to get this done.
Its by using INSERT … SELECT
http://dev.mysql.com/doc/refman/5.0/en/insert-select.html
Copy one record from a table to another
1
INSERT INTO `dest_table` SELECT * FROM [...]
