Hi David

I did that, but the auto-increment field values starts from a high integer value (approx 15594). Then onwards for each row it is incremented by 1.

Though I do not see any problem with that (starting from high value), I would have liked the value to start from 0 or 1 and keep incrementing for each row.

Is there any-way, I can force the value to start from 0 or 1.

 

Best Regards

Austin

On Mon, Mar 28, 2011 at 11:42 PM, Metzler, David <metzlerd@evergreen.edu> wrote:

Do not include cid in the insert statement and it should autoincrement for you.

-----Original Message-----
From: support-bounces@drupal.org on behalf of Austin Einter
Sent: Mon 3/28/2011 03:04
To: support@drupal.org; development@drupal.org
Subject: [support] How to get the auto-increment value

Hi All
I have a table, where 'cid' field is of type "serial".

Schema declaration is ->  *"'cid' => array('type' => 'serial', 'unsigned' =>
TRUE, 'not null' => TRUE, ),"*

Aim is to have an incremented value for it.
The code is as below

*$lastid = 0;
 for($delta = 0; $delta < $all_companies; $delta++)
 {
 $lastid = db_last_insert_id(rs_companies, cid) + 1;
     db_query(
   'INSERT INTO {rs_companies} ( cid, uid, prevcompany, joindate,
releasedate) '
     ."VALUES (%d, '%d', '%s', '%d', '%d')",
 $lastid,  *

With this, I find this 'cid' field is not auto incrementing.  Any idea,
whats the wrong here.

Best Regards
Austin.

--
[ Drupal support list | http://lists.drupal.org/ ]

--
[ Drupal support list | http://lists.drupal.org/ ]