MySQL Tips & Snippets

MySQL Setup	Export a query result to a file	Simple Column Find dialog
Basic MySQL setup	Order By RAND()	DgvRowFinder class
Access MySQL on another workstation	Migration	DgvRowFinder example caller
Backward-incompatible changes, 5.0 through 5.6	Basic database export script	DataSets
Build MySQL in Windows	Open source migration tools	Multi-key relations
Change MySQL data directory in *Nix	Oracle to MySQL	Just-in-time lookup grid
Character sets and collations	Recompute auto_increment values on data export	Overview
Install 5.0 under Windows Vista	Miscellaneous	DataRetriever class
Install in Windows	Batch scripts	Cache class
Link MySQL, SQL Server	Coding style and standards	Just-in-time DataGridView
Manual installation in Windows	Format queries	Example caller
Reset ‘root’ password	MySQL documentation lookup	Setup MySQL test app
Connect	MySQL downloads	Create a project
Access denied errors	PREPARE an INSERT containing HTML	Add a reference to MySQL
Connect to MySQL from Excel	Run external command	Set up the form
Connect to MySQL from GUI Tools through a firewall	SQL formatter	Write a MySQL connection class
Connect to MySQL server on a network	MySQL and web apps	TreeViews
Connect to MySQL via SSH	Comparison of HTML editors	Basic TreeView
SSH basics	MySQL and Java	MySQL Comparisons
SSH tunnel to MySQL Server	Basics	MySQL vs Oracle
Workbench: Connect to MySQL on remote host	Get started with Java	MySQL vs PostgreSQL
Workbench: Connect to MySQL remotely	Java intro	MySQL errors
Workbench: Remotely administer MySQL on Amazon EC2	Tomcat, Eclipse and MySQL	Data validation using SIGNAL in Triggers
Workbench: Remotely administer MySQL on W2K	Eclipse: an elegant IDE for MySQL	How to raise an error in MySQL
Database design	NetBeans 6.5.1: not ready for prime time	MySQL client errors
Database basics	Oracle SQL Explorer	MySQL server errors
Basics	MySQL and PHP	Server will not start (Windows)
What is a database?	Setup	Using SIGNAL in MySQL 5.5
Basics of designing a database	Configure MySQL and PHP on the Mac	Optimisation, performance
Build a database from use case analysis	Configure MySQL & PHP for Windows	Difficulties optimising BETWEEN queries
Data modelling 101	Configure DreamWeaver for PHP	If your query is sluggish, look at the keys
Foreign key: On Delete Set Null	Configure PHP and MySQL for Windows	Indexes
Many:many basics	Configure PHP, MySQL, phpMyAdmin for Apache	Optimisation tips from Jay Pipes
MyISAM concurrency	Other configuration walkthroughs	Optimise geospatial queries
When and how to project child rows	WAMP installation packages	Optimise InnoDB table counts
Alter engine in one or all tables	Basics	Optimise Order By with Limit
Consolidate duplicates	Call a stored procedure from PHP	Optimise rank data
Database and table size size limits	Call a stored procedure from PHP with an OUT parameter	Optimise subqueries
Database templates with MySQL	Callback	Performance_schema
Database tutorials on the web	Error reporting	Simplify a query to improve performance
FIFO queue	Escaping text	Using the query_cache
Multi-terabyte databases	Multi-queries	View performance
MySQL and scaling	Pagination	Queries
Normalisation: fine points	Populate a dropdown in PHP: example	Common MySQL queries
Point-in-time architecture & audit trails	Populate one dropdown from another	Basics of PREPARE
Round-robin database	Query retrieval and display	Divide and conquer
Using an updatable view as a constraint	Session setup	Emulate materialised views
Why not to use bit columns in MySQL	Insert PHP array into MySQL table	Replication
Workarounds for absence of CHECK CONSTRAINT	List child tables	Dual master replication
Entity-attribute-value model	PEAR: usage notes	Reports
EAV designs and queries	Prevent SQL injection attacks	Column header for a week
OLAP with MySQL	Show resultset as a bar graph	Open source report writers: comparison
Date-time	phpMyAdmin	Security
Epochs	Install	Prevent SQL injection attacks
Fiscal week of a date	Create a stored procedure in phpMyAdmin	Security in the real world
Milliseconds	Snippets	Stored routines
Time zone conversion	Connect using object oriented syntax: examples	Call stored procedure with OUT parameter
DB Admin	Generate query for names linked to attributes	Excellent tutorial on stored routines
Crashes	Snippet plugin for MySQL Workbench	How to build an IN() list for a stored procedure
Innotop: Monitor InnoDB	Utility	How to call a stored procedure from PHP
MySQL dump script	Create Table script	Nest cursors
MySQLdump and consistency	MySQL and Windows	Slowness of MySQL stored procedures
Optimise MySQL memory usage	Getting started with MySQL under Windows	Workaround for absence of dynamic cursors
Perl script to compare database structures	Connect to MySQL from Excel	Strings
GUI Tools	The notorious Windows backslash	Replace first instance only of a substring
OS-based MySQL GUIs	VB/ADO connection string	Search and replace in strings
HeidiSQL	MySQL and Visual Studio 2005	The Coding Corner
MySQL Query Browser	Call a stored procedure: snippet	Audit trails in MySQL, Part 1
Home	Dynamically bind MySqlData.dll: snippet	Audit trails in MySQL, Part 2
Multi-query scripts in Query Browser	Basic query methods	Call a stored procedure with an OUT parameter
Web-based MySQL GUIs	Assemble query strings	Divide and conquer
phpMyAdmin	Determine if a column value needs to be quoted	Protect against SQL injection attacks
TheUsual	Execute a query, return a DataTable	Take the drudgery out of writing crosstabs
InnoDB	Retrieve a scalar result	Top N per group
Calculate InnoDB log file size	Execute a non-SELECT command	Triggers
Changing tables from MyISAM to InnoDB	Prepared statements	Manage INSERT failures
InnoDB handling of transaction errors	DataGridView	Update table B on Insert into table A
Optimising MySQL & InnoDB performance	Find the current row after a sort: snippet	Views
Manipulating resultsets	DataGridView: column search	View performance

MySQL Articles, Tips & Snippets

from artfulsoftware.com