Re: avoiding use of Nulls (was: The <=> operator)

2009-03-15 Thread Don Read
On Sun, 15 Mar 2009 20:19:51 +0100 Claudio Nanni said: > > > > > > This is from an application design perspective, not while you a creating a > > table or constructing an insert statement. > > > If you control your code, after retrieving the values from the database , > you should have somethi

Re: avoiding use of Nulls (was: The <=> operator)

2009-03-15 Thread Claudio Nanni
> > > This is from an application design perspective, not while you a creating a > table or constructing an insert statement. I do not think it is possible to design an application not caring about the data model it relies on. And I am sorry if "people like me who write the code need to add 'IS

Re: avoiding use of Nulls (was: The <=> operator)

2009-03-15 Thread Mattia Merzi
2009/3/14 : [...] > So instead of thinking that I am an idiot, try using your intelligence and > try to understand what I am really talking about! ... instead, try to point us to a chapter of a book or take your time and write a short paper, 'cause my (stupid) intelligence suggests me that (maybe)

Ever-shrinking disk space after repeated DB restores

2009-03-15 Thread René Fournier
It seems MySQL isn't releasing disk space on my laptop after I copy a database from one machine to it. From the server, I'm running something like this: gzip -dc /Backup/Latest/alba2_2009-03-10_00h45m.Tuesday.sql.gz | mysql -h 192.168.0.224 -u root -p alba2 ...every night. And the remaining

SELECT with JOINs

2009-03-15 Thread BobSharp
This links to an ERD diagram that illustrates a MySQL database schema. www.ProBowlUK.co.uk\images\ERD_001.jpg They are MyISAM tables, with no Foreign Key contraints (the fk suffix is not used in the actual database). I need to provide MySQLSELECT statements, with various combinations