How to SELECT all columns from a table (except a few)?

Question

I want to display the records from a table, except a few columns. The table has 94 columns in it and I want to view all of them except 5. Is that possible? If so, please let me know how?

I know I could select the required columns by specifying them. But I want to omit 5 columns out of 94. It is always better to omit 5 than specifying 89?

I googled but I did not get any idea to do this. So I just want to give last try here!

Not possible I'm afraid. see this question http://stackoverflow.com/questions/2365972/how-can-i-select-from-a-table-in-mysql-but-omit-certain-columns — Mark Davidson, Dec 11 '12 at 10:12
Thanks Mark..! Even I never heard of it.But just to know whether it is possible or not?? — Chella, Dec 11 '12 at 10:17
Just get them all, translate the matrix, remove the columns... or loop through and remove. — markus, Dec 20 '12 at 00:06
What is your use case? It is possible a static [view](http://dev.mysql.com/doc/refman/5.0/en/create-view.html) might help. But .. all depends on "why" you need to do this. — Leigh, Jan 05 '13 at 01:45

Houari · Answer 1 · 2012-12-11T11:24:45.257

0

$Database_Name="database_example";
$table_example="table_example";
$result = mysql_query("select column_name from information_schema.columns where table_schema = '$Database_Name' and table_name='$table_example' AND column_name NOT IN ('Col89', 'col90','col91','col92', 'col93','col94')");

if (!$result) { 
    die('Invalid request : ' . mysql_error());
}

$SQL="SELECT ";
while ($row = mysql_fetch_row($result)) {   
    foreach($row as $ColonneName)
        $SQL.=$ColonneName.",";
}   

$SQL=rtrim($SQL, ",")." FROM _table_example";

    echo $SQL;

edited Dec 11 '12 at 11:24

answered Dec 11 '12 at 10:21

Houari

5,326
3
31
54

It just display columns,But I want to display all the records inside a table – Chella Dec 11 '12 at 10:31
GOod work..I appreciate..! But I asked you a query, but you have given me PHP code..Any way Thank you HOurai..! – Chella Dec 12 '12 at 04:32
You can't do it only with the `SQL`, you have to generate your required SQL with `PHP`(Without writing the full column names manually). But i don't understand why someone votedown my post :( – Houari Dec 12 '12 at 09:56

How to SELECT all columns from a table (except a few)?

1 Answers1