#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2000
    Location
    Indonesia
    Posts
    87
    Rep Power
    15
    Say it I have a table like this :

    table testing
    id_Num int not null auto_increment
    data varchar(250) not null
    primary key(id_Num)

    Then I insert into the table :
    insert into testing (data) values ("Testing");

    I do it until it has about 3 records.

    Then I delete record number 3.
    After that I insert another record, according to me the id_Num should be 3. Isn't it??

    The fact id_Num of the new record is 4.

    I tried it at home and I got what I want (the id_Num of new record id 3), but at college it doesn't work !!

    Can anybody tell me why ???



    ------------------
    ** It's the world of Oscario **
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Location
    Sydney, Australia
    Posts
    32
    Rep Power
    15
    Yeah.. i sort of wanted to know how to do that too..

    This i haven't tried.. but have you tried to set the default to 0??

    Tell me if it works..

    scoobydoo
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2000
    Location
    Indonesia
    Posts
    87
    Rep Power
    15
    Finally...
    I found it.

    Just check out the documentation in www.mysql.com

    It's said that my problem is caused by the type of the table.

    MyISAM table can't do that !!
    But ISAM table can.
    So I just change the type of my table by issuing :
    "alter table tablename type=ISAM"

    or create the table with ISAM type by issuing :
    " create table tablename (fields specification) type = ISAM"

    And the problems solved out !!

    See ya !!!



    ------------------
    ** It's the world of Oscario **

Similar Threads

  1. Mysql problem.
    By Nik in forum MySQL Help
    Replies: 54
    Last Post: December 21st, 2006, 07:02 PM
  2. Upgrade from access to mysql
    By karib1 in forum ASP Programming
    Replies: 7
    Last Post: December 16th, 2003, 01:35 PM
  3. Upgrade from access to mysql
    By karib1 in forum MySQL Help
    Replies: 1
    Last Post: December 16th, 2003, 01:27 AM
  4. problem: asp files, from access to mysql
    By karib1 in forum MySQL Help
    Replies: 1
    Last Post: November 26th, 2003, 04:16 AM

IMN logo majestic logo threadwatch logo seochat tools logo