Add new field to a table

[scoppc]

I already have a table created to keep the members' information and it now has around 45 records inside. Lately I planned to add a new field to the table to hold the filename for each member's photo.

I have, for example, the fields like below:

memberId
memberName
memberDOB
memberStatus
memberUsername
memberPassword
memberDateJoined
memberLastLogin

Now, I want to add a new field called "memberPhoto" right after "memberDOB". Can I do that without the need to drop and re-create the table? 😕
I know that we can add a new field by using "ALTER" command, but it will add the new field at the end of the list, that is after "memberLastLogin".

Thanks.

regards,

scoppc

[Sore]

Why not try an administration tool like phpmyadmin? It´s a great tool for changing all kinds of things in your db.

[cahva]

ALTER TABLE yourtable ADD memberPhoto VARCHAR( 255 ) NOT NULL AFTER memberDOB ;

[scoppc]

I have tried it and it works!!! Cool!
Thanks!

Cheers,

scoppc