table alter

[slimjim]

I need to put in a table into a database that has members already.

Now the fields id and user some how need to start with 1 then 2 and 3 until it matches the same amount of members users. And the referrer field needs a 0 in each row of each .
There are like 1500 members and for me to add 1500 rows for each member and put in 1,2,3,4,5,6 and so in each row and the 0 in referrer would be time consuming.

I have looked at and tried to understand the alter table in the manual but for this i don't understand.

Please help me out here

CREATE TABLE referrals (
            id int(11) NOT NULL auto_increment,
            user int(11) default NULL,
            referrer int(11) default NULL,
            PRIMARY KEY  (id)
);

[leatherback]

Hi,

How about adding a temporary table to write the new format to?
Then you just select * from oldtable

Set a counter: $i = 1;

And

insert into newtable (ID,...,..., referer) values ('$i', ..., ...., "0")
$i++

[maniac1aw]

you can easily alter table or do whatever in this GUI for mysql

http://mysqlfront.sstienemann.de/