|
-
Jan 10th, 2005, 05:32 AM
#1
Thread Starter
Addicted Member
Update table
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.
-
Jan 10th, 2005, 06:53 AM
#2
Re: Update table
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.
All the buzzt
 CornedBee
"Writing specifications is like writing a novel. Writing code is like writing poetry."
- Anonymous, published by Raymond Chen
Don't PM me with your problems, I scan most of the forums daily. If you do PM me, I will not answer your question.
-
Jan 15th, 2005, 04:16 PM
#3
Fanatic Member
Re: Update table
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!
Never argue with fools, they will only drag you down to their level, and beat you with experience.
Q: How do you tell an experienced hacker from a novice?
A: The latter thinks there's 1000 bytes in a kilobyte, while the former is sure there's 1024 meters in a kilometer
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote
