--- Jeff Lacki [EMAIL PROTECTED] wrote:
+-+--+--+-++---+
| Field | Type | Null | Key |
Default| Extra |
+-+--+--+-++---+
| id | bigint(20) | |
David Blomstrom wrote:
I just thought of a possible solution. Instead of
listing all the phyla, orders, classes, families,
genera and species in one big table, create separate
tables for each taxonomic level.
Each taxon would then have two parents. the genus Sus'
(pigs) parents would be both
Hi,
I try to convert a varchar to a char, but it doesn't seems to work.
show create table sessions;
CREATE TABLE `sessions` (
`id` varchar(32) NOT NULL default '',
`user_id` int(6) NOT NULL default '0',
`ip` varchar(8) NOT NULL default '0',
`lastseen` timestamp NOT NULL default
Pooly wrote:
Hi,
I try to convert a varchar to a char, but it doesn't seems to work.
From the manual: ...all CHAR columns longer than three characters are
changed to VARCHAR columns.
URL: http://dev.mysql.com/doc/mysql/en/silent-column-changes.html
--
Roger
--
MySQL General Mailing
Damnit !
Thanks for pointing it, I forgot these things.
But it's a bit more subtle :
If any column in a table has a variable length, the entire row becomes
variable-length as a result. Therefore, if a table contains any
variable-length columns (VARCHAR, TEXT, or BLOB), all CHAR columns
longer
On Sat, Aug 13, 2005 at 04:01:38PM +0100, Pooly wrote:
ALTER TABLE sessions MODIFY ip char(8) NOT NULL DEFAULT '0';
ALTER TABLE sessions MODIFY id char(32) NOT NULL DEFAULT '';
Hello,
Since you have two varchar columns, I don't think there's any way to
convert them both to char without
On Sat, Aug 13, 2005 at 05:37:56PM +0100, Pooly wrote:
Damnit !
Thanks for pointing it, I forgot these things.
But it's a bit more subtle :
[snip]
Bah, should have waited another 5 minutes before I bothered posting my
last long-winded ramble ;)
ALTER TABLE sessions MODIFY id char(32) NOT
At 16:27 -0400 8/12/05, [EMAIL PROTECTED] wrote:
To the powers that be: Can we get a MySql GIS/spatial list?? This
is going to be a very popular area (actually it is already).
I am trying to use the Spatial extensions to MySql. To be honest
PostGIS has many more features, but MySql is my
Yeah, for example the last statement ALTER, ..., ...
is the only way sometimes to make things working.
anyway, it's worth knowing it.
2005/8/13, Chris Elsworth [EMAIL PROTECTED]:
On Sat, Aug 13, 2005 at 05:37:56PM +0100, Pooly wrote:
Damnit !
Thanks for pointing it, I forgot these
What are the pros and cons in resizing the MAX index size, from 1024.
- javabuddy
People are conversing... without posting their email or filling up their mail
box. ~~1123957730975~~
Paul DuBois wrote:
At 16:27 -0400 8/12/05, [EMAIL PROTECTED] wrote:
This is a big issue. Will this be the same in version 5? Or will
the SRIDs actually be used? I would like to just represent
everything in lat/lon, not on a planar surface. Now, if the SRIDs
are used in MySql 5,
Hello,
I have a html page with 70+ form fields some like 40 fields are only used
for entering quantity numbers…
Don’t want to do Mysql table with 70 fields…
Is it a good idea to put this 50 fields of the form fields into a single
text mysql field?
Somehow process it with php before, put
Need more information... what exactly is Our older version, and
what exactly is the newest version of MySql, without this it's hard
to know what issues you may be facing... I imagine you are on 4.0.n
for the old and 4.1.n for the new... but we can't really tell from
the information you
Andras,
Is it a good idea to put this 50 fields of the form fields into
a single
text mysql field?
Somehow process it with php before, put inside of some kind of xml
structure?
Nothing wrong with 70 columns unless there are interdependencies
/or groupings
amongst the 70 values that
14 matches
Mail list logo