Database Structure - Comments?
View Single Post
10-30-2007, 07:34 PM
Join Date: Sep 2007
Originally Posted by
This point isn't to do with your structure per se, but it's an important aspect of good database design. If you're using MySQL 5 you can setup relationships with cascades so that you can automatically update/delete related records. For example, with cascade deletes you can delete an artist, and MySQL will automatically delete the related records from the songs and albums table.
And offtopic, that can be easily done via SQLYog. :)
I completely like that feature and hopefully is going to make a better use next time.
View Public Profile
Send a private message to Haris
Find More Posts by Haris