[SWLUG] MySQL client on W2K

[Peter Bradley]

Ysgrifennodd Terry John:

>>Use InnoDB tables for transactions.
> 
> I'd seen that long word as I've been looking around. No idea what it is though.
> 
> 
>>MySQLAdministrator + MySQL Query Browser are the best GUI front ends in
>>my opinion (on both Windows and Linux).  One tool I've really enjoyed
>>(but failed to manage to install on Linux :( I'm afraid) is DBDesigner4.
>> It allows you to develop your schema graphically and then generates
>>the DML for you, if you want.
> 
> 
> Are they available from mysql.com or are they commercial? Part of what I'm trying to acheive is to see how far I can go to just using open source stuff. Only for my own amusement, but if I can do something worthwhile then I can make it available for others, mind you that doesn't happen too often :-)
>  
> Hwyl
> Terry

Terry,

InnoDB is just a table type - an alternative to MyISAM, which is usually 
the default.  InnoDB, though, supports transactions whereas MyISAM does 
not.  So I change the default to InnoDB

MySQLAdministrator and MySQL Query Browser are both GPL.

Hwyl i chdithau hefyd :)

Peter