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 case command line crossjoin data dictionary dates dba dbi duplicates excel gis group by indexes innodb linux load data looping mod optimisation optimization oracle perl php project euler promysql rand regexp rownum sql sql cookbook subquery union union all variables
©2010 by admin | Contact | evoCamp skin | Credits: Blog Design | blog software | UK hosts | monetize