Forums Register Login

mysql

+Pie Number of slices to send: Send
hai,
i am using mysql database.i have a table with primary key as
auto_increment.when i remove all the records from the table,
and try to insert a new record it inserts the primary key column
after the last removed value.

i want to know how to insert from 1.
can you tell me the ways.

thank for suggestions.
+Pie Number of slices to send: Send
I am sorry if this sounds sarcastic or patronizing, but, why don't you ask them (meaning mysql). http://www.mysql.org/ also has forums.
I have a knack for fixing things like this ... um ... sorry ... here is a consilitory tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com


reply
reply
This thread has been viewed 1036 times.
Similar Threads
sending values from one table to other..
Insert a new row with values from an existing record
auto_increment primary key
error in database
Is there a way to get the primary key with just one insert statement?
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 29, 2024 06:59:05.