At 2:32 PM -0800 2000-02-05, d e l d h a n o a wrote:
>I made the following table about 4 months ago:
>
>mysql> describe comments;
>+-----------+------------------+------+-----+---------+-------+
>| Field | Type | Null | Key | Default | Extra |
>+-----------+------------------+------+-----+---------+-------+
>| name | varchar(64) | YES | | NULL | |
>| email | varchar(64) | YES | | NULL | |
>| comment | text | YES | | NULL | |
>| category | int(11) | YES | | NULL | |
>| thedate | timestamp(10) | YES | | NULL | |
>| timestamp | int(10) unsigned | YES | | NULL | |
>+-----------+------------------+------+-----+---------+-------+
>6 rows in set (0.01 sec)
>
>So now I want to remake that table again but I forgot how I made that last
>row:
>
>CREATE TABLE comments (
>name VARCHAR(100),
>email VARCHAR(100),
>comment text,
>thread INT(11),
>thedate timestamp(10),
>timestamp ***whatgoeshere?***));
>
>
>so what goes in the "***whatgoeshere?***" part?
Run this command and it will show you the CREATE TABLE statement
you need:
mysqldump --no-data db_name comments
--
Paul DuBois, paul@stripped
