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 learn a bit more about indexes …
[Read more...]
Visual Database Design Tool, Like Visio
June 5, 2006 by 4 Comments
First Letters SQL Statement
May 25, 2005 by Leave a Comment
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 …
[Read more...]
InnoDB MySql
April 26, 2005 by Leave a Comment
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 never changed the table type. I have known …
[Read more...]
