Databases SQL

Visual Database Design Tool, Like Visio

Jun 5th

Posted by theMaab in Databases SQL | 829 views

4 comments

I found a great visual database design tool, DBDesigner 4, to help with creating databases. DBDesigner is an Open Source project and is published under GNU GPL, So that is great!
I’ve been using the software for a couple of weeks now and have found it very useful. It has actually helped me More >

First Letters SQL Statement

May 25th

Posted by theMaab in Databases SQL | 184 views

No comments

Here is a neat SQL statement that will return a recordset that counts the number of records that start with a particular letter.
I do have a good use for this that I need to implement. It was created by Matthew Mullenweg, the creator of Wordpress.
First Letters Query

InnoDB MySql

Apr 26th

Posted by theMaab in Databases SQL | 153 views

No comments

Got an email today from Bam4D & he mentioned InnoDB. I did a little google on it, wait, that sounds horrible. So i googled it and found that it is a MySQL table type that can have many advantages over the other types of MySQL tables.
When designing tables in the past, I have More >