Printable View
Hi there guys, I'm having some trouble and was wondering if anyone here could help me.
I have a table named brochures and in that table i have 3 fields as follows
name
company
address
and now i also want a field for email
is it possible to add it to the end or do i need to delete the whole table and remake it to include the email field? Pls help and thankyou for your time.
You can add a field. All existing records will get the default value assigned.
At least in MySQL.
If you don't have a proper db manager, look into the ALTER TABLE statement.
As you're asking this in the PHP forum I'm assuming you've got PHP installed.
I use phpMyAdmin to manage my mySQL databases. It's the only tool I use for that and it works great.
Check it out!