Albert Beermann wrote : >Hello !
>I want to insert a new field into an existing table after/before an >existing field and i don't know how to code?! >alter table xyz add column newcolumn position = after field xxx ??? > position = 4 ??? >Is there a way to do this ???? If not, what is the easiest workaround >???? >Any help welcomed >Albert No, this is not possible. As a workaround I recommend to create a view with the desired column order : Create view xyzv as select col1, col2, col3, xxx, col4 from xyz Best Regards, Thomas -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
