INSERT INTO Suggestion SELECT partnumber,qty from Sales Limit 1,100;
DVP
Dathan Vance Pattishall http://www.friendster.com
> -Original Message-
> From: C.F. Scheidecker Antunes [mailto:[EMAIL PROTECTED]
> Sent: Thursday, July 29, 2004 2:01 PM
> To: [EMAIL PROTECTED]
> Subject:
Hi,
You can use
Insert into Suggestion
(column 1, column 2, column 3, ..)
SELECT partnumber,qty from Sales order by qty desc limit 1,100
Regards,
Laercio.
-Original Message-
From: C.F. Scheidecker Antunes [mailto:[EMAIL PROTECTED]
Sent: quinta-feira, 29 de julh
Ok, so I've broken down your problem into small, manageable steps.
First, users are provided with a box to enter a value (e.g. pumpkin) and the 1)ability
to select a ranking for pumpkin, or 2)the ability to select which old value (apefruit)
the new value-pumpkin-belongs above/below (scenarios 1
Rick,
this is fixed in 3.23.50. I changed InnoDB so that it ignores foreign key
checks on keys containing SQL NULL values.
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
See http://www.innodb.com for the online manual and latest news
