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
cgi collation csv data analysis dates datetime duplicates excel group by html index instr joins load data infile locate mod multiple index mysql daemon optimisation order by performance perl postcodes project euler promysql random regexp slow query log socket sql variable storage engine tips twitter variables
©2010 by admin | Contact | evoCamp skin | Credits: Blog Design | blog software | UK hosts | monetize