MySQL Articles, Tips & Snippets

from artfulsoftware.com

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

Do you have an item or correction to contribute?

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