I have a little SQLite database on a website, when I set up the tables using the CREATE directive, the ENTRY_ID was set up with the following.
CREATE TABLE visitors(ENTRY_ID INTEGER PRIMARY KEY AUTOINCREMENT, REQUEST_TIME INTEGER, USER_IP... ... ...
However... the table is not "Auto Incrementing" and the ENTRY_ID fields are empty...
My query is how is it best to move forward with altering the primary key to actually auto increment keeping in mind that the table has nearly 34,000 entries in it.
... and please remember to wrap code with forum BBCode tags:-
[CODE]...[/CODE] [HTML]...[/HTML] [PHP]...[/PHP]
If you can't think outside the box, you will be trapped forever with no escape...
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)