[mythtv-users] Confused About HDHomeRun

[David Brodbeck]

On Oct 3, 2007, at 10:17 AM, Jerry Rubinow wrote:

> On 10/3/07, Tom Lichti <tom at redpepperracing.com> wrote:
>> Jerry Rubinow wrote:
>>> After you've done
>>> DELETE ALL, the card numbers should start from 1.
>>>
>> Not true at all. I've done delete all 3 times, and am up to tuners
>> 12-15. The only way to get back to one is to delete all tuners, then
>> modify the capture card table to reset the auto-increment field  
>> back to
>> 0, then re-add your cards. Or you could modify the table directly to
>> change the ID's. I'm NOT advocating doing either of those, there  
>> is no
>> need, and if you do, I take no responsibility for what happens.
>
> Sorry, my mistake.  I thought I had read that somewhere.

If you DROP TABLE in MySQL, it will reset the autoincrement field.   
In some cases I believe MySQL will optimize "DELETE FROM Tablename;"  
into a DROP TABLE followed by a CREATE TABLE, which can have the same  
effect.  That may be what you're thinking of.  I think this is DB  
engine dependent.