creating a vagrant base box from an existing base box

A vagrant Ubuntu Server 32bit 14.04 LTS with Apache, MySQl, PHP and several development tools installed. The server contains the following components: apache mysql php 5.5 sqlite vim git composer nodejs, npm cUrl xdebug The result can be used here: https://atlas.hashicorp.com/alexwenzel/boxes/webdev Prepare the server Initzialize vagrant: vagrant init ubuntu/trusty32 Edit the initial vagrant Read more…

find duplicates in sqlite

My table has 3 columns: col1 col2 col3 I want to detect all columns with duplicates in col1 + col2. SELECT *, rowid, COUNT(*) c FROM “table” GROUP BY col1, col2 HAVING c > 1 This query will give me all row ids with equal values in col1 and col2.