Main Content
MySQL - an FAQ Archive Eleven recent articles on MySQL ... Flashbulb moments - facts that clarify the "what" and "how" of MySQLCopying databases and tables Saving a result set locally for use in a spreadsheet Setting up and running master and slave servers (replication) Finding Orphan (unconnected) records in a database How to translate a requirement to a table design Complex select example - UNION, HAVING, GROUP etc Exact, like and fuzzy matching of criteria A PHP tool for ad-hoc MySQL queries Joining a table to itself Summing or averaging a column for each unique value in another column and some old favourites: What to do when you have a running system and realise that the design needs an overhaul The difference between a JOIN and a LEFT JOIN Uploading, storing and retrieving images in a BLOG Writing joins of more than two tables How to design and implement a many-to-many mapping When to break the rules of normalisation The vital difference between "Empty" and "Don't Know" Optimising Selects Using old client programs (4.0 and prior) on new servers (4.1 and later) Other MySQL nuggets
Some other articles S159 - MySQL 5 and PHP 5 MySQL, MySQLi, PDO or something else - how best to talk to databases from PHP PHP4 v PHP5 - Object Model Difference Diagrams to show you how - Tomcat, Java, PHP Upgrade from PHP 4 to PHP 5 - the TRY issue Connecting to MySQL 5 from PHP on Mac OSX Leopard What software version do we teach? MySQL - Password security (authentication protocol) This article MySQL - a score of things to remember mysql_connect or mysql_pconnect in PHP? S157 - More MySQL commands Extracting data from backups to restore selected rows from MySQL tables SQL - Data v Metadata, and the various stages of data selection Databases - why data is split into separate tables, and how to join them Removing duplicates from a MySQL table Optimising and caching your MySQL enquiries Counting rows in joined MySQL tables Relating tables with joins in MySQL MySQL - efficiency and other topics Grouping rows for a summary report - MySQL and PHP MySQL - looking for records in one table that do NOT correspond to records in another table Ruby, Perl, Linux, MySQL - some training notes Finding words and work boundaries (MySQL, Perl, PHP) Joining MySQL tables revisited - finding nonmatching records, etc MySQL joins revisited Outputting numbers as words - MySQL with Perl or PHP MySQL - the order of clauses and the order of actions Helicopter views and tartans Key facts - SQL and MySQL Saving a MySQL query results to your local disc for Excel Giving the researcher power over database analysis Combining similar rows from a MySQL database select An occasional chance, and reducing data to manageable levels This article MySQL - JOIN or WHERE to link tables correctly? SELECT in MySQL - choosing the rows you want MySQL - a score of things to remember Matching in MySQL Getting a list of unique values from a MySQL column MySQL - Optimising Selects MySQL - LEFT JOIN and RIGHT JOIN, INNER JOIN and OUTER JOIN S154 - Designing an SQL Database System FileMaker Day to Unix Time conversion Databases - when to treat the rules as guidelines Blowing our own trumpet - MySQL resources SQL - Data v Metadata, and the various stages of data selection Delegate Question - defining MySQL table relationships as you create the tables Images in a database? How big is a database? (MySQL) MySQL - licensing issues, even with using the name What a difference a MySQL Index made More HowTo diagrams - MySQL, Tomcat and Java Database design for a shopping application (MySQL) MySQL - table design and initial testing example Code quality counts Display an image from a MySQL database in a web page via PHP Databases needn't be frightening, hard or expensive Database design - get it right from first principles This article MySQL - a score of things to remember Oops - I got my initial database design wrong Binary Large Objects or bars MySQL - Pivot tables S153 - Sourcing, Running and Configuring MySQL Starting MySQL. ERROR! The server quit without updating PID file - how we fixed it. Fixing damaged MySQL tables - Error 1712 and Error 2013 Checking MySQL database backups have worked (not failed) Cant connect to local MySQL server through socket /tmp/mysql.sock Securing MySQL on a production server Potted MySQL installation Which version of MySQL am I running? Monitoring and Tuning your MySQL installation MySQL - licensing issues, even with using the name Summary of MySQL installation on a Linux system More HowTo diagrams - MySQL, Tomcat and Java Apache httpd, MySQL, PHP - installation procedure Some sideways thoughts on the news MySQL - Password security (authentication protocol) mysqldump and mysqlrestore Apache httpd , browser, MySQL and MySQL client downloads Browser -> httpd -> Tomcat -> MySQL. Restarting. Key facts - SQL and MySQL MySQL permissions and privileges This article Which MySQL server am I using? Symbolic links and hard links Current MySQL and PHP paths and upgrades S152 - SQL Primer as Used in MySQL Which database should I use? MySQL v SQLite Databases - why data is split into separate tables, and how to join them INSERT, DELETE, REPLACE and UPDATE - changing the content of SQL tables How do I query a database (MySQL)? Key facts - SQL and MySQL This article SELECT in MySQL - choosing the rows you want MySQL - a score of things to remember NULL in MySQL MySQL - LEFT JOIN and RIGHT JOIN, INNER JOIN and OUTER JOIN S151 - Introduction to SQL and MySQL Storing your intermediate data - what format should you you choose? Files or Databases? MySQL, SQLite, or Oracle? Factory methods and SqLite in use in a Python teaching example Extra MySQL course dates (2 day course, UK) The future of MySQL Oracle take over Sun who had taken over MySQL The LAMP Cookbook - Linux, Apache, MySQL, PHP / Perl Databases needn't be frightening, hard or expensive Testing you Perl / PHP / MySQL / Tcl knowledge Key facts - SQL and MySQL This article Database or Progamming - which to learn first? Central London Courses - Perl, PHP, Python, Tcl, MySQL Worthwhile Present and future MySQL MySQL - nuggets P308 - Using SQL Databases from Perl Perl - database access - DBD, DBI and DBIx modules The future of MySQL Checking the database connection manually Ruby, Perl, Linux, MySQL - some training notes Hiding a MySQL database behind a web page Object Relation Mapping (ORM) Answering ALL the delegate's Perl questions Using a MySQL database from Perl This article J811 - JDBC - Relational Database Access Java Beans, tag libraries and JSPs - what and why. MySQL and Java - connectivity past, present, and future thoughts Bean Classes in Java and Java Database Connections This article H113 - Using MySQL Databases in PHP Pages Moving from mysql to mysqli - simple worked example What FGW passengers want to talk about / and PHP programming to find out MySQL, MySQLi, PDO or something else - how best to talk to databases from PHP How to display information from a database within a web page An example of an injection attack using Javascript The future of MySQL MySQL stored procedures / their use on the web from PHP Using print_r in PHP to explore mysql database requests Helping new arrivals find out about source code examples Grouping rows for a summary report - MySQL and PHP Setting up a MySQL database from PHP Keeping PHP code in database and running it Uploading to a MySQL database through PHP - examples and common questions Dates, times, clickable diarys in PHP What is an SQL injection attack? Display an image from a MySQL database in a web page via PHP Paging through hundreds of entries Viewing images held in a MySQL database via PHP Database design - get it right from first principles Checking for MySQL errors Saving a MySQL query results to your local disc for Excel Giving the researcher power over database analysis This article mysql_connect or mysql_pconnect in PHP?