create table from describe table?

#1

Can a table be created using data from the DESCRIBE TABLE command?

#2

SpreadTooThin wrote:

Quote:

Can a table be created using data from the DESCRIBE TABLE command?

You can create table with the information which is near what the original
table was.

Other methods to know more about the table:
SHOW CREATE TABLE
SHOW INDEX IN

--

//Aho

#3

On Wed, 01 Feb 2012 10:47:49 -0800, SpreadTooThin wrote:

Quote:

Can a table be created using data from the DESCRIBE TABLE command?

Everything that you can do is described in the relevant manual.

eg:

http://dev.mysql.com/doc/refman/5.1/en/index.html

which, when you find the one relevant to your specific variant of sql,
will be much more reliable than asking here.

Rgds

Denis McMahon

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

create table from describe table?

comp.databases.mysql comp.databases.mysql

create table from describe table? - 02-01-2012 , 12:47 PM

Re: create table from describe table? - 02-01-2012 , 02:12 PM

Re: create table from describe table? - 02-01-2012 , 04:32 PM