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.
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.
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.eduwrote:
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/ ]
Austin: Look for the AUTO_INCREMENT value. It is settable. Google it. I forget the actual sql syntax. I use Navicat to manage my databases and it makes this kind of thing very easy. Bill
William A. Prothero http://earthednet.org/
On Mar 28, 2011, at 5:50 PM, Austin Einter wrote:
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/ ]
-
Austin Einter -
Metzler, David -
prothero