php Myadmin Q 66 Responses

Last post: 4 months, 2 weeks ago | Thread started: Jul 16, 08, 1:32 p.m.

RespondNew TopicDisable Images

• BattleAxe

  How do i reset the primary key of a field, I want the auto increment to start from 0 again? thanks chaps

  Jul 16, 08, 1:32 p.m. – Permalink

• acescence

  browse a table and click on the operations tab

  

  You must be logged in to add a note. Login now or register for an account.

  Cancel

  Dog-earJul 16, 08, 1:35 p.m. – Permalink

• cosmoo

  empty the table.

  • hehe. lame answer.– cosmoo

  

  You must be logged in to add a note. Login now or register for an account.

  Cancel

  Dog-earJul 16, 08, 1:35 p.m. – Permalink

• madirish

  throw it out the window.

  

  You must be logged in to add a note. Login now or register for an account.

  Cancel

  Dog-earJul 16, 08, 1:36 p.m. – Permalink

• acescence

  or enter sql
  ALTER TABLE whatever AUTO_INCREMENT = 0

  

  You must be logged in to add a note. Login now or register for an account.

  Cancel

  Dog-earJul 16, 08, 1:38 p.m. – Permalink

• BattleAxe

  ok I reset the Primary key, but I have a csv file with values for 3 fields , the table i want to insert is empty (no records) , when I try to import I get this error "ERROR 1062: Duplicate entry for key 2"

  and i have been at it for a while so I am at the WTFFTW#%^&*SY*&%#@! point

  

  You must be logged in to add a note. Login now or register for an account.

  Cancel

  Dog-earJul 16, 08, 2:35 p.m. – Permalink

• neverblink

  what is the sql you are using to insert it?

  

  You must be logged in to add a note. Login now or register for an account.

  Cancel

  Dog-earJul 17, 08, 1:03 a.m. – Permalink