Mysql

**hinux** · May 30, 2003, 02:21

How can I change the value of a post in my sql.

I want to change ID=1 to ID=2(over 100 posts in the table)

Is there an easy way to do this?

**Chris82** · May 30, 2003, 02:35

Hi.

Do you want always increase the id value by one?

If so try:

Code:

UPDATE yourtable SET id = id + 1;

**hinux** · May 30, 2003, 02:37

What i really want is to find a way to insert the same posts with a new ID,to save time.

I need to insert the same posts with a new ID about 10 or 11 times..

**Chris82** · May 30, 2003, 02:40

You could use an auto_increment field for the id. This would create a new id for each entry.

**hinux** · May 30, 2003, 02:46

hmm....i'll try..but i'm not sure excactly how

**hinux** · May 30, 2003, 02:48

I have ca. 100 posts that have ID=1,and I need the same posts with ID=2,3,4..and so on..

The SitePoint Forums have moved.

User Tag List

Thread: Mysql

Thread Tools

Display

Mysql

Bookmarks

Bookmarks

Posting Permissions