MySQL Select data without column name

Question

Suppose

SELECT * FROM some_tbl;

is same as

SELECT col1, col2, col3 FROM some_tbl;

Then how can I get the data from some_tbl without column name?

The problem is I don't know the column names...

Even I can't use information_schema in security reason...

Somebody said to me

You can get data without specific column name.

But I have any idea about it.

`SELECT * FROM some_tbl;` is selecting all of the columns in a table. I'm not sure what you're asking. Could you elaborate? — Brandon White, Nov 22 '15 at 01:40
Question's a bit vague. Are you trying to do this using a particular programming language, or from the command line, or... ? — Darwin von Corax, Nov 22 '15 at 01:41
maybe you can get columns names : http://stackoverflow.com/questions/4165195/mysql-query-to-get-column-names — Mate, Nov 22 '15 at 01:48

score 1 · Answer 1 · answered Nov 22 '15 at 01:47

1

Not sure if this is what you're after, but

SELECT * FROM some_tbl LIMIT 0;

will produce an empty result set containing the names of all the columns. Most decent APIs will allow you to access these column names from the result set.

answered Nov 22 '15 at 01:47

Darwin von Corax

5,201
3
17
28

score 0 · Answer 2 · answered Nov 22 '15 at 06:33

0

Is this what you're looking for:

Select * from syscolumns where ID in 
(Select ID from sysobjects where name = 'some_tbl')

answered Nov 22 '15 at 06:33

glitzsfa

353
1
2
14

MySQL Select data without column name

2 Answers2