SQL BOX

[naive]

Hello
I would like to make the SQL query a data BOX.
However, he is always out syntax error - someone can give me a hint how I make a simple query on the SQL box.
Second, a specific query with specific search results such as customer or otherwise.

Thank you

[jojo]

Hi,

if you have no understanding of correct SQL syntax you should not use this frontend as you can easily loose all your data!

For syntax and so on you should read the mysql documentation and you also need some understanding of the OTRS database layout

[crythias]

simple query in sql box:
select 1

select * from article_type

hint: do not use semicolons.
hint2: remove the limit for DESCRIBE
hint3: if you want labels, add them with union:
select 'id' UNION select id from article_type