Java Library to access MS Office files

I just stumbled over the Apache POI project. The title reads Apache POI – Java API To Access Microsoft Format Files and this seems what it is good for. Maybe someone out there finds this as helpful as I currently do.

mysql DUMB

Here the mysql dump and restore commands with username, password and database name.

Change user and password and dbname and filename according to you needs! Note that if you write down or type in your passphrase you may be at risk if someone observes this. If you leave out password behind the -p mysql will prompt you for it and it will not be displayed as you type it in. This may be more secure.

1. dump the database dbname to filename
   mysqldump -uuser -ppassword dbname > filename
2. dump the database dbname to filename and add ‘drop table if exists’ to DDL (dangerous for existing data)
   mysqldump –add-drop-table -uuser -ppassword dbname > filename
3. restore the dump in filename to the database dbname
   mysql -uuser -ppassword dbname < filename

(note: in this example username is user and password is password)

http://www.devshed.com/c/a/MySQL/Backing-up-and-restoring-your-MySQL-Database/2/

As always I am not responsible for any damage

SQL Statements formatieren

Da ich schön des Öfteren vor dem Problem stand hässliche SQL Statements zu formatieren, habe ich mich mal umgeschaut. Hier also der hilfreiche Verweis auf den Instant SQL Formatter.