Gossamer Forum
Home : General : Databases and SQL :

Adding Fields in MySQL

Quote Reply
Adding Fields in MySQL
Is it possible to add a field to an already existing table?

eg.

Table that looks like the following:

Title | Code | Content
some title | 0075 | existing content

And I want:

Title | Code | Content | Date Added
some title | 0075 | existing content | Oct. 10th 2003

Any help is appreciated :D
Quote Reply
Re: [JoFrRi] Adding Fields in MySQL In reply to
Yes...you should consider using either MySQLMan (GT product) or use PHPMyAdmin.

These web-based applications will allow you to add fields, without having to login to your database via Shell and run MySQL commands.

Or you could install a client-based app, like MyCC (MySQL Control Center), to manage your database.
========================================
Buh Bye!

Cheers,
Me
Quote Reply
Re: [Stealth] Adding Fields in MySQL In reply to
No possible way to do it right in MySQL though, huh?
Quote Reply
Re: [JoFrRi] Adding Fields in MySQL In reply to
Well umm yes there is -
http://www.mysql.com/doc/en/ALTER_TABLE.html

Bob
http://totallyfreeads.com.au
Quote Reply
Re: [JoFrRi] Adding Fields in MySQL In reply to
Why make life complex??? There are plenty of MySQL tools out there like the ones I mentioned that makes life a lot easier in terms of managing your MySQL database.

Sure, as mentioned, you can use command line codes until you're blue in the face, but why do that if there are easy to use tools available, huh???
========================================
Buh Bye!

Cheers,
Me

Last edited by:

Stealth: Oct 12, 2003, 9:26 AM
Quote Reply
Re: [Stealth] Adding Fields in MySQL In reply to
I understand how things work better when I can actually type it in rather than use a database manager. It's much the same between using programs such as dreamweaver or frontpage to create webpages. I prefer the good ol' fashioned notepad.
Quote Reply
Re: [JoFrRi] Adding Fields in MySQL In reply to
I don't think that analogy is very good, I understand about raw coding for web pages to keep codes clean, but there isn't any real need for it when you are SQL programming, no matter if you pass the commands through a shell account or via a web-based interface, the end result is the same.
========================================
Buh Bye!

Cheers,
Me
Quote Reply
Re: [Stealth] Adding Fields in MySQL In reply to
Lol, don't worry about it, it's not a big deal.