ideas

Ideas for select all columns but one mysql stored procedure

Assume we’ve a table with 100 rows and we need to select all columns but one. The problem is headache of actually typing out all 99 required columns!! Solutions / Ideas to above problem are: Ignorance is bliss. Select all(*) and ignore the column. Manually type column names or manage it with copy paste! Create a view from original table and drop the unnecessary column! MySQL Database command / syntax that allows us to do this; which is not there unfortunately. Use my stored procedure to select all but one columns: No need to explain why all such hacks are...