MySQL

This page is a placeholder a MySQL page showing essentially a TOC of all MySQL pages.

I’ll be filling these in over time. Please use the comment section to let me any comments or suggestions – thanks!

Basics and Background

Basics and Background – DML

  • Insert Examples
  • Update Examples
  • Comments and Headers

Creating Users and Permissions

  • ‘Super Users’
  • using special commands
  • using base tables
  • reload cache
  • 4.0 -v- 5.0?

Advanced Query Techniques

  • Join examples and syntax
  • multi table updates
  • Insert on dup key update example
  • using explain to look at indexes
  • indexing strategies

Stored Procedures and Other Advanced Techniques

Logging and Alerts

  • Creation of logging stored procedure
  • Creation of notification tables
  • script to do notifications based on levels

What to do when things get BIG

Backup / Restore

Replication

Dealing with External Data

Advanced Techniques and Design Patterns

When to move on to some other database.

  • http://www.kbedell.com/2009/03/07/mysql-integer-sizes-and-ranges-of-values-how-to-create/ Kevin Bedell on Internet Tech – MySQL Integer sizes and ranges of values – How-To Create Table example

    [...] MySQL Programming [...]

    Current score: 0
  • http://www.kbedell.com/2009/03/07/how-to-mysql-example-showing-default-values-null-values-and-comments/ Kevin Bedell on Internet Tech – How-To MySQL CREATE TABLE Example showing default values, NULL values and comments

    [...] MySQL Programming [...]

    Current score: 0
  • http://www.kbedell.com/2009/03/07/basic-how-to-example-of-a-mysql-create-table-command/ Kevin Bedell on Internet Tech – Basic How-To Example of a MySQL CREATE TABLE command

    [...] MySQL Programming [...]

    Current score: 0
  • http://www.kbedell.com/2009/03/07/how-to-create-a-timestampdatetime-column-in-mysql-to-automatically-be-set-with-the-current-time/ Kevin Bedell on Internet Tech – How to create a TIMESTAMP/DATETIME column in MySQL to automatically be set with the current time

    [...] MySQL Programming [...]

    Current score: 0
  • Nikeiiim2009

    Not sufficient, Not propoer. lost so much important topic Finally make me angry and hopeless

    Current score: 0
  • TLDC TLDC

    good

    Current score: 0