Just for curiosity. Why "truncate" was necessary in my case? I just create a table and try to insert some values.
From: Daniel Kasak <[EMAIL PROTECTED]>
To: Mike Mapsnac <[EMAIL PROTECTED]>, [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: insert: auto increment field
Date: Mon, 05 Jan 2004 11:34:35 +1100
Mike Mapsnac wrote:
It solved the problem. But what truncate does? Just deletes the rows?
It's the same as doing:
drop table xxxx create table xxxx ( schema from dropped table above )
-- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
_________________________________________________________________
Get reliable dial-up Internet access now with our limited-time introductory offer. http://join.msn.com/?page=dept/dialup
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]