login | register | shoutbox

 What happened to the Messenger Plus! forums on msghelp.net?
Shoutbox » MsgHelp Archive » Skype & Technology » Tech Talk » SQl querys: getting table names

SQl querys: getting table names
Author: Message:
MeEtc
Patchou's look-alike
*****

Avatar
In the Shadow Gallery once again

Posts: 2200
Reputation: 60
38 / Male / Flag
Joined: Nov 2004
Status: Away
O.P. RE: SQl querys: getting table names
sorry to bring back a thread....

is it possible to embed this as a subquery? I tried
select * from (show tables from database where table is not null) where table is not null
but that gives a "no 'where' clause found" error
[Image: signature/]     [Image: sharing.png]
I cannot hear you. There is a banana in my ear.
10-19-2006 05:24 PM
Profile PM Web Find Quote Report
« Next Oldest Return to Top Next Newest »

Messages In This Thread
SQl querys: getting table names - by MeEtc on 09-29-2006 at 03:51 PM
RE: SQL querys: getting table names - by WDZ on 09-29-2006 at 04:12 PM
RE: SQl querys: getting table names - by MeEtc on 09-29-2006 at 04:15 PM
RE: SQL queries: getting table names - by WDZ on 09-29-2006 at 04:19 PM
RE: SQl querys: getting table names - by Adeptus on 09-29-2006 at 05:00 PM
RE: SQl querys: getting table names - by MeEtc on 09-29-2006 at 05:12 PM
RE: SQl querys: getting table names - by Adeptus on 09-29-2006 at 05:18 PM
RE: SQl querys: getting table names - by MeEtc on 10-19-2006 at 05:24 PM


Threaded Mode | Linear Mode
View a Printable Version
Send this Thread to a Friend
Subscribe | Add to Favorites
Rate This Thread:

Forum Jump:

Forum Rules:
You cannot post new threads
You cannot post replies
You cannot post attachments
You can edit your posts 		HTML is Off
myCode is On
Smilies are On
[img] Code is On