topic Re: *TABLE_NAME in Application Development and Automation Discussions

*TABLE_NAME

Former Member — Tue, 17 Jul 2007 13:37:22 GMT

WHAT DOES *TABLE NAME SPECIFIES?

Re: *TABLE_NAME

Former Member — Tue, 17 Jul 2007 13:40:13 GMT

Hi!

You can access this way a second header line of the table (it works like a work area, and it has the same sructure as the table).

It is a way obsolete.

Regards

Tamá

Re: *TABLE_NAME

seshatalpasai_madala — Tue, 17 Jul 2007 13:43:54 GMT

Hi,

This is used along with TABLES statement.

So if you want to create two strcutres of the same table using TABLES statement then use as follows.

TABLES: scarr, *scarr.

The avantage is

SELECT SINGLE *

FROM scarr

WHERE carrid = 'LH'.

SELECT SINGLE *

FROM *scarr

WHERE carrid = 'UA'.

*scarr behaves in a same way as scarr and even it works in SELECT statement and *scarr will be treated as scarr and data will be read from scarr. This usage is obsolete.

Regards,

Sesh

Re: *TABLE_NAME

Former Member — Wed, 18 Jul 2007 04:02:45 GMT

hi tushar,

*TABLE means the dummy table of original table TABLE

i will have the structure same as that of original table....but it wont be having any records..

hope this may help u...

please reward incase usefull...

regards,

prashant

Re: *TABLE_NAME

Former Member — Wed, 18 Jul 2007 07:49:45 GMT

Check this linkl:-

http://dev.mysql.com/doc/maxdb/en/ef/3c89d8b11311d2a97100a0c9449261/content.htm

Thanks