Re: How to put table definition into another table using SQL?

[mos]

At 11:23 AM 5/11/2010, Carlos Proal wrote:

Hi Mike, you need to query the information_schema schema/database that 
contains the database dictionary.
You can read the manual or a beautiful diagram here: 
http://www.xcdsql.org/Misc/MySQL_INFORMATION_SCHEMA.html


Have a nice day
Carlos Proal


Carlos,
 Perfect! Thanks.

Mike



On 5/11/2010 11:06 AM, mos wrote:

At 10:53 AM 5/11/2010, Anirudh Sundar wrote:

Hi Mike,

Did you try this :-

Create table TableDef select * from TableX where 1 = 2;

If you give this statement you will create the new table "TableDef" with 
the same variables and datatypes as table "TableX"


Let me know if it works

Cheers,
Anirudh Sundar



Anirudh,
Thanks for the quick reply. I use something like that all the time 
when I want to copy a table's definition. Actually I use "Create table2 
select * from table1 limit 0". But what I'm looking for here is the 
actual definition of TableX to be stored in TableDef.


So each row of TableDef represents a column definition from TableX.


And I'd like TableDef to have these rows:

ColName ColType
--- --
First_Name  Char(15)
Last_Name   Char(20)
Start_Date  Date
Salary  Double


The above data are actually "rows" from TableDef. TableDef only has 2 
columns "ColName" and "ColType". The TableDef rows are of course the 
columns making up TableX.


Mike


On Tue, May 11, 2010 at 9:06 PM, mos 
<mo...@fastmail.fm> wrote:
I'd like to get the field names and data types of a table, say TableX, 
and put it into TableDef using nothing but SQL. I know I can list the 
table definition using "Describe Table" and then loop through the 
results and insert the first two columns Field and Type into TableDef, 
but is there a way to do it using just SQL?


Example:
Describe TableX:

First_Name  Char(15)  
Last_Name   Char(20) ...
Start_Date  Date  ..
Salary  Double  ..


And I'd like TableDef to have these rows:

ColName ColType
--- --
First_Name  Char(15)
Last_Name   Char(20)
Start_Date  Date
Salary  Double

Is there a way to do this with one SQL statement? I'm really looking for 
the MySQL internal table where it stores the table definitions.


TIA
Mike


--
MySQL General Mailing List
For list archives: 
http://lists.mysql.com/mysql
To unsubscribe: 
http://lists.mysql.com/mysql?unsub=sundar.anir...@gmail.com 






--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=mo...@fastmail.fm



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: How to put table definition into another table using SQL?

[Anirudh Sundar]

Hey Mike,

I do not see a possibity of a quick response for this

We need to work on a query (if at all it is possible to be done in a query).

Will get back soon on this.

Cheers,
Anirudh Sundar



On Tue, May 11, 2010 at 9:36 PM, mos  wrote:

> At 10:53 AM 5/11/2010, Anirudh Sundar wrote:
>
>> Hi Mike,
>>
>> Did you try this :-
>>
>> Create table TableDef select * from TableX where 1 = 2;
>>
>> If you give this statement you will create the new table "TableDef" with
>> the same variables and datatypes as table "TableX"
>>
>> Let me know if it works
>>
>> Cheers,
>> Anirudh Sundar
>>
>
>
> Anirudh,
>Thanks for the quick reply. I use something like that all the time when
> I want to copy a table's definition. Actually I use "Create table2 select *
> from table1 limit 0". But what I'm looking for here is the actual definition
> of TableX to be stored in TableDef.
>
> So each row of TableDef represents a column definition from TableX.
>
>
>  And I'd like TableDef to have these rows:
>>
>> ColName ColType
>> --- --
>> First_Name  Char(15)
>> Last_Name   Char(20)
>> Start_Date  Date
>> Salary  Double
>>
>
> The above data are actually "rows" from TableDef. TableDef only has 2
> columns "ColName" and "ColType". The TableDef rows are of course the columns
> making up TableX.
>
> Mike
>
>
>  On Tue, May 11, 2010 at 9:06 PM, mos <
>> mo...@fastmail.fm> wrote:
>> I'd like to get the field names and data types of a table, say TableX, and
>> put it into TableDef using nothing but SQL. I know I can list the table
>> definition using "Describe Table" and then loop through the results and
>> insert the first two columns Field and Type into TableDef, but is there a
>> way to do it using just SQL?
>>
>> Example:
>> Describe TableX:
>>
>> First_Name  Char(15)  
>> Last_Name   Char(20) ...
>> Start_Date  Date  ..
>> Salary  Double  ..
>>
>>
>> And I'd like TableDef to have these rows:
>>
>> ColName ColType
>> --- --
>> First_Name  Char(15)
>> Last_Name   Char(20)
>> Start_Date  Date
>> Salary  Double
>>
>> Is there a way to do this with one SQL statement? I'm really looking for
>> the MySQL internal table where it stores the table definitions.
>>
>> TIA
>> Mike
>>
>>
>> --
>> MySQL General Mailing List
>> For list archives: 
>> http://lists.mysql.com/mysql
>> To unsubscribe: <
>> http://lists.mysql.com/mysql?unsub=sundar.anir...@gmail.com>
>> http://lists.mysql.com/mysql?unsub=sundar.anir...@gmail.com
>>
>>
>

