var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Help with adding column
hi guys! I have a table with 3 columns but i realized that i need to add 1 column between column 2 and 3. Can anybody please help me on how to do that? Thanks in advance!
just create a new table and populate it like this:
insert into NewTable
select col1, col2, 'some value', col3 from OldTable
then you can drop your old table. be sure to create indexes, fks, etc on the new table as appropriate once it's populated.
Originally Posted by daimos
Just use alter table and add the field to the end.
Originally Posted by Brett Kaiser
You can always specify the display in your select statements.