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