Hi,
You need to check the ALTER TABLE syntax in the manual.
http://www.mysql.com/doc/A/L/ALTER_TABLE.html
Unless you use the "FIRST" or "AFTER" clause, all the new fields will be
added at the bottom of the table. This procedure will *NOT* break your
database.
Regards,
Jorge
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Jorge del Conde <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Mexico City, Mexico
<___/ www.mysql.com
-----Original Message-----
From: Allen May [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 12, 2001 6:19 PM
To: [EMAIL PROTECTED]
Subject: Adding to a database
I need some reasurance...
I have an existing MySQL database that has basic user information. I am
using it to authenticate users on our web site. I has ID, Password,
FirstName, LastName etc.
We want to add columns at the end of this database for more detail...
City, State, Zip, Phone, etc. I am litle uneasy that I may completely
mess up my existing database if I do this.
Can someone give feedback of A) a better suggestion or B) if doing this
will break my database?
Thanks for any feedback.
-Allen
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
