select * from repligard where guid='a32505d001377d98d410c8d5ae767d62'; show fields from snippetdir;
Piotras
mysql> describe repligard; +-----------+----------------------+------+-----+---------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+----------------------+------+-----+---------------------+----------------+ | autoid | smallint(5) unsigned | | PRI | NULL | auto_increment | | id | smallint(5) unsigned | | | 0 | | | timestamp | datetime | | | 0000-00-00 00:00:00 | | | updated | datetime | | | 0000-00-00 00:00:00 | | | realm | varchar(32) | | | | | | tag | varchar(32) | | MUL | | | | sitegroup | int(11) | | | 0 | | +-----------+----------------------+------+-----+---------------------+----------------+ 7 rows in set (0.00 sec)
it's an old structure ! Can I DROP and CREATE table + 'repligard -m' or must I use ALTER TABLE RENAME COLUMNS.... ?
benoit.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
