How i can except a column from select * in mysql

Asked Apr 13 '20 at 11:14

Active Apr 13 '20 at 11:14

Viewed 21 times

I noticed that in mysql i can't make an except on selecting some columns, there is my request:

SELECT * FROM plane as p JOIN type as t ON p.id=t.id;

But this shows me all columns even the two columns plane_id and type_id that are equivalent, is there a request i can do to print just one of them and excepting the other ??

asked Apr 13 '20 at 11:14

Ayman101

Never use `SELECT *` – Strawberry Apr 13 '20 at 11:22
i thaught to select just all columns i want to show, but in case there is a large columns i can't select them peer by peer – Ayman101 Apr 13 '20 at 11:31

How i can except a column from select * in mysql

0 Answers0