[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Edlug Archive Mar 2004 ]

Re: [edlug] MySQL copy table structure

On Tue, 2 Mar 2004, Catriona & Anand wrote:

> I am new to MySQL and am picking up the syntax as I go along. Right now, I
> need to create a table with the same structure as an existing one. The manual
> does not seem to offer a way to do this. In dBase there was a "COPY
> STRUCTURE" command, but I can't find an equivalent.

I would highly recommend PHPMyAdmin - it provides a web interface to
MySQL. Ideal for situations such as you describe where you might not want
to learn some of the more obscure details of SQL.

Alistair Riddell - BOFH
IT Manager, George Watson's College, Edinburgh
Tel: +44 131 446 6070    Fax: +44 131 446 6090
Microsoft - because god hates us
You can find the EdLUG mailing list FAQ list at:

This archive is kept by wibble@morpheux.org.DONTSPAMME