MySQL Articles, Tips & Snippets


Setup
MySQL and Java
Prepared statements
Access MySQL on another workstation
Basics
DataGridView
Build MySQL in Windows
Eclipse: elegant MySQL IDE
Find the current row after a sort: snippet
Install 5.0 under Windows Vista
Intro to Java
DataGridView: General purpose column search
Reset ‘root’ password
Tomcat, Eclipse and MySQL
Simple Column Find dialog
Database design
MySQL and PHP
DgvRowFinder class
Database basics
Calling a stored procedure from PHP
DgvRowFinder example caller
What is a database?
Configure MySQL and PHP on the Mac
DataSets
Basics of designing a database
Connect using object oriented syntax: examples
Multi-key relations
Build a database from use case analysis
List child tables
Just-in-time lookup grid
4gb table size limit
PEAR: usage notes
Overview
Alter engine in one or all tables
Populate a dropdown in PHP: example
DataRetriever class
Data modelling 101
Prevent SQL injection attacks
Cache class
Database design with entity-value tables
Configure MySQL and PHP under Windows
Just-in-time DataGridView
Database templates with MySQL
Configure DreamWeaver for PHP
Example caller
Database tutorials on the web
Configure PHP and MySQL for Windows
Set up a MySQL test app in VS 2005
Foreign key: On Delete Set Null
Configure PHP, MySQL, phpMyAdmin for Apache
Create a project
Many:many basics
Other configuration walkthroughs
Add a reference to MySQL
Multi-terabyte databases
WAMP installation packages
Set up the form
MyISAM concurrency
Basics
Write a MySQL connection class
Using an updatable view as a constraint
Callback
TreeViews
When and how to project child rows
Error reporting
Basic TreeView
Why not to use bit columns in MySQL
Query retrieval and display
Optimisation
Common MySQL queries
Session setup
Pipes’s optimisation tips
Comparisons with other RDBMSs
phpMyAdmin
Simplify a query to improve performance
With Oracle and PostgreSQL
Create a stored procedure in phpMyAdmin
View performance
With PostgreSQL
Utility
Security
Date-time
Create Table script
Prevent SQL injection attacks
Milliseconds
MySQL and Visual Studio 2005
Stored routines
Time zone conversion
Call a stored procedure: snippet
Call a stored procedure with an OUT parameter
Manipulating resultsets
Dynamically bind MySqlData.dll: snippet
How to build an IN() list for a stored procedure
Export a query result to a file
Basic query methods
How to call a stored procedure from PHP
Order By RAND()
Assemble query strings
Strings
Migration
Determine if a column value needs to be quoted
Replace first instance only of a substring
Oracle to MySQL
Execute a query, return a DataTable
Search and replace in strings
Miscellaneous
Retrieve a scalar result
Coding style and standards
Execute a non-SELECT command

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