Displaying all posts in the category of 'databases' from 1 to 17 of 17
Free Oracle Database
If you can host it, this free Oracle database can be implemented with PHP. Try it instead of MySQL. Limited to 4Gb of data.
MySQL backups
Useful tutorial on the best way to make backups of your MySQL databases: MySQL backups.
XML MySQL dump
When you want to make backups of your MySQL db's you can usemysqldump. Additionally you can dump it as well-formed XML, which could be handy!
sql for changing a single term
I'm no expert when it comes to sql, so this handy little snippet I recently used to add paragraph tags to my blockquotes in order to validate my lowe [...]
SQL: Limit Rows Returned
For plain SQL queries (i.e. SELECT col1, col2, col3 FROM table), it is possible to use the TOP keyword. By adding "TOP {n}" (where n is an integer va [...]
Multi Select Limit
How to limit the number of items that a user could select in a mulit-select box ... Web Tricks.
MySQL-PHP Restriction Fears Unwarranted
Open-source database vendor MySQL recently initiated some restrictions on the bundling of MySQL libraries with the PHP scripting language ... read t [...]
MySQL shortcuts
Learn some shortcuts when designing your MySQL databases. Article from Database Journal.
UPDATE: MySQL Launches Admin Tool
MySQL teams up with JBoss and ZendThe goal is to give DBAs a way to configure servers, monitor database activity and perform backup and restore tasks [...]
Repairing Database Corruption in MySQL
MySQL has some easy-to-use tools that can easily repair most cases of table corruption, and this article introduces you to these.
HEAP tables in MySQL
We all know accessing data in RAM is a lot quicker than accessing data on disk. So, with this in mind, wouldn't it make sense for MySQL to store as [...]
Referential Integrity in MySQL
Ian Gilfillan briefly explains the concepts of referential integrity, and delves into how MySQL enforces those concepts with its definition of foreig [...]
