Posts
Critical Mass Lecco
It has to start somewhere,
it has to start sometime !
Which better place than here ?
Which better time than now ?
Critical Mass Lecco 2008
Clusone '07
Giusy, Kathrin and me. Thanks to Adeline (on the other side of the camera
Like the last 4 years, few days ago, I was in Clusone for the Estate di S.Martino, I love this village and the feeling you get during the happening. Lovely wine, traditional food and true friends … need more to be happy ?
If the next year you wanna come mark this site: www.bandabidu.org.
CSV export from MySQL
If you have access on the machine with MySQL and you need to export all tables in a database you can use:
hpatoio@namazu:~$ mysqldump -uroot -p DATABASE_NAME -T '/home/simone/export_csv' --fields-terminated-by "," --fields-enclosed-by '"' --lines-terminated-by "\n"
the script will create a files for each table of the DB and will place it in export_csv.
If you need to export a custom resultset or you need to export data from a remote MySQL server on your machine you can use this command :
hpatoio@namazu:~$ mysql -uroot -h HOSTNAME -p DATABASE_NAME -B -e "select field1,field2 ... fieldX from \`TABLE_NAME\`;" | sed 's/\t/","/g;s/^/"/;s/$/"/;s/\n//g' > my_export.csv
Microsoft Access to MySQL | Online converter
Amazing online tool to convert MDB Microsoft Access file to MySQL SQL scripts !
Check it out -> http://www.mdb2mysql.com/
Good times
Joelle and I
And also for this year my vacations are finished. Many people I've met on the way … some were already friends, some were new 
.
I could write for hours trying to tell you who I meet and where I was, but, as you probably know I'm not good in telling stories.
So just wanna say thanks to : Jan, Rebekka, Bugo, Vale, Gio, Anca (even if it didn't work), Joelle and all the people at the NEVA meeting, Linnea, Kenneth and all the Tjärnkvist family, Karsten, Liga, the lovely people in Ultervattnet, the backpackers at the Sunflower Hostel, Adam and of course to Swedish Police
Due I didn't have a camera with me there are no pictures of the vacations, except for this one …
Finally ! What you see is what you mean
I was looking for a good and clean editor for one of my customers, and I end up to WYMeditor !
That's the way I like, that's the way I meant !
Add days to a date in javascript
shiftDay = 10
var myDate = new Date();
myDate.setDate(myDate.getUTCDate() + shiftDay)
day = myDate.getUTCDate()
month = myDate.getUTCMonth()*1 + 1
year = myDate.getUTCFullYear()
This code is quite easy:
- shiftDay hold the number of days you want to add, if you need to go backwards you can set it to a negative value.
- myDate is set to the current date
- At the end we will have the data we need in day, month and year.
- getUTCMonth return the current month shifted back by one (January is 0, February is 1 and so on) that's why we add 1. We multiply the value returned by getUTCMonth by one to cast it to integer.