Add new rows into existing MySQL table

[Anon]

Hi I have existing table and already stored lot of information in it. But I need add some new rows into this table and I do not want to drop this table and then create it again beacause all stored information is gone.

How can I insert some rows into table without loosing stored data?

thanx...

[Anon]

Ok, I think you may be confusing the concept of rows versus columns. If you want to add a field, simply use the ALTER TABLE syntax in the mysql command line client. Something like this:

ALTER TABLE myTable ADD COLUMN NewColumn INT NOT NULL;

or

ALTER TABLE myTable ADD COLUMN TextColumn VARCHAR(50);

etc etc. you can also add indexes

ALTER TABLE myTable ADD INDEX NewColumn (NewColumn);

If you are just interested in adding rows, which is just another row of information, use the insert into syntax, as follows:

INSERT INTO myTable VALUES (0, 'Chris', 'New User'); etc etc... the values come in the order that the table is layed out. Hope that helps!

Chris King

[Anon]

Related Question: When I have an admin page that adds records to a database, and I want to add many rows, do I just call INSERT INTO over and over again, or is there an easier way?

Thanks!!!

[Anon]

Hi,

It's hard to tell with so little information but maybe a loop of some kind would do the trick.

Mike