MySQL Articles, Tips & Snippets


Setup
Comparison of HTML editors
DgvRowFinder class
Access MySQL on another workstation
MySQL and Java
DgvRowFinder example caller
Build MySQL in Windows
Eclipse: an elegant IDE for MySQL
DataSets
Change MySQL data directory in *Nix
NetBeans 6.5.1: not ready for prime time
Multi-key relations
Install 5.0 under Windows Vista
Oracle SQL Explorer
Just-in-time lookup grid
Link MySQL, SQL Server
Basics
Overview
Manual installation in Windows
Intro to Java
DataRetriever class
Reset ‘root’ password
Tomcat, Eclipse and MySQL
Cache class
Database design
MySQL and PHP
Just-in-time DataGridView
Database basics
Configure MySQL and PHP on the Mac
Example caller
Basics
List child tables
Setup MySQL test app
What is a database?
PEAR: usage notes
Create a project
Basics of designing a database
Populate a dropdown in PHP: example
Add a reference to MySQL
Build a database from use case analysis
Prevent SQL injection attacks
Set up the form
Data modelling 101
Configure MySQL & PHP for Windows
Write a MySQL connection class
Foreign key: On Delete Set Null
Configure DreamWeaver for PHP
TreeViews
Many:many basics
Configure PHP and MySQL for Windows
Basic TreeView
MyISAM concurrency
Configure PHP, MySQL, phpMyAdmin for Apache
MySQL Comparisons
When and how to project child rows
Other configuration walkthroughs
MySQL vs Oracle
4gb table size limit
WAMP installation packages
MySQL vs PostgreSQL
Alter engine in one or all tables
Basics
Optimisation
Database templates with MySQL
Call a stored procedure from PHP
Difficulties optimising BETWEEN queries
Database tutorials on the web
Call a stored procedure from PHP with an OUT parameter
If your query is sluggish, look at the keys
FIFO queue
Callback
Optimisation tips from Jay Pipes
Multi-terabyte databases
Error reporting
Optimise geospatial queries
Normalisation: fine points
Escaping text
Optimise Order By with Limit
Point-in-time architecture & audit trails
Multi-queries
Optimise rank data
Round-robin database
Query retrieval and display
Simplify a query to improve performance
Using an updatable view as a constraint
Session setup
Using the query_cache
Why not to use bit columns in MySQL
phpMyAdmin
View performance
Entity-attribute-value model
Install
Replication
EAV designs and queries
Create a stored procedure in phpMyAdmin
Dual master replication
Common MySQL queries
Snippets
Security
MySQL and scaling
Connect using object oriented syntax: examples
Prevent SQL injection attacks
Workarounds for absence of CHECK CONSTRAINT
Generate query for names linked to attributes
Stored routines
Date-time
Utility
Call stored procedure with OUT parameter
Milliseconds
Create Table script
Excellent tutorial on stored routines
Time zone conversion
MySQL and Windows
How to build an IN() list for a stored procedure
DB Admin
Getting started with MySQL under Windows
How to call a stored procedure from PHP
Innotop: Monitor InnoDB
Connect to MySQL from Excel
Nest cursors
Manipulating resultsets
The notorious Windows backslash
Slowness of MySQL stored procedures
Export a query result to a file
VB/ADO connection string
Strings
Order By RAND()
MySQL and Visual Studio 2005
Replace first instance only of a substring
Migration
Call a stored procedure: snippet
Search and replace in strings
Basic database export script
Dynamically bind MySqlData.dll: snippet
The Coding Corner
Oracle to MySQL
Basic query methods
Audit trails in MySQL, Part 1
Recompute auto_increment values on data export
Assemble query strings
Audit trails in MySQL, Part 2
Miscellaneous
Determine if a column value needs to be quoted
Call a stored procedure with an OUT parameter
Batch scripts
Execute a query, return a DataTable
Divide and conquer
Coding style and standards
Retrieve a scalar result
Protect against SQL injection attacks
Format queries
Execute a non-SELECT command
Take the drudgery out of writing crosstabs
MySQL downloads
Prepared statements
Top N per group
PREPARE an INSERT containing HTML
DataGridView
Tools
Run external command
Find the current row after a sort: snippet
Multi-query scripts in Query Browser
SQL formatter
DataGridView: column search
Views
MySQL and web apps
Simple Column Find dialog
View performance

Do you have an item or correction to contribute?   Back to the home of Get It Done With MySQL 5&6