MySQL Forums
Forum List  »  PHP

Truncate not working
Posted by: Jeff Norton
Date: March 24, 2006 10:19PM

I have MySQL 4.1 with the my table is

/*
MySQL Backup
Source Host: localhost
Source Server Version: 4.1.18-nt
Source Database: test
Date: 2006/03/24 22:15:54
*/

SET FOREIGN_KEY_CHECKS=0;
use jnorton1_ecom;
#----------------------------
# Table structure for 73266_inventory
#----------------------------
CREATE TABLE `73266_inventory` (
`ID` int(11) NOT NULL auto_increment,
`SKU` varchar(255) default NULL,
`ITEMID` varchar(255) default NULL,
`DESCRIPTION` longtext,
`VENDOR` varchar(255) default NULL,
`CAT` varchar(255) default NULL,
`PRICE` varchar(255) default NULL,
`Weight` varchar(255) default NULL,
`SIZE` varchar(255) default NULL,
`UNIT` varchar(255) default NULL,
`SUB-CATEGORY` varchar(255) default NULL,
`STATUS` varchar(255) default NULL,
`FR` varchar(255) default NULL,
`LA` varchar(255) default NULL,
`AT` varchar(255) default NULL,
`CH` varchar(255) default NULL,
`DA` varchar(255) default NULL,
`HO` varchar(255) default NULL,
`KA` varchar(255) default NULL,
`NJ` varchar(255) default NULL,
`TA` varchar(255) default NULL,
`MI` varchar(255) default NULL,
`PO` varchar(255) default NULL,
`LR` varchar(255) default NULL,
PRIMARY KEY (`ID`),
KEY `SKU_73266` (`SKU`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='InnoDB free: 145408 kB; InnoDB free: 145408 kB; InnoDB free:';
#----------------------------
# Records for table 73266_inventory

when I >"truncate table 73266_inventory" it deletes the data but keeps the auto incremnt value for the primary key and when I go to insert a new value the ID key resumes from the old value

Options: ReplyQuote


Subject
Written By
Posted
Truncate not working
March 24, 2006 10:19PM
March 24, 2006 11:23PM
March 25, 2006 07:32AM
March 25, 2006 07:33AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.