List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:February 5 2000 8:29pm
Subject:Re: help...
View as plain text  
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
Thread
MySQL Solaris 2.6 and RedHat LinuxPPC 1999Kevin Smith5 Feb
  • Re: MySQL Solaris 2.6 and RedHat LinuxPPC 1999Paul DuBois5 Feb
  • help...d e l   d h a n o a5 Feb
    • Re: help...Paul DuBois5 Feb
  • Re: MySQL Solaris 2.6 and RedHat LinuxPPC 1999sinisa6 Feb
Re: help...Ed Carp6 Feb