what was the error?
"dwalker"
,
For some reason the Insert Select statement returned an ERROR and I had to
resort to
INSERT INTO Products
(ProductName,Size,SuggestedRetailPrice,ProductCategory,ManufacturerName)
SELECT *
FROM kalproduct ;
Is there a noticeable reason why:
INSERT INTO Products
(ProductName,Size,SuggestedRetail
That's how you do it. Hopefully you've figured it out already.
---John Holmes.
-Original Message-
From: dwalker [mailto:dwalker@;healthyproductsplus.com]
Sent: Saturday, October 19, 2002 7:51 PM
To: professional php; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL Ins
While reading the MySQL manual for INSERT SELECT, I was
not able to determine how to include all 5 fields of one table into another
table (containing 100 fields) into SPECIFIC data fields. Do I need to
explicitly list all the fields within the table of 5 fields? If so, would
the statement
There should really be another table for all of this information. Say
you're tracking school information for a specific person. That person
would have an ID number and you'd store the school information in a
separate table that stores the user's ID and the school ID. You could
even expand this to t
At 11:48 PM 10/18/02 -0500, Shiloh Madsen wrote:
For instance, a series of checkboxes with items such as abjuration,
conjuration, divination, and others, which will all have a numeric value
which gets plugged into the enum field. for instance, if a user selected
abjuration, and divination, i
Hi,
Saturday, October 19, 2002, 5:15:41 PM, you wrote:
JN> You know, I didn't even think about serializing the array. I have a
JN> table set up for spells, one for schools, and a linking table using the
JN> spell id and the school id(s). I could have done without the linking
JN> table. Some
7 matches
Mail list logo
