adding new column in TABLE using sql

[Anton]

---

@slightly OT:
At the start of this thread you asked on how to make the Zip Code to accept only numbers. I suggest you don't do this as some countries (i.e. UK) have alpha numeric post codes.

[Blacksheep666]

use alter if naa ka e edit sa table

[BadDudes]

This is just a follow up!!!!!

I agree with just using ALTER command would be best.. AFAIK ... column sequences doesnt matter since it always depends on the sequence on your SELECT query.

However if 10k+ records exist recreating the table can still be done using CREATE TABLE AS SELECT option... this creates a new table and drop the old table and recreate again using the same command above

[anggwaponi]

This is just a follow up!!!!!

I agree with just using ALTER command would be best.. AFAIK ... column sequences doesnt matter since it always depends on the sequence on your SELECT query.

However if 10k+ records exist recreating the table can still be done using CREATE TABLE AS SELECT option... this creates a new table and drop the old table and recreate again using the same command above

hello sa tanan ilabi na ninyo BadDudes, Blacksheep666, Anton, pridi, ug javapenguin ...

salamat kaayong sa mga maanindot ug haum nga tubag sa akong inquiry. tingali mapadayun gyud nako ning akong paningkamot ug magamit ang akong nakat-unan mahitungod aning sql.

mangayo lang diay ko despensa nga dugay2x o wa dayun ko katubag o update pud ani akong thread (naa lang pud ko giatiman laing ginagmay).

pero salamat gyud kaayo ninyong tanan nga nitampo. dako gyud ning hagit sa inyong katakus ug i'm sure daghan pud ang nakakuha ug ideas ani.

salamat ug maayong adlaw sa tanan. cheers!

[zengatsu]

try using the ALTER TABLE command

Spoiler: try this 

ALTER TABLE <table name> ADD <column name> <data type>(length) AFTER <column name>;

mao ni imong solution ana imong problema..

[ingkiang]

@zengatsu
taud2x na lage ka wla ka post ngari bro?
nana ka cebu?