MySQL Articles, Tips & Snippets

from artfulsoftware.com

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

Do you have an item or correction to contribute?

Back to the home of Get It Done With MySQL 5&6