mysql field addition

[Anon]

I have created database called "bd1" It has 10 fields in it, but i now want to add more. How do i do it without creating a new batabase and copying all the info over.

Regards
[e-mail]

[elklabone]

...one field at a time
mysql> alter table table01 add column field03 char(20);

...more than one at a time
mysql> alter table table01 add column field04 date,add column field05 time;

The "add column" must be restated for each column.

Commas are used between each add column statement.

A space may be used after these commas.

[gio2k]

Do you run a webserver?
If so download and install phpmyadmin.

Just search for it in sourceforge.net
phpmyadmin is a web based front end that will let you create, drop and modify tables in your DB.

If you're not developing for the Web, then you can download this windows based front end: www.mysqlfront.de

Finally, if you don't want to download and install anything, then start mysql and type:

ALTER TABLE mytable ADD mycolumn char(10)

-Gio-

[[deleted]]

You might want to check the manual of your database engine before asking such an elementary question.

[Anon]

thanks but can i have that in working code please. Would i do it like this :-

$sql = "ALTER $table table_name add column field03 char(20)";

Thanks
[e-mail]

[elklabone]

If your web host allows you to telnet in, you should be able to do this via a telnet windows.

If you're on a windows machine, go to run and type

telnet www.yourdomain.com

Then login with your web host's assigned username and password (same as ftp, usually).

Then at telnet prompt run mysql program by typing:

mysql -uusername -ppassword dbname

type the commands I gave you earlier, making sure to add ";" to end of every command.

When done, type "exit" to exit mysql and "exit" again to log out.

I'm assuming you're being hosted on a "unix-type" machine.

There are a lot of good tutorials on mysql around, there's a good general course at sqlcourse.com. If you're serious about developing, you need to be able to run msyql from a command prompt also, IMHO.

Good luck.