Re: How to put table definition into another table using SQL?

[Carlos Proal]

Hi Mike, you need to query the information_schema schema/database that 
contains the database dictionary.
You can read the manual or a beautiful diagram here: 
http://www.xcdsql.org/Misc/MySQL_INFORMATION_SCHEMA.html


Have a nice day
Carlos Proal

On 5/11/2010 11:06 AM, mos wrote:

At 10:53 AM 5/11/2010, Anirudh Sundar wrote:

Hi Mike,

Did you try this :-

Create table TableDef select * from TableX where 1 = 2;

If you give this statement you will create the new table "TableDef" 
with the same variables and datatypes as table "TableX"


Let me know if it works

Cheers,
Anirudh Sundar



Anirudh,
Thanks for the quick reply. I use something like that all the time 
when I want to copy a table's definition. Actually I use "Create 
table2 select * from table1 limit 0". But what I'm looking for here is 
the actual definition of TableX to be stored in TableDef.


So each row of TableDef represents a column definition from TableX.


And I'd like TableDef to have these rows:

ColName ColType
--- --
First_Name  Char(15)
Last_Name   Char(20)
Start_Date  Date
Salary  Double


The above data are actually "rows" from TableDef. TableDef only has 2 
columns "ColName" and "ColType". The TableDef rows are of course the 
columns making up TableX.


Mike


On Tue, May 11, 2010 at 9:06 PM, mos 
<mo...@fastmail.fm> wrote:
I'd like to get the field names and data types of a table, say 
TableX, and put it into TableDef using nothing but SQL. I know I can 
list the table definition using "Describe Table" and then loop 
through the results and insert the first two columns Field and Type 
into TableDef, but is there a way to do it using just SQL?


Example:
Describe TableX:

First_Name  Char(15)  
Last_Name   Char(20) ...
Start_Date  Date  ..
Salary  Double  ..


And I'd like TableDef to have these rows:

ColName ColType
--- --
First_Name  Char(15)
Last_Name   Char(20)
Start_Date  Date
Salary  Double

Is there a way to do this with one SQL statement? I'm really looking 
for the MySQL internal table where it stores the table definitions.


TIA
Mike


--
MySQL General Mailing List
For list archives: 
http://lists.mysql.com/mysql
To unsubscribe: 
http://lists.mysql.com/mysql?unsub=sundar.anir...@gmail.com 









--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: How to put table definition into another table using SQL?

[mos]

At 10:53 AM 5/11/2010, Anirudh Sundar wrote:

Hi Mike,

Did you try this :-

Create table TableDef select * from TableX where 1 = 2;

If you give this statement you will create the new table "TableDef" with 
the same variables and datatypes as table "TableX"


Let me know if it works

Cheers,
Anirudh Sundar



Anirudh,
Thanks for the quick reply. I use something like that all the time 
when I want to copy a table's definition. Actually I use "Create table2 
select * from table1 limit 0". But what I'm looking for here is the actual 
definition of TableX to be stored in TableDef.


So each row of TableDef represents a column definition from TableX.


And I'd like TableDef to have these rows:

ColName ColType
--- --
First_Name  Char(15)
Last_Name   Char(20)
Start_Date  Date
Salary  Double


The above data are actually "rows" from TableDef. TableDef only has 2 
columns "ColName" and "ColType". The TableDef rows are of course the 
columns making up TableX.


Mike


On Tue, May 11, 2010 at 9:06 PM, mos 
<mo...@fastmail.fm> wrote:
I'd like to get the field names and data types of a table, say TableX, and 
put it into TableDef using nothing but SQL. I know I can list the table 
definition using "Describe Table" and then loop through the results and 
insert the first two columns Field and Type into TableDef, but is there a 
way to do it using just SQL?


Example:
Describe TableX:

First_Name  Char(15)  
Last_Name   Char(20) ...
Start_Date  Date  ..
Salary  Double  ..


