Schimpf - schimpf.es
General Information:
Latest News:
Find duplicate records in MySQL 8 May 2013 | 04:12 am
Find duplicates To find duplicate records you can use GROUP BY and count on the attributes which you want to check for duplicates and use HAVING to select all records with a count greater then one: As...
UTF 8 in MySQL+PHP+HTML 7 May 2013 | 03:00 am
This little guide will describe the steps you have to take to use utf-8 in a complete web application using MySQL and PHP. The Database You have to specify the utf8 character set on all tables and tex...
TOP 10 Plugins for developing in VIM 29 Apr 2013 | 10:33 pm
VIM can still be a very good editor for writing code using the right plugins. Here is my TOP 10 of plugins I have installed and which I use most. If you are interested you can find my full configurati...
ListView with checkboxes inside 26 Feb 2013 | 02:00 am
This example will show howto use checkboxes inside a ListView. First we will create the activity which contain the listview. It extends ListActivity so we only need to set the main layout and create t...
Autoclose dialog after some time 23 Feb 2013 | 02:39 pm
Example of an dialog in android using the class DialogFragment which will close itself after aproximate three seconds. Basicly is just a DialogFragment which starts a thread when it is shown which wil...
AsyncTask for Image download 22 Feb 2013 | 11:56 am
If you have an ImageView which will has to display an image which has to be downloaded first it is best practise to download the image in a seperate Task. The following AsyncTask will download an imag...
Kill running process 18 Feb 2013 | 08:56 am
Howto kill a process in Mysql If you have a “hanging” process in MySQL and want to kill it, you use show processlist to identify the process you want to kill get get the id. Then a simple kill ID will...
Compare two MySQL databases 11 Feb 2013 | 07:00 am
If you need to compare the structure or maybe even the content of two MySQL databases you will need a tool which will help you with this not too straight task. Here is an overview of some application ...
Setting up MASTER and SLAVE replication 7 Feb 2013 | 12:20 am
Setting up MASTER and SLAVE replication in MySQL. MASTER The replication master must have binary logging enable and needs to have a unique server ID. 1. Turn on binary logging. Edit /etc/my.cnf and ma...
Connect to MySQL with Perl using DBI 5 Feb 2013 | 12:44 am
Example of a connection to MySQL with Perl using DBI #! /usr/bin/perl -w # # Example code to connect to MySQL, create a table, fill it with some data and select it again. # # To install DBI using cpan...
