Re: Adding Column in Specific Position of table

On Wed, Apr 29, 2015 at 2:51 AM, Jan Lentfer <Jan(dot)Lentfer(at)web(dot)de> wrote:

> Hi, this is not currently possibly with just an ALTER TABLE. Regards, Jan.
>
> Von meinem iPad gesendet
>
> > Am 29.04.2015 um 11:43 schrieb Ankur Kaushik <ankurkaushik(at)gmail(dot)com>:
> >
> >
> > Hi ,
> >
> > I can I alter table to add column at specific position ,
> >
> > below
> >
> > Table : Post
> >
> >
> > Column : a
> > b
> > d
> >
> > Want to add new column c before d or after b.
>

It's probably a bad idea, too. If your application depends on the ordering
of the columns, I guarantee you'll regret it. It's a recipe for mysterious
bugs.

Every SQL query should name the columns. If you do that, the column
ordering doesn't matter.

Craig