The road to using Mysql
A resource blog for those seeking to utilise Mysql, by Mark Nessfield. Useful tips and links for all who need to utilise their Mysql database to the max.
Contents
- Useful links
- Creating websites with Perl (cgi)
- Calculating distance with Mysql
- Project Euler Q3 with Mysql
- Project Euler Q2 with Mysql
- Project Euler Q1 with Mysql
- A quick look at using dates in Mysql
- Bumper tricks
- Date Issues importing from an Excel csv file
- Quick Perl solution.
- More on Variables
- Making queries more efficient (3) - The importance of indexes
- Change of host
- Making queries more efficient 2) Optimisation of sql.
- Making queries more efficient 1) Locating queries that run slowly
- Finding duplicates
- Powerful string manipulation
- Checking for non-text entries.
- More useful GROUP BY stuff.
- Beautiful code
Categories
Search
XML Feeds
Some of the best links you'll use
Gentle Intro to sql
Mysql Cheat Sheet
Database tutorials
MySql Magazine
Mysql 5.0 Reference Manual
MySQL dba Feed Resource
My Tech blog
dba stuff on users/privilegesTop MySql blogs
Planet Mysql
Jay Pipes
Performance blog
My other sites
My home site
My Blogger blogTag cloud
apache command command line data cleansing dates datetime dba duplicates excel explain gis group by index indexes limit linux locate looping mod optimisation optimization perl project euler promysql regexp related records rownum socket sql string walking subquery twitter union variables
©2010 by admin | Contact | evoCamp skin | Credits: Blog Design | blog software | UK hosts | monetize