Re: copy data from one table to another table [message #172822 is a reply to message #172821] |
Fri, 04 March 2011 02:49 |
bruceaj
Messages: 30 Registered: September 2010
Karma:
|
Member |
|
|
On Mar 3, 9:43 pm, Jerry Stuckle <jstuck...@attglobal.net> wrote:
> On 3/3/2011 9:39 PM, bruceaj wrote:
>
>
>
>> I have a table that I want to copy selected fields into another table.
>> The footprint of the tables is different. Here is the INSERT I am
>> trying to use.
>
>> An error is returned, "SQL Error (1136); Column count doesn't match
>> value count at row 1.
>> I've run the SELECT without the INSERT line and it does select the
>> data I want to copy.
>
>> Comparing the fields in "births"with the fields defined by the SELECT,
>> The only field that is missing is the primary key (birthid), which I
>> assumed the INSERT would fill in..
>
>> USE genealogyvr;
>
>> INSERT IGNORE INTO births
>> SELECT
>> NewspaperKey AS newspaperid,
>> CONCAT(Year, "-",
>> IF(Month< 10, CONCAT("0",Month), Month) ,
>> "-" ,
>> IF(Day< 10, CONCAT("0", Day), Day) ) AS paperdate,
>> Page AS page,
>> Col AS col,
>> FatherFirst AS fatherfirst,
>> FatherMiddle AS fathermiddle,
>> MotherFirst AS motherfirst,
>> MotherMiddle AS mothermiddle,
>> MotherMaiden AS mothermaiden,
>> First AS childfirst,
>> Middle AS childmiddle,
>> Last AS childlast,
>> DateOfBirth AS dob,
>> Comments AS comment
>
>> FROM birthsaccess
>> WHERE Year< 1890;
>
> This is a PHP newsgroup (hence the "php" in it's name).
>
> Try a newsgroup related to the database you're using.
>
> --
> ==================
> Remove the "x" from my email address
> Jerry Stuckle
> JDS Computer Training Corp.
> jstuck...@attglobal.net
> ==================
Okay.. Okay..
How about going over the mysql newsgroup where I've posted this
problem??
Thanks..
Bruce
|
|
|