And I'd like TableDef to have these rows:

ColName ColType
--- --
First_Name  Char(15)
Last_Name   Char(20)
Start_Date  Date
Salary  Double

Is there a way to do this with one SQL statement? I'm really looking for 
the MySQL internal table where it stores the table definitions.


TIA
Mike


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To 
unsubscribe: 
http://lists.mysql.com/mysql?unsub=sundar.anir...@gmail.com





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: How to put table definition into another table using SQL?

[Anirudh Sundar]

Hi Mike,

Did you try this :-

Create table TableDef select * from TableX where 1 = 2;

If you give this statement you will create the new table "TableDef" with the
same variables and datatypes as table "TableX"

Let me know if it works

Cheers,
Anirudh Sundar

On Tue, May 11, 2010 at 9:06 PM, mos  wrote:

> I'd like to get the field names and data types of a table, say TableX, and
> put it into TableDef using nothing but SQL. I know I can list the table
> definition using "Describe Table" and then loop through the results and
> insert the first two columns Field and Type into TableDef, but is there a
> way to do it using just SQL?
>
> Example:
> Describe TableX:
>
> First_Name  Char(15)  
> Last_Name   Char(20) ...
> Start_Date  Date  ..
> Salary  Double  ..
>
>
> And I'd like TableDef to have these rows:
>
> ColName ColType
> --- --
> First_Name  Char(15)
> Last_Name   Char(20)
> Start_Date  Date
> Salary  Double
>
> Is there a way to do this with one SQL statement? I'm really looking for
> the MySQL internal table where it stores the table definitions.
>
> TIA
> Mike
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=sundar.anir...@gmail.com
>
>

Re: How to put table definition into another table using SQL?

[Phil]

create table TableDEF like TableX;

Or am I missing something ??

On Tue, May 11, 2010 at 11:36 AM, mos  wrote:

> I'd like to get the field names and data types of a table, say TableX, and
> put it into TableDef using nothing but SQL. I know I can list the table
> definition using "Describe Table" and then loop through the results and
> insert the first two columns Field and Type into TableDef, but is there a
> way to do it using just SQL?
>
> Example:
> Describe TableX:
>
> First_Name  Char(15)  
> Last_Name   Char(20) ...
> Start_Date  Date  ..
> Salary  Double  ..
>
>
> And I'd like TableDef to have these rows:
>
> ColName ColType
> --- --
> First_Name  Char(15)
> Last_Name   Char(20)
> Start_Date  Date
> Salary  Double
>
> Is there a way to do this with one SQL statement? I'm really looking for
> the MySQL internal table where it stores the table definitions.
>
> TIA
> Mike
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql?unsub=pchap...@nc.rr.com
>
>


-- 
Distributed Computing stats
http://stats.free-dc.org

Re: How to put table definition into another table using SQL?

[Nuno Tavares]

create table TableDef like TableX ?

-- 
Nuno Tavares
DRI, Consultoria Informática
Telef: +351 936 184 086



mos escreveu:
> I'd like to get the field names and data types of a table, say TableX,
> and put it into TableDef using nothing but SQL. I know I can list the
> table definition using "Describe Table" and then loop through the
> results and insert the first two columns Field and Type into TableDef,
> but is there a way to do it using just SQL?
> 
> Example:
> Describe TableX:
> 
> First_NameChar(15)  
> Last_NameChar(20) ...
> Start_DateDate  ..
> SalaryDouble  ..
> 
> 
> And I'd like TableDef to have these rows:
> 
> ColNameColType
> --- --
> First_NameChar(15)
> Last_NameChar(20)
> Start_DateDate
> SalaryDouble
> 
> Is there a way to do this with one SQL statement? I'm really looking for
> the MySQL internal table where it stores the table definitions.
> 
> TIA
> Mike
> 
> 



signature.asc
Description: OpenPGP digital signature

How to put table definition into another table using SQL?

[mos]

I'd like to get the field names and data types of a table, say TableX, and 
put it into TableDef using nothing but SQL. I know I can list the table 
definition using "Describe Table" and then loop through the results and 
insert the first two columns Field and Type into TableDef, but is there a 
way to do it using just SQL?


Example:
Describe TableX:

First_Name  Char(15)  
Last_Name   Char(20) ...
Start_Date  Date  ..
Salary  Double  ..


And I'd like TableDef to have these rows:

ColName ColType
--- --
First_Name  Char(15)
Last_Name   Char(20)
Start_Date  Date
Salary  Double

Is there a way to do this with one SQL statement? I'm really looking for 
the MySQL internal table where it stores the table definitions.


TIA
Mike


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org