Code: Select all
select 'id', 'name', 'comments' union select id, name, comments from article_typeColumn Headers in SQL Box
Moderator: crythias
Forum rules
Dont create your support topics here! No new topics with questions allowed!
Dont create your support topics here! No new topics with questions allowed!
-
crythias
- Moderator
- Posts: 10169
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Column Headers in SQL Box
A rather sneaky way of doing it, but here's an example:
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Re: Column Headers in SQL Box
Hi Crythias
it works, thx a lot,
...i was wondering if it would be another option without typing all the fields everytime
,
otherwise i can survive with this option.
BR/Chepeliux
it works, thx a lot,
...i was wondering if it would be another option without typing all the fields everytime
,otherwise i can survive with this option.
BR/Chepeliux