MySQL Forums
Forum List  »  Partitioning

Re: Partitioning not working need primary key?
Posted by: newbie Shai
Date: October 23, 2012 08:36AM

Dear Rick,
Yes I read your link is very good and useful information. Below is the show create table.

CREATE TABLE `tblreceipt` (
`receiptID` int(10) NOT NULL,
`previousReceiptID` int(10) NOT NULL default '0',
`outletID` int(2) NOT NULL default '0',
`employeeID` int(2) NOT NULL default '0',
`customerName` varchar(100) NOT NULL default 'Cash',
`customerPhone` varchar(10) default NULL,
`totalCostAmount` double(10,2) NOT NULL,
`totalSellingAmount` double(10,2) NOT NULL,
`totalProfitAmount` double(10,2) NOT NULL,
`changeAmount` double(5,2) NOT NULL,
`profit` enum('y','n') NOT NULL,
`receiptDate` date NOT NULL,
`receiptTime` time NOT NULL,
`receiptType` enum('n','e','f','p') NOT NULL default 'n',
PRIMARY KEY (`receiptID`,`outletID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Partitioning not working need primary key?
1672
October 23, 2012 08:36AM


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.