[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
Re: [IC] sql-queries in interchange
On Sat, Dec 29, 2001 at 02:38:17PM -0800, Korey G. wrote:
> Is there any way to 'head' (or to 'cat' or to 'pipe' ) the
> names of fields in an arbitrary database and to use
> that information in a list like so maybe
>
> Or Perhaps there is a better way of doing this with Just sql Queries
>
Depending on the database you are using, there is probably a query that
can show this information. In MySQL you can use "show fields from table",
and the results will include table name, type, and other information.
Most sql servers have this capability, but the syntax varies...
--
Jason Kohles jkohles@redhat.com
Senior System Architect (703)786-8036 (cellular)
Red Hat Professional Consulting (703)456-2940 (office)
_______________________________________________
interchange-users mailing list
interchange-users@interchange.redhat.com
http://interchange.redhat.com/mailman/listinfo/interchange-users