Jump to content


Photo

set mysql row back to initial (1)


  • Please log in to reply
1 reply to this topic

#1 moise

moise
  • Members
  • PipPip
  • Member
  • 17 posts

Posted 24 April 2003 - 10:32 AM

hello,
can anyone help me on how to set my rows back to 1 after testing? it starts with numbers like 12.
help please!
"The roots of education are bitter, but the fruit is sweet." [br]-- Aristotle

#2 effigy

effigy
  • Staff Alumni
  • Advanced Member
  • 3,600 posts
  • LocationIL

Posted 24 April 2003 - 02:18 PM

are you speaking of throwing trash in, then removing it and reseting the auto_increment back to 1? if so: delete from table_name
Regexp | Unicode Article | Letter Database
/\A(e)?((1)?ff(?:(?:ig)?y)?|f(?:ig)?)\z/




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users