I have a fairly simple query where I feel it takes too long to run.
SELECT Products.NSIPartNumber,Products.Cost, Products.ModelNo,
Products.USPrice, Products.VendorPart, Products.Description ,
Products.ProductID, Sum(tblInvTransaction.Qty) AS SumOfQty FROM Products
LEFT JOIN tblInvTransaction ON
In Access 2.0 and mySQL Products.ProductID is indexed but
tblInvTransaction.ProductID is not. I tried to set
tblInvTransaction.ProductID as indexed but it still took a long time.
>>> Daniel Kasak <[EMAIL PROTECTED]> 1/26/2004 12:18:46 PM
>>>
Jacque Scott wrote:
>I
having the
database open, but it can be idle. Comparing it to a local Access
database is not a comparable setup.
On Jan 26, 2004, at 1:35 PM, Jacque Scott wrote:
> I have a fairly simple query where I feel it takes too long to run.
>
> SELECT Products.NSIPartNumber,Products.Cost, Pr
open, but it can be idle. Comparing it to a local Access
database is not a comparable setup.
On Jan 26, 2004, at 1:35 PM, Jacque Scott wrote:
> I have a fairly simple query where I feel it takes too long to run.
>
> SELECT Products.NSIPartNumber,Products.Cost, Products.ModelNo,
&g
I am converting over to mySQL from Access 2.0 and I am having a little
trouble with a query. Here it is:
SELECT Max(WBS) AS LastOfWBS FROM Projects Where((WBS)) Like """ &
txtEntryData(0).Text & "#%"";
I am trying to get the last WBS ID starting with a particular letter
the user will type in th
r, # means one char and * means any
number of characters (?)
Good luck!
For Jacque Scott wrote:
I am converting over to mySQL from Access 2.0 and I am having a
littletrouble with a query. Here it is: SELECT Max(WBS) AS LastOfWBS
FROM Projects Where((WBS)) Like """ &txtEntryData
I had posted a message earlier this week about my 'Left Join' taking too
long to run. This seems to be happening on all of my queries that have
a 'Left Join'. Does anyone have any suggestions on why this would
happen?
Here is one query which took 45.72 sec to run:
SELECT Products.NSIPartNum
e the examples
as short as possible. I probably saw and ignored your earlier
question for that reason; I usually just skip messages where it
would take too long to decipher the question--I'd assume that other
people do the same.
HTH
Bill
> Date: Thu, 29 Jan 2004 08:03:25 -0800
> From
practice to use the where clause unless you really need
having.
You might really need having if you are selecting from the result based
on
group functions such as max() or count()--then, the values you are
testing
aren't available for the where clause to use.
- Original Message -
From:
I have a DateTime data type for one of my fields. If an entry is being
INSERTed then I want the DateTime to be NOW(). I want this done
automatically and not have to set me SQL str to do this. I have tried
to set the default as NOW() but it will insert
-00-00 ... I don't want this, I want th
I have a DateTime data type for one of my fields. If an entry is being
INSERTed then I want the DateTime to be NOW(). I want this done
automatically and not have to set me SQL str to do this. I have tried
to set the default as NOW() but it will insert
-00-00 ... I don't want this, I want th
I have a query where I want to display the column headings as row
headings.
Here is my query:
Code:SELECT DISTINCTROW Avg(DateDiff(OrderDate, POItem.ReceivedDate))
AS AvgLeadTime,
Min(DateDiff(Po.OrderDate, POItem.ReceivedDate)) AS MinLeadTime,
Max(DateDiff(Po.OrderDate, POItem.ReceivedDate)) A
I have the following query where the user will put in a date. They will
put it in like '01/01/04'. I use this date in my WHERE clause but MySQL
needs the date like '2004/01/01'. I tried using Date_Format('04/01/01',
'%Y-%m-%d') to change the way it is formatted but I don't get the
correct data b
I am converting from Access 2.0 to MySQL and I am going through all of
my code to make it compatible with MySQL. I was testing my Update for
one of my queries and I don't know if I found a bug or if MySQL was
designed to do this.
In my program I pass an UPDATE string to MySQL. There can be time
My program, NCR (Non-Conformity Report), keeps track of problems with
items that are received from vendors. I am creating a report where the
user can retrieve a list of vendors that have had a NCR written against
them a certain number of times. For example, if the user wants to see
what vendors h
That works. I knew I was missing something simple. It was the GROUP BY
and the HAVING together.
Thank you very much.
>>> Michael Stassen <[EMAIL PROTECTED]> 2/25/2004 9:05:34 AM
>>>
Jacque Scott wrote:
> My program, NCR (Non-Conformity Report), keeps track of pro
.webyog.com/sqlyog) to import
data from my access db to MySQL.
Karam
--- Jacque Scott < [EMAIL PROTECTED] > wrote:
> I have a .mdb file which I need to import into
> MySQL. This needs to be
> done behind the scenes and with code. Can I use
> LOAD DATA INFILE where
> I use the
I have a .mdb file which I need to import into MySQL. This needs to be
done behind the scenes and with code. Can I use LOAD DATA INFILE where
I use the .mdb file instead of a .txt file?
If not does anyone have any suggestions?
Thanks,
Jacque
I am trying to create a temporary table through code in my DB. I can do
it when I use MySQL Control Center or something like that, but when I
try to do it through my VB program it doesn't work.
Here is the sql string:
CREATE TEMPORARY TABLE IndenturedList (Level_1 TEXT, Level_2 TEXT,
Assembl
In my original post I didn't add that I close the connection just before
I exit the function.
If lngRecordAffected <> 0 Then ' if the execute was successful then
let's commit the updates
cn.CommitTrans
WriteData = lngRecordAffected
Else ' otherwise let's rollback to before
Try something like this:
SELECT ID, Name, Country
FROM peoplelist
GROUP BY Country
HAVING count(Country)>10;
That might work. Also you can have subselects in 4.0.
You are correct. Sorry about that.
>>> charles kline <[EMAIL PROTECTED]> 3/3/2004 2:46:51 PM >>>
sub selects are only in 4.1 I thought?
On Mar 3, 2004, at 5:08 PM, Jacque Scott wrote:
> Also you can have subselects in 4.0.
Table ProductSums has not been created. Can you create this table when
you insert data into it?
INSERT INTO ProductSums
SELECT DISTINCTROW IndenturedList.NSIPartNumber,
Sum(tblInvTransaction.Qty) AS SumOfQty
FROM IndenturedList;
OK, I found the answer.
CREATE TABLE ProductSums
SELECT DISTINCTROW IndenturedList.NSIPartNumber,
Sum(tblInvTransaction.Qty) AS SumOfQty
FROM IndenturedList;
I have a very simple query
SELECT ProblemReports.* FROM ProbelmReports;
If there is no data in the column 'Description' it returns 'x'. There
is no default value being used and there is no data in the field. Why
would it return 'x'? The field type is 'TEXT'. I have another 'TEXT'
field in t
j = 0
Next i
End If
>>> Victor Pendleton <[EMAIL PROTECTED]> 3/11/2004 1:15:45 PM >>>
Can you post some sample data and ddl?
-Original Message-
From: Jacque Scott
To: [EMAIL PROTECTED]
Sent: 3/11/04 3:12 PM
Subjec
I need to create a query that will sort by a alpha numeric field. I
need the ID field returned and one problem that I will face is that when
it sorts in alpha numeric the ID field will be out of sequence. I will
use this ID field in another part of the program so I need to make sure
I get all of
I have something like A001C, B689, B1001 etc...
>>> Dan Nelson <[EMAIL PROTECTED]> 3/23/2004 10:07:43 AM >>>
In the last episode (Mar 23), Jacque Scott said:
> I need to create a query that will sort by a alpha numeric field. I
> need the ID field returned and o
I will give that a try.
Thank you
>>> Dan Nelson <[EMAIL PROTECTED]> 3/23/2004 11:31:50 AM >>>
In the last episode (Mar 23), Jacque Scott said:
> I have something like A001C, B689, B1001 etc...
Aah. This question pops up about once a year, usually under the
I have a subquery where I am retrieving Shipment information from the
DB. I want to LIMIT the result to '1' but I first need the results in
'ID' order.
When I use this subquery I don't get the FIRST row because the data is
not in ID order:
(SELECT TextValue FROM tblQuoteItems WHERE (Type = 6
30 matches
Mail list logo
