On 2010-08-31 15:17, Ananda Kumar wrote:
> desc suomi_contacts2;
mysql> desc suomi_contacts2;
+------------------+------------------+------+-----+-------------------+-----------------------------+
| Field | Type | Null | Key | Default |
Extra |
+------------------+------------------+------+-----+-------------------+-----------------------------+
| name | text | YES | | NULL |
|
| firm | text | YES | | NULL |
|
| title | text | YES | | NULL |
|
| phone | text | YES | | NULL |
|
| phone_std | text | YES | | NULL |
|
| fax | text | YES | | NULL |
|
| mail | text | YES | | NULL |
|
| standard_mail | text | YES | | NULL |
|
| comment | text | YES | | NULL |
|
| status | text | YES | | NULL |
|
| url | text | YES | | NULL |
|
| businesscategory | text | YES | | NULL |
|
| address | text | YES | | NULL |
|
| addon | text | YES | | NULL |
|
| givenname | text | YES | | NULL |
|
| history | longtext | YES | | NULL |
|
| favorit | text | YES | | NULL |
|
| last_update | timestamp | NO | | CURRENT_TIMESTAMP |
on update CURRENT_TIMESTAMP |
| task_link | int(11) | YES | | NULL |
|
| counter | int(10) unsigned | NO | PRI | NULL |
auto_increment |
+------------------+------------------+------+-----+-------------------+-----------------------------+
20 rows in set (0.00 sec)
mysql>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[email protected]
