Tags
adsense animation apache apple auto future date blog coding compsci css diy flash forum game hard drive internet explorer iphone itunes java javascript link linux mac mysql netbeans network Photography photoshop php Plain Text Custom Post Type plugin Programming prototype python reliti robot scratch teaching tips twitter ubuntu usb video web design wordpress youtube-
Popular This Week
- Difference in Hub, Switch, Bridge, & Router
- JavaScript Error ‘expected identifier, string or number’ in IE
- Multiple cases for switch construct
- Plugins for inserting JS and CSS into posts
- PHP: A function to return the first n words from a string
- PHP: Benchmarking echo vs. print vs. printf
- DIY: Make Your Own Ethernet Loopback Cable
- How to create a wine glass in Blender
- How to get a screen shot from an iPhone
- List functions disabled in PHP
My Other Sites
Tag Archives: mysql
How to change the MySQL password in MAMP
Reinstalled MAMP last week because the version I was using didn’t have PHP 5.3 which I needed for a project I’m working on. Had to do some Googling to find the default password for MySQL and how to change. First, … Continue reading
Posted in Computers & Internet
Tagged apache, apple, database, mac, mamp, mysql, php
Leave a comment
Grouping MySQL query by date
Working on a statistics plugin I needed a way to group records by the day. Turns out it’s remarkably easy. If you just want to group by year and month take off the DAY() part. This would also be a … Continue reading