November, 2008 | Net island

Inner join updates

October 30, 2009November 28, 2008 by feign

Here is how to do update of a table that needs to be joined with another table in MySQL, Oracle and SqlServer. Let’s say we want to give a 20% raise to sales department. Microsoft SQL Server: ORACLE: Be careful here to have a primary key set on Department.DepID. Otherwise you get an error ORA-01779 … Read more

MySQL – Full database backup & restore

October 30, 2009November 27, 2008 by feign

Mysql has it pretty simple when it comes to database backup. Using mysqldump tool you can create an sql dump of one, more or all databases on your server. What it does, is writes SQL scripts for every object inside a database (DML, grants, data inserts etc.). Database restore (or cloning) is then done by … Read more