At 11:45 AM 6/14/2011, Johan De Meersman wrote:
----- Original Message -----
> From: "Bennett Haselton" <benn...@peacefire.org>
>
> modifications. (For example, the question I asked earlier about
> whether you can declare extra space at the end of each row that is
> "reserved for future columns".)
That question I can answer: you can't "reserve" space, but if you
know what kind of rows you'll want to add later you can pre-add them
(and incur the accompanying storage cost), and simply rename them
appropriately later.
Thanks. It would be more flexible if I could declare, say, 50 bytes,
and decide later if I wanted to use them for a datetime, a char(n),
or an int, but this is still helpful :)
Do you happen to know the answer to my other problem -- if I have
TEXT and BLOB columns but all my other columns are fixed-length, can
I still get the benefit of faster lookups resulting from fixed-length
rows, if each row just contains a fixed-length reference to the
actual TEXT or BLOB data which is stored elsewhere?
-Bennett
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org