mySQL
We now have Package Deals to create and maintain your website for you.
(includes special prices for community groups and hobby clubs)
- Databases and Null
Null has a different meaning for databases to what it does in programs.
- mysql and mysqli - Connect
A look at these two alternate interfaces and how to use them to connect to the database.
- mysql and mysqli - Query
How these two interfaces differ in how you can use them to run database queries.
- mySQL enum Fields
What are the advantages/disadvantages of enum and what are the alternatives.
- Why Normalise a Database
A look at some common problems people have with their database that would not have happened if they normalised their data first.
- Primary Keys
There is usually an existing unique field that is the best choice for the primary key.
- Receipt Numbering using Autoincrement
A look at one of the rare situations where autoincrementing makes things easier.
- Float or Numeric
While the float data type may be the only option available to you in your programming language, the numeric data type may be more appropriate in the database.
- Defining Tables
Reasons for writing a script to create the tables that you need in your database.
- Images and Databases
Should you put your images inside or outside your database?- Storing Images in the Database
Some examples of why most applications should store the images in the database.
- Storing Images in the Database
- One Field With Multiple Values
One thing newbies often get wrong in their database design is how they handle multiple values in a single field.
- Sorting Databases
The data in your database is not sorted in any particular order.
- GROUP BY and Fields Returned
You need to be careful how you define the fields you want to retrieve when grouping data.
- To Index or not to Index
Some indexes will speed your database up while others will slow it down.
- Storing Passwords in Databases
A look at the various options available to secure stored passwords so that you can select the alternative most appropriate to your site's requirements.
- Referential Integrity
Make your code simpler by letting the database do what it is designed to do.
- Gaps in Pseudokeys
Once you start deleting records your autoincrement pseudokeys will no longer be sequential. Don't make the mistake of trying to fill the gaps.
- "Learning MySQL"
A review of the only book on MySQL that most people will ever need.
- "mySQL Cookbook"
A huge problem solving resource for those who are already familiar with mySQL.
- "mySQL pocket reference"
The almost perfect reference to mySQL.
- "High Performance mySQL"
This book covers all the aspects of mySQL databases except for the basic SQL commands covered by the beginners books.
- "Refactoring SQL Applications"
Getting your SQL to work better can have a dramatic affect on your script.
- "A Sane Approach to Database Design"
The book for anyone who needs to design a database.
- "SQL in a Nutshell"
A complete desktop reference to SQL including four popular implementations.
- "SQL Antipatterns"
Lots of common mistakes in database design and use along with ways to fix them.
If you have a different PHP or mySQL question please ask Felgall.
Related Articles
Copyright © Felgall Pty Ltd