At 20:43 -0600 2/26/03, Paul DuBois wrote:
At 21:32 -0500 2/26/03, Jianping Zhu wrote:
I have a guest book which have three fields.
user name
email
comments
I want to mysql to store the information, but commnet maybe very long, is
there a better way to handle it instead of set a varchar(2000) or
I have a guest book which have three fields.
user name
email
comments
I want to mysql to store the information, but commnet maybe very long, is
there a better way to handle it instead of set a varchar(2000) or more for
a field comment in the table?
Thanks
At 21:32 -0500 2/26/03, Jianping Zhu wrote:
I have a guest book which have three fields.
user name
email
comments
I want to mysql to store the information, but commnet maybe very long, is
there a better way to handle it instead of set a varchar(2000) or more for
a field comment in the table?
Thanks for response.
what will happen if commnet size is more that 2000?
J.P.
On Wed, 26 Feb 2003, Paul DuBois wrote:
At 21:32 -0500 2/26/03, Jianping Zhu wrote:
I have a guest book which have three fields.
user name
email
comments
I want to mysql to store the information, but commnet
At 23:10 -0500 2/26/03, Jianping Zhu wrote:
Thanks for response.
what will happen if commnet size is more that 2000?
Use whichever one of the TEXT column types can hold as much as you
want to allow as your maximum comment size. The MySQL manual indicates
the maximum length for TINYTEXT, TEXT,
Hi,
Is it possible to put comments against a table and column that are persistent; so that
when you run 'explain' or 'describe', these comments will display.
Rob
Hi,
Is it possible to put comments against a table and column that are persistent;
so that when you run 'explain' or 'describe', these comments will display.
Tables in MySQL (version 3.23 at least - not sure about 3.22) do actually
have a comment 'field' built in. You specify your initial