[Wolves] MySQL

[Simon Fielding]

On Mon, 2010-08-02 at 10:48 +0100, Peter Cannon wrote:
> Hi All
> 
> So who are the MySQL Guru's here? I know Dave Goodwin is but is there 
> anyone else?
> 
> I want to start learning it properly I can do the simple stuff create a 
> db and tables view etc but that's about it. I have a couple of books but 
> they are for V4, anyone interested in answering my 2 Bazzilion idiotic 
> questions potentially off list?
> 
> Question 1
> So my book says "Plan out your db before starting to create it" as a 
> project I have done this 
> http://www.cannon-linux.co.uk/downloads/Stuff/Eset_db_structure.ods does 
> that look OK as a structure?
> 
> Question 2
> Under Licenses and Dates would I need more than one field given that you 
> could have more than one product purchased at different times?
> 
> I know I can do some tutorials, its a bit easy copying out of a book I 
> fancied trying myself.
> 
> Cheers.
> 
> _______________________________________________
> Wolves LUG mailing list
> Homepage: http://www.wolveslug.org.uk/
> Mailing list: Wolves at mailman.lug.org.uk
> Mailing list home: https://mailman.lug.org.uk/mailman/listinfo/wolves

I find MySQL Workbench useful for experimenting with table ideas etc
using EER modelling and diagrams. It will also produce an sql script to
create the database from your model.

See http://wb.mysql.com/ 

Cheers,
Simon