I'm curious --- why do you have the extra parentheses in there, anyway?
Short answer: Because I'm a newbie to MySQL and I get confused easily.
Longer answer: Because I'm not very clear on the use of brackets. I
thought they defined parameters for a command. So, for example, INSERT
takes a
Have you tried removing the brackets ( ) from around the fields in the
SELECT part of the query?
I did as you suggested and ran the query without brackets, and it worked
perfectly.
Thank you for the speedy and helpful advice!
Dave
--
MySQL General Mailing List
For list archives: http://l
At 13:19 +0900 9/13/05, Dave wrote:
(Topic moved from "Copying data stored in different field formats
from one table to another")
MySQL General List,
Server specifications:
MySQL 4.1.3-beta, phpMyAdmin 2.5.7-pl1, PHP 4.3.8
My specifications:
MySQL beginner, PHP intermediate, HTML and C
Dave wrote:
The situation:
While trying to copy data over from one table to another, I have
encountered the following error:
#1241 - Operand should contain 1 column(s)
The query that I used which led to this error was this:
INSERT INTO forum_members( dateRegistered, realName, ID_MEMBE
(Topic moved from "Copying data stored in different field formats from
one table to another")
MySQL General List,
Server specifications:
MySQL 4.1.3-beta, phpMyAdmin 2.5.7-pl1, PHP 4.3.8
My specifications:
MySQL beginner, PHP intermediate, HTML and CSS advanced.
The situation:
Whil