How to set the node ID to start with 100,000? I am running a new site with Drupal 7.

I want the node ID to start with 100,000. 

How do I set it? I don't want the node start with node 1.
To make node IDs start from 100000, in a new site (which I assume doesn't have any nodes created yet), all that's needed is to run this SQL statement (assuming you're using MySQL, PostgreSQL or SQLite):


For MySQL or SQLite:

ALTER TABLE node AUTO_INCREMENT = 100000;
For PostgreSQL, and inspired by the accepted answer to "Reset auto increment counter in Postgres", it should be something like so:

ALTER SEQUENCE node_nid_seq RESTART WITH 100000;


Change the 100000 value in this SQL to any other value (like 123), to make node IDs start from that other value (like 123).

Caution when applying such change in an existing site, whereas the new node ID (like 123) is less then the highest node ID used already in your site. Because in that case you may get all sorts of effects you may not want/like ... Though in a new site (as in this question here) those effects don't apply.