Page 1 of 1

a stupid question about mysql database (2)

Posted: Sat Jul 23, 2005 4:08 am
by php12342005
assume a table have data.
will the table loss data if i drop or add a field to the table (except field dropped)?

E.g. Fied UserInfo contains many user names (data), if I add or drop another field (i.e. place), does data of user names in field UserInfo loss?

Thanks

Posted: Sat Jul 23, 2005 4:42 am
by dreamline
I've done that a couple of times and if you drop a field your other data is supposed to stay... But be4 doing any dropping i suggest you do backup your database.. :)

I always do that as a precaution.. But with phpMyAdmin i drop fields and add fields on a regular bases and sofar no data loss... :)

Posted: Sat Jul 23, 2005 7:08 am
by timvw