List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:December 18 2002 10:57pm
Subject:re: Accessing last_insert_id problem.
View as plain text  
At 15:31 +0000 12/18/02, Jeff Snoxell wrote:
>Hi,
>
>I've got that sussed now and am happily using the aquired ref to 
>subsequently play with the record etc. One other related problem and 
>I recon I'm sorted....
>
>How do I reset the auto-increment value?
>
>I'm working with MySQL 3.23.36 so, according to "MySQL, Paul Dubois, 
>New Riders" running the query:
>
>"DELETE FROM my_table_name"
>
>should reset it... but it doesnt'.
>
>What SQL do I use to reset the val.

You can't believe anything that book says.  The author didn't even include
anything about TRUNCATE TABLE my_table_name.

>
>Ta,
>
>Jeff

Thread
Executing the "source c:/Test.sql" commandAmit Lonkar18 Dec
  • Re: Executing the "source c:/Test.sql" commandPaul DuBois18 Dec
    • Accessing last_insert_id problem.Jeff Snoxell18 Dec
      • re: Accessing last_insert_id problem.Victoria Reznichenko18 Dec
        • re: Accessing last_insert_id problem.Jeff Snoxell18 Dec
          • re: Accessing last_insert_id problem.Wico de Leeuw18 Dec
          • Re: Accessing last_insert_id problem.Michael T. Babcock18 Dec
          • re: Accessing last_insert_id problem.Paul DuBois18 Dec
            • re: Accessing last_insert_id problem.Jeff Snoxell19 Dec
              • re: Accessing last_insert_id problem.Wico de Leeuw19 Dec
            • thread_cache . what is it ? (no newbie question) .cristian ditoiu20 Dec
              • Re: thread_cache . what is it ? (no newbie question) .Benjamin Pflugmann20 Dec
      • Re: Accessing last_insert_id problem.Paul DuBois18 Dec
      • Re: Accessing last_insert_id problem.Matthew Smith2 Jan
        • Using Perl DBI quote() method with NULL values?Jeff Snoxell7 Jan
          • Re: Using Perl DBI quote() method with NULL values?Paul DuBois7 Jan
          • Re: Using Perl DBI quote() method with NULL values?Keith C. Ivey8 Jan
      • Re: Using Perl DBI quote() method with NULL values?walt7 Jan
      • Re: Using Perl DBI quote() method with NULL values?Rodney Broom8 Jan
      • Re: Using Perl DBI quote() method with NULL values?Salam Baker Shanawa8 Jan
  • Re: Accessing last_insert_id problem.Harald Fuchs18 Dec
Re: Accessing last_insert_id problem.Jeff Snoxell19 Dec
  • Re: Accessing last_insert_id problem.Paul DuBois19 Dec
  • RE: Accessing last_insert_id problem.Will Merrell20 Dec
    • Badly placed ()'s and also access deniedGary Hostetler20 Dec
      • RE: Badly placed ()'s and also access deniedJennifer Goodie20 Dec
        • Re: Badly placed ()'s and also access deniedGary Hostetler20 Dec