List:General Discussion« Previous MessageNext Message »
From:Daniel da Veiga Date:June 21 2006 2:40pm
Subject:Re: Just need script for creating tables
View as plain text  
On 6/21/06, Xiaobo Chen <xiaobo@stripped> wrote:
> Hi, all
>
> If I use 'mysqldump', I will get the script to create the tables and those
> 'insert' statements to insert the data.
>
> I am wondering if I just want the first part, i.e, the script to create
> the table, is there a command for this end? (I could copy & paste the part
> from 'mysqldump' but it's not what I want to do.)
>

Read the reference manual for the mysqldump program, you can check the
syntax to do that:
http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html

Specially for the --no-data append.


-- 
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------
Thread
Just need script for creating tablesXiaobo Chen21 Jun
  • Re: Just need script for creating tablesDaniel da Veiga21 Jun
  • RE: Just need script for creating tablesPeter Lauri21 Jun
    • query slowluiz Rafael21 Jun
      • Re: query slowJay Pipes21 Jun
        • Re: query slowEugene Kosov21 Jun
      • Re: query slowEugene Kosov21 Jun
    • Re: query slowluiz Rafael21 Jun
    • reclaim disk spaceluiz Rafael21 Jun
      • Re: reclaim disk spaceDan Buettner21 Jun
      • Re: reclaim disk spaceDan Nelson21 Jun
    • Re: query slowluiz Rafael25 Jun
  • Re: Just need script for creating tablesMartin Jespersen21 Jun
RE: reclaim disk spaceGeorge Law21 Jun