Jerry,
Do you know of any reputable online classes that you could point me to?
Keith
On Tue, 2010-07-13 at 14:25 -0400, Jerry Schwartz wrote:
You might want to see if there are any online classes that could get you
started. I usually start by reading a big, thick book -- but I've found that
You can use an Alias in ORDER BY but not in WHERE clauses.
Keith
On Thu, 2010-06-10 at 16:38 -0400, Steven Staples wrote:
Ok, I have done it before, where I have used the AS result in an ORDER BY,
but now, I can't figure out why I can't use it in a WHERE clause?
SELECT `email`, (SELECT
missing?
Bob
On May 12, 2010, at 8:00 PM, Keith Clark wrote:
Hi Bob,
No, actually it does not. I'm looking for the count of items. From
your query example I only get two rows. This table has over 2 1/2 years
of daily sales data.
Maybe I'm not stating my question correctly...h
I'm trying to produce a report that will tell me how many products were
available with a Quantity0 before a certain date, and have that ordered
by date.
Table:
Date
Quantity
Result desired
DateQuantity Available
May 1 5000
May 2 5050
May 3 5075
Thanks,
Keith
--
MySQL General
Chris,
Here is my full table definition:
CREATE TABLE `products` (
`products_id` int(15) NOT NULL AUTO_INCREMENT,
`products_quantity` int(4) NOT NULL,
`products_model` varchar(15) NOT NULL DEFAULT '',
`products_image` varchar(64) DEFAULT NULL,
`products_price` decimal(15,4) DEFAULT NULL,
On Wed, 2010-05-12 at 10:13 -0400, Keith Clark wrote:
Chris,
Here is my full table definition:
CREATE TABLE `products` (
`products_id` int(15) NOT NULL AUTO_INCREMENT,
`products_quantity` int(4) NOT NULL,
`products_model` varchar(15) NOT NULL DEFAULT '',
`products_image` varchar(64
, 2010-05-12 at 19:46 -0500, Bob Cole wrote:
Keith:
Does this work?
SELECT products_date_available, COUNT(products_quantity)
FROM products
WHERE products_quantity 0
GROUP BY products_date_available
Hope this helps,
Bob
On May 12, 2010, at 3:06 PM, Keith Clark wrote
I have the following statement:
select chart_of_accounts.accountname as Account,
concat('$',format(coalesce(sum(sales_journal_entries.debit),0),2)) as
Debit,
concat('$',format(coalesce(sum(sales_journal_entries.credit),0),2)) as
Credit,
On Wed, 2010-04-28 at 00:18 +0200, Carsten Pedersen wrote:
Keith Clark skrev:
I have the following statement:
select chart_of_accounts.accountname as Account,
concat('$',format(coalesce(sum(sales_journal_entries.debit),0),2)) as
Debit,
concat('$',format(coalesce(sum
without the dollar
sign and order on that column.
Regards,
Gavin Towey
-Original Message-
From: DaWiz [mailto:da...@dawiz.net]
Sent: Tuesday, April 27, 2010 3:46 PM
To: Keith Clark; mysql@lists.mysql.com
Subject: Re: order by numeric value
Try
order by CAST(Balance
On Wed, 2010-04-28 at 08:57 +1000, Jesper Wisborg Krogh wrote:
On Wed, 28 Apr 2010 08:53:57 Keith Clark wrote:
But I'd prefer not to see the extra sorting field.
You don't need to select a field in order to be able to order by it.
So
select chart_of_accounts.accountname as Account
I have two tables and I have data to insert into both at the same time,
but the second table depends on an ID that is auto created in the first
table. I'm not sure exactly how to accomplish this.
Table_One
Table_One_Index_ID
Data_One
Date_Two
Table_Two
Table_Two_Index_ID
Table_One_Index_ID
Johan,
That seems to be the ticket. Thanks!
Keith
On Fri, 2010-03-12 at 16:54 +0100, Johan De Meersman wrote:
Have a look at last_insert_id().
On Fri, Mar 12, 2010 at 3:48 PM, Keith Clark
keithcl...@k-wbookworm.com wrote:
I have two tables and I have data to insert into both
I'm trying to edit one of my stored procedures using MySQL Query Browser
and this is what I get back as a listing when I select Edit All
Procedures:
DROP PROCEDURE IF EXISTS `kwbo4418_2008bookworminventory`.`UpdateStock`
$$
/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='' */ $$
(null) $$
14 matches
Mail list logo