MySQL Forums
Forum List  »  Stored Procedures

Re: Query times out when I add extra Where Condition
Posted by: John Noble
Date: January 27, 2020 04:28AM

Hi Peter,

Im using Win 7 Pro with 8 Gb Ram

I have added in the extra group by clauses

I have changed the innodb_buffer_pool_size to 428 and it has took a second off the query time.

Im not sure how to read the Explain statement. How can I tell where I need to put my indexes ?

Here are the Create Table results....

'salesLedger', 'CREATE TABLE `salesledger` (\n  `accountManagerID` varchar(3) NOT NULL DEFAULT \'\',\n  `AOLP` decimal(14,2) NOT NULL DEFAULT \'0.00\',\n  `balance` decimal(14,2) NOT NULL DEFAULT \'0.00\',\n  `bankCharges` decimal(12,2) NOT NULL DEFAULT \'0.00\',\n  `cash` decimal(14,2) NOT NULL DEFAULT \'0.00\',\n  `CCmanagerID` varchar(3) NOT NULL DEFAULT \'\',\n  `conversionRate` decimal(10,3) NOT NULL DEFAULT \'0.000\',\n  `costcentre` varchar(1) NOT NULL DEFAULT \'\',\n  `countryID` varchar(2) NOT NULL DEFAULT \' \',\n  `creditDaysTaken` int(11) NOT NULL DEFAULT \'0\',\n  `customerID` varchar(7) NOT NULL DEFAULT \' \',\n  `dateExported` date NOT NULL DEFAULT \'0000-00-00\',\n  `daybook` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  `docType` varchar(3) NOT NULL DEFAULT \'\',\n  `discount` decimal(12,2) NOT NULL DEFAULT \'0.00\',\n  `DOLP` date NOT NULL DEFAULT \'0000-00-00\',\n  `dueDate` date NOT NULL DEFAULT \'0000-00-00\',\n  `exportedToSage` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  `groupID` varchar(3) NOT NULL DEFAULT \'\',\n  `invNum` int(11) NOT NULL DEFAULT \'0\',\n  `invoiceCurrency` varchar(3) NOT NULL DEFAULT \' \',\n  `invoiceDate` date NOT NULL DEFAULT \'0000-00-00\',\n  `net` decimal(14,2) NOT NULL DEFAULT \'0.00\',\n  `netWeight` decimal(14,3) NOT NULL DEFAULT \'0.000\',\n  `orderref` int(11) NOT NULL DEFAULT \'0\',\n  `payable` decimal(14,2) NOT NULL DEFAULT \'0.00\',\n  `paymentStatus` varchar(1) NOT NULL DEFAULT \' \',\n  `paidToDate` decimal(14,2) NOT NULL DEFAULT \'0.00\',\n  `PDF` varchar(100) NOT NULL DEFAULT \'\',\n  `pkey` int(11) NOT NULL AUTO_INCREMENT,\n  `receiptNo` int(11) NOT NULL DEFAULT \'0\',\n  `taxCode` varchar(2) NOT NULL DEFAULT \'\',\n  `transactionType` varchar(2) NOT NULL DEFAULT \' \',\n  `userID` varchar(3) NOT NULL DEFAULT \'\',\n  `vat` decimal(13,2) NOT NULL DEFAULT \'0.00\',\n  `lastUpdated` date NOT NULL DEFAULT \'0001-01-01\',\n  `boxes` int(11) NOT NULL DEFAULT \'0\',\n  `freshFrozen` varchar(1) NOT NULL DEFAULT \'F\',\n  `monthPeriodEndFlag` enum(\'F\',\'T\') NOT NULL DEFAULT \'F\',\n  `comment` varchar(250) NOT NULL DEFAULT \'\',\n  `invoiceLogFlag` enum(\'F\',\'T\') NOT NULL DEFAULT \'F\',\n  `agentID` varchar(3) NOT NULL DEFAULT \'NON\',\n  `accountID` varchar(10) NOT NULL DEFAULT \'\',\n  `daybookNo` int(11) NOT NULL DEFAULT \'0\',\n  `paymentNo` int(12) NOT NULL DEFAULT \'0\',\n  `balAccType` varchar(10) NOT NULL DEFAULT \'\',\n  `ediSent` date NOT NULL DEFAULT \'0001-01-01\',\n  `ediFlag` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  `dayBookNo2` int(11) NOT NULL DEFAULT \'0\',\n  `paidInFullDate` date NOT NULL DEFAULT \'0001-01-01\',\n  `businessGroup` varchar(4) NOT NULL DEFAULT \'\',\n  `vatCode` varchar(10) NOT NULL DEFAULT \'\',\n  `nomCode` varchar(4) NOT NULL DEFAULT \'\',\n  `vatReportFlag` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  `vatReportDate` date NOT NULL DEFAULT \'0001-01-01\',\n  `bankAmount` decimal(12,2) NOT NULL DEFAULT \'0.00\',\n  `entryDate` date NOT NULL DEFAULT \'0001-01-01\',\n  `unallocatedNo` int(10) NOT NULL DEFAULT \'0\',\n  PRIMARY KEY (`pkey`),\n  KEY `countryID` (`countryID`) USING BTREE,\n  KEY `invNum` (`invNum`) USING BTREE,\n  KEY `customerID` (`customerID`) USING BTREE\n) ENGINE=InnoDB AUTO_INCREMENT=3207448 DEFAULT CHARSET=latin1'
'receipts', 'CREATE TABLE `receipts` (\n  `receiptNo` int(12) NOT NULL DEFAULT \'0\',\n  `invNum` int(11) NOT NULL DEFAULT \'0\',\n  `invoiceDate` date NOT NULL,\n  `receiptDate` date NOT NULL DEFAULT \'0000-00-00\',\n  `payInvoiceDate` date NOT NULL,\n  `invoiceamount` decimal(11,2) NOT NULL DEFAULT \'0.00\',\n  `allocationAmount` decimal(11,2) NOT NULL DEFAULT \'0.00\',\n  `customerID` varchar(7) NOT NULL DEFAULT \' \',\n  `receiptAmount` decimal(12,2) NOT NULL DEFAULT \'0.00\',\n  `pkey` int(11) NOT NULL AUTO_INCREMENT,\n  `docType` varchar(3) NOT NULL DEFAULT \'\',\n  `comment` varchar(75) DEFAULT NULL,\n  `paymentNo` int(12) NOT NULL DEFAULT \'0\',\n  `creditDaysTaken` int(11) NOT NULL DEFAULT \'0\',\n  `dayBookNo` int(11) NOT NULL DEFAULT \'0\',\n  `unallocatedNo` int(10) NOT NULL DEFAULT \'0\',\n  `masterUnallocated` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  PRIMARY KEY (`pkey`),\n  KEY `invNum` (`invNum`) USING BTREE,\n  KEY `invoiceDate` (`invoiceDate`) USING BTREE,\n  KEY `receiptDate` (`receiptDate`) USING BTREE\n) ENGINE=InnoDB AUTO_INCREMENT=310491 DEFAULT CHARSET=latin1'
'countries', 'CREATE TABLE `countries` (\n  `countryID` varchar(2) NOT NULL DEFAULT \' \',\n  `country` varchar(20) NOT NULL DEFAULT \' \',\n  `czechName` varchar(20) NOT NULL DEFAULT \' \',\n  `EUMember` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  `EUTaxCode` varchar(2) NOT NULL DEFAULT \' \',\n  `FrenchName` varchar(20) NOT NULL DEFAULT \' \',\n  `GermanName` varchar(20) NOT NULL DEFAULT \' \',\n  `italianName` varchar(20) NOT NULL DEFAULT \' \',\n  `localTaxCode` varchar(2) NOT NULL DEFAULT \' \',\n  `taxCode` varchar(1) NOT NULL DEFAULT \' \',\n  `freeFormatVatTaxCode` varchar(2) NOT NULL DEFAULT \'\',\n  `name` varchar(30) NOT NULL DEFAULT \' \',\n  `pkey` int(11) NOT NULL AUTO_INCREMENT,\n  `productSource` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  `SlovakianName` varchar(20) NOT NULL DEFAULT \' \',\n  `SpanishName` varchar(20) NOT NULL DEFAULT \' \',\n  `TransportTaxCode` varchar(2) NOT NULL DEFAULT \' \',\n  `lastUsedBy` varchar(45) DEFAULT \' \',\n  `inUse` varchar(45) DEFAULT \' \',\n  `customerBoardNo` int(10) NOT NULL DEFAULT \'0\',\n  PRIMARY KEY (`pkey`)\n) ENGINE=InnoDB AUTO_INCREMENT=135 DEFAULT CHARSET=latin1'
'users', 'CREATE TABLE `users` (\n  `username` varchar(15) NOT NULL DEFAULT \' \',\n  `password` varchar(15) NOT NULL DEFAULT \' \',\n  `Name` varchar(30) NOT NULL DEFAULT \' \',\n  `countryID` varchar(2) NOT NULL DEFAULT \' \',\n  `entries` int(11) NOT NULL DEFAULT \'0\',\n  `userID` varchar(3) NOT NULL DEFAULT \' \',\n  `Gender` varchar(1) NOT NULL DEFAULT \' \',\n  `loggedIn` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  `accountManager` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  `ccmanager` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  `labelPrinterName` varchar(50) NOT NULL DEFAULT \' \',\n  `pkey` int(11) NOT NULL AUTO_INCREMENT,\n  `overrideFileMaintenance` enum(\'T\',\'F\') DEFAULT \'F\',\n  `presentationNames` enum(\'T\',\'F\') DEFAULT \'T\',\n  `gradeNames` enum(\'T\',\'F\') DEFAULT \'F\',\n  `customerNames` enum(\'T\',\'F\') DEFAULT \'F\',\n  `modifyOrder` enum(\'T\',\'F\') DEFAULT \'F\',\n  `lastCustomerDownload` date DEFAULT NULL,\n  `emailAddress` varchar(45) DEFAULT \' \',\n  `emailpassword` varchar(45) DEFAULT \' \',\n  `outgoingSMTP` varchar(100) DEFAULT \' \',\n  `emailPort` int(11) DEFAULT \'25\',\n  `lastSalesLedgerDownload` date DEFAULT NULL,\n  `lastBankDownload` date DEFAULT NULL,\n  `copyLocalFiles` enum(\'T\',\'F\') DEFAULT \'T\',\n  `clearProductLine` enum(\'T\',\'F\') DEFAULT \'F\',\n  `customerBoardNo` int(11) DEFAULT \'0\',\n  `currentCustomerBoard` varchar(30) DEFAULT NULL,\n  `PL` enum(\'T\',\'F\') DEFAULT \'F\',\n  `UKSales` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  `location` varchar(2) NOT NULL DEFAULT \'\',\n  `generalPostingFromDate` date NOT NULL DEFAULT \'0001-01-01\',\n  `generalPostingToDate` date NOT NULL DEFAULT \'0001-01-01\',\n  PRIMARY KEY (`pkey`)\n) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=latin1'
'customers', 'CREATE TABLE `customers` (\n  `customerID` varchar(7) NOT NULL DEFAULT \' \',\n  `accountManagerID` varchar(3) NOT NULL DEFAULT \' \',\n  `address1` varchar(35) NOT NULL DEFAULT \' \',\n  `accountsEmail` varchar(150) NOT NULL DEFAULT \' \',\n  `address2` varchar(35) NOT NULL DEFAULT \' \',\n  `address3` varchar(35) NOT NULL DEFAULT \' \',\n  `address4` varchar(35) NOT NULL DEFAULT \' \',\n  `AccountSetUp` date NOT NULL DEFAULT \'0000-00-00\',\n  `agentFlag` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  `areaID` varchar(2) NOT NULL DEFAULT \' \',\n  `accountsContact` varchar(35) NOT NULL DEFAULT \' \',\n  `balance` decimal(14,2) NOT NULL DEFAULT \'0.00\',\n  `bankID` varchar(10) NOT NULL DEFAULT \' \',\n  `bankAccount` varchar(20) NOT NULL DEFAULT \' \',\n  `baseRatePence` decimal(8,2) NOT NULL DEFAULT \'0.00\',\n  `baseRateCents` decimal(8,2) NOT NULL DEFAULT \'0.00\',\n  `baseRatePC` decimal(5,2) NOT NULL DEFAULT \'0.00\',\n  `creditLimit` int(11) NOT NULL DEFAULT \'0\',\n  `classification` varchar(1) NOT NULL DEFAULT \' \',\n  `CCmanagerID` varchar(3) NOT NULL DEFAULT \' \',\n  `creditreference` varchar(10) NOT NULL DEFAULT \' \',\n  `creditInfo` varchar(50) NOT NULL DEFAULT \' \',\n  `creditLimitCurrency` varchar(3) NOT NULL DEFAULT \' \',\n  `creditFlag` varchar(1) NOT NULL DEFAULT \' \',\n  `countryID` varchar(2) NOT NULL DEFAULT \' \',\n  `deliveryAddressFlag` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  `delTime` varchar(10) NOT NULL DEFAULT \' \',\n  `deliveryTerms` varchar(3) NOT NULL DEFAULT \' \',\n  `discountPC` decimal(5,2) NOT NULL DEFAULT \'0.00\',\n  `discount2PC` decimal(5,2) NOT NULL DEFAULT \'0.00\',\n  `discountPCExtra` decimal(5,2) NOT NULL DEFAULT \'0.00\',\n  `DOLO` date NOT NULL DEFAULT \'0000-00-00\',\n  `EDI` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  `euroCreditLimit` decimal(13,2) NOT NULL DEFAULT \'0.00\',\n  `expiryDate` date NOT NULL DEFAULT \'0000-00-00\',\n  `Excess` decimal(10,2) NOT NULL DEFAULT \'0.00\',\n  `fax` varchar(20) NOT NULL DEFAULT \' \',\n  `frozen` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  `groupID` varchar(3) NOT NULL DEFAULT \' \',\n  `invoiceComm` varchar(1) NOT NULL DEFAULT \' \',\n  `invoiceLang` varchar(2) NOT NULL DEFAULT \' \',\n  `InvoiceCurrency` varchar(3) NOT NULL DEFAULT \' \',\n  `invoiceEmail` varchar(250) NOT NULL DEFAULT \' \',\n  `invoiceEmail2` varchar(250) NOT NULL DEFAULT \' \',\n  `invoiceText` varchar(250) NOT NULL DEFAULT \'\',\n  `invoiceText2` varchar(250) NOT NULL DEFAULT \'\',\n  `labelFormat` varchar(1) NOT NULL DEFAULT \' \',\n  `labelType` int(11) NOT NULL DEFAULT \'0\',\n  `number` varchar(4) NOT NULL DEFAULT \' \',\n  `name` varchar(100) NOT NULL DEFAULT \' \',\n  `name2` varchar(50) NOT NULL DEFAULT \'\',\n  `quotationComm` varchar(1) NOT NULL DEFAULT \' \',\n  `quotationLang` varchar(2) NOT NULL DEFAULT \' \',\n  `quotationEmail` varchar(254) NOT NULL DEFAULT \' \',\n  `quotationEmailFrozen` varchar(254) NOT NULL DEFAULT \'\',\n  `salesContact` varchar(35) NOT NULL DEFAULT \' \',\n  `salesContactEmail` varchar(150) NOT NULL DEFAULT \'\',\n  `searchName` varchar(50) NOT NULL DEFAULT \' \',\n  `shortName` varchar(30) NOT NULL DEFAULT \' \',\n  `salesTemp` decimal(13,2) NOT NULL DEFAULT \'0.00\',\n  `telephone` varchar(20) NOT NULL DEFAULT \' \',\n  `tradingTermsID` varchar(1) NOT NULL DEFAULT \' \',\n  `transact_userID` varchar(3) NOT NULL DEFAULT \'\',\n  `transportUKID` varchar(2) NOT NULL DEFAULT \' \',\n  `transportEUID1` varchar(3) NOT NULL DEFAULT \' \',\n  `transportUKIDfri` varchar(2) NOT NULL DEFAULT \'\',\n  `transportEUIDfri` varchar(3) NOT NULL DEFAULT \'\',\n  `transportEUID2` varchar(3) NOT NULL DEFAULT \' \',\n  `transportRateEU` decimal(5,2) NOT NULL DEFAULT \'0.00\',\n  `transportRateEUExtra` decimal(5,2) NOT NULL DEFAULT \'0.00\',\n  `TermsDays` int(11) NOT NULL DEFAULT \'0\',\n  `transportPencePerKG` decimal(5,2) NOT NULL DEFAULT \'0.00\',\n  `terms` varchar(3) NOT NULL DEFAULT \' \',\n  `VATreg` varchar(15) NOT NULL DEFAULT \'\',\n  `pkey` int(11) NOT NULL AUTO_INCREMENT,\n  `warehouseID` varchar(1) NOT NULL DEFAULT \'\',\n  `inUse` varchar(25) NOT NULL DEFAULT \' \',\n  `lastUsedBy` varchar(25) NOT NULL DEFAULT \' \',\n  `town` varchar(45) NOT NULL DEFAULT \' \',\n  `postcode` varchar(12) NOT NULL DEFAULT \' \',\n  `blocked` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  `customerRefFlag` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  `insuranceExcluded` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  `printBonDeLivraison` enum(\'T\',\'F\') NOT NULL DEFAULT \'T\',\n  `printBonDeTransport` enum(\'T\',\'F\') NOT NULL DEFAULT \'T\',\n  `lastUpdated` date NOT NULL DEFAULT \'0001-01-01\',\n  `kebabBestBeforeDays` int(11) NOT NULL DEFAULT \'0\',\n  `smokedBestBeforeDays` int(11) NOT NULL DEFAULT \'0\',\n  `termsDaysFrozen` int(11) NOT NULL DEFAULT \'0\',\n  `agentID` varchar(8) NOT NULL DEFAULT \'NON\',\n  `quotationFaxNo` varchar(50) NOT NULL DEFAULT \'\',\n  `quotation_Mon` enum(\'T\',\'F\') NOT NULL DEFAULT \'T\',\n  `quotation_Tue` enum(\'T\',\'F\') NOT NULL DEFAULT \'T\',\n  `quotation_Wed` enum(\'T\',\'F\') NOT NULL DEFAULT \'T\',\n  `quotation_Thu` enum(\'T\',\'F\') NOT NULL DEFAULT \'T\',\n  `quotation_Fri` enum(\'T\',\'F\') NOT NULL DEFAULT \'T\',\n  `copyOver` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  `bar01` enum(\'T\',\'F\') NOT NULL DEFAULT \'T\',\n  `bar3103` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  `bar10` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  `bar15` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  `frozenQuotationCode` varchar(1) NOT NULL DEFAULT \'\',\n  `GLN` varchar(20) NOT NULL DEFAULT \'\',\n  `EDIEmail` varchar(50) NOT NULL DEFAULT \'\',\n  `auxID` varchar(25) NOT NULL DEFAULT \'\',\n  `quotationEUFreshCode` varchar(3) NOT NULL DEFAULT \'\',\n  `printEUFresh` varchar(1) NOT NULL DEFAULT \'F\',\n  `quotationEmailText` varchar(254) NOT NULL DEFAULT \'\',\n  `quotationEmailText2` varchar(254) NOT NULL DEFAULT \'\',\n  `quotationEmailText3` varchar(254) NOT NULL DEFAULT \'\',\n  `agentEmail` varchar(254) NOT NULL DEFAULT \'\',\n  `printHardCopy` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  `printSpainFresh` varchar(1) NOT NULL DEFAULT \'\',\n  `IC_baseRatePence` decimal(11,2) NOT NULL DEFAULT \'0.00\',\n  `IC_baseRatePC` decimal(11,2) NOT NULL DEFAULT \'0.00\',\n  `hasOrderNum` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\' COMMENT \'customers has internal order number (NOT cust reference)\',\n  `showBestBeforeOnInvoice` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  `invoiceFaxNo` varchar(20) NOT NULL DEFAULT \'\',\n  `invoiceFaxNo2` varchar(20) NOT NULL DEFAULT \'\',\n  `quotationNewlynEmail` varchar(250) NOT NULL DEFAULT \'\',\n  `newlynBaseRatePence` decimal(11,2) NOT NULL DEFAULT \'0.00\',\n  `newlynBaseRatePC` decimal(11,2) NOT NULL DEFAULT \'0.00\',\n  `newlynBaseRateCents` decimal(11,2) NOT NULL DEFAULT \'0.00\',\n  `quotationNewlynFreshCode` varchar(3) NOT NULL DEFAULT \'\',\n  `printNewlynFresh` varchar(1) NOT NULL DEFAULT \'\',\n  `splitPDFInvoice` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  `transportCompany` varchar(30) NOT NULL DEFAULT \'\',\n  `transportCompanyCode` varchar(20) NOT NULL DEFAULT \'\',\n  `hasOverDueBalance` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  `lastStatementDate` date NOT NULL DEFAULT \'0000-00-00\',\n  `GLNEDIIV` varchar(20) NOT NULL DEFAULT \'\',\n  `GLNEDIPR` varchar(20) NOT NULL DEFAULT \'\',\n  `statementEmailAddress` varchar(250) NOT NULL DEFAULT \'\',\n  `bestBeforeDateFormat` varchar(10) NOT NULL DEFAULT \'\',\n  `quotationIrishFreshCode` varchar(4) NOT NULL DEFAULT \'\',\n  `isInternal` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  `isCustomerRef` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  `excludeFromMailings` enum(\'T\',\'F\') NOT NULL DEFAULT \'F\',\n  PRIMARY KEY (`pkey`),\n  KEY `customerID` (`customerID`) USING BTREE,\n  KEY `countryID` (`countryID`) USING BTREE\n) ENGINE=InnoDB AUTO_INCREMENT=573721 DEFAULT CHARSET=latin1 COMMENT=\'fIELDS TO BE DELETED WHEN READY\\r\\n\\r\\nClassification\\r\\nCreditFlag\\r\\ndeliveryTerms\\r\\nExcess\\r\\ninvoiceLang\\r\\nlabelFormat\\r\\nquotationLang\\r\\nsalesTemp\\r\\ntradingTermsID\\r\\ntransact_userID\\r\\ncustomerRefFlag\\r\\nprintBonDeLivraison\\r\\nprintBonDeTransport\\r\\nkebabBestBeforeDays\\r\\nsmokedBestBeforeDays\\r\\ncopyOver\\r\\n\\r\\n\\r\\n\\r\\nFields to be deleted once new customerquotations is live\\r\\nbaseRatePence\\r\\nbaseRatePC\\r\\nbaseRateCents\\r\\nquotationComm\\r\\nquotationEmail\\r\\nQuotationEMailFrozen\\r\\nquotationFaxNo\\r\\nquotation_Mon\\r\\nquotation_Tue\\r\\nquotation_Wed\\r\\nquotation_Thu\\r\\nquotation_Fri\\r\\nfrozenQuotationCode\\r\\nquotationEUFreshCOde\\r\\nprintEUFresh\\r\\nquotationEmailText\\r\\nquotationEmailText2\\r\\nquotationEmailText3\\r\\nprintSpainFresh\\r\\nIC_baseRatePence\\r\\nIC_baseRatePC\\r\\nquotationNewlynEMail\\r\\nnewlynBaseRatePence\\r\\nnewlynBaseRatePC\\r\\nnewlynBaseRateCents\\r\\nquotationNewlynFreshCode\\r\\nprintNewlynFresh\\r\\n\''
'groups', 'CREATE TABLE `groups` (\n  `ID` varchar(3) NOT NULL DEFAULT \' \',\n  `name` varchar(30) NOT NULL DEFAULT \' \',\n  `invInstructions` varchar(100) NOT NULL DEFAULT \' \',\n  `inUse` varchar(25) DEFAULT \' \',\n  `lastUsedBy` varchar(25) DEFAULT \' \',\n  `pkey` int(11) NOT NULL AUTO_INCREMENT,\n  `creditReference` varchar(10) DEFAULT NULL,\n  `creditLimit` decimal(12,2) DEFAULT \'0.00\',\n  PRIMARY KEY (`pkey`)\n) ENGINE=InnoDB AUTO_INCREMENT=1986 DEFAULT CHARSET=latin1'

Thanks again for your help with this. Much appreciated,

John

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Query times out when I add extra Where Condition
128
January 27, 2020 04:28AM


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.