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
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
create table TableDEF like TableX;
Or am I missing something ??
On Tue, May 11, 2010 at 11:36 AM, 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
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
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,
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
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 mo...@fastmail.fm wrote:
At 10:53 AM 5/11/2010, Anirudh
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
