HELP: HOW TO - Duplicate ROW content to new ROW

[camarosource]

I am wondering if there is a way to DUPLICATE (MOST) of the contents in a mysql (phpmyadmin) ROW into a new row? Obviously not duplicate the primary since that needs to be unique.

I just need to know if there is a SQL to duplicate the fields and contents from one row to a new row. I can easily specifiy the FIELD's if needed (be better if I can specify like a " * " but a phrase to exclude some fields. BUT I CANNOT specify the CONTENTS of the fields. That would defeat the purpose. Basically a SQL Query in simple terms:

SELECT * from [TABLE] EXCEPT [FIELDS, FIELDS, FIELDS, FIELDS] where [MID (primary field) = "### into a NEWLY CREATED ROW with the contents into this new ROW.

Thanks,

Paul

[Roger_Ramjet]

INSERT SELECT

[camarosource]

INSERT INTO camaro_models (1305, engine_id, trans_id, std_engine, opt_engines, year, car_type, trim_type, man_plant, front_susp,
rear_susp, steering, front_tires, rear_tires, front_brake_type, rear_brake_type, wheelbase, length, width, height, front_tread, rear_tread,
ground_clearance, front_headroom, rear_headroom, front_legroom, rear_legroom, front_shoulderroom, rear_shoulderroom, front_hiproom,
rear_hiproom, std_transmission, opt_transmission, exhaust_system, rear_axle_ratio)

SELECT base_model, engine_id, trans_id, std_engine, opt_engines, year, car_type, trim_type, man_plant, front_susp, rear_susp, steering, front_tires, rear_tires, front_brake_type, rear_brake_type, wheelbase, length, width, height, front_tread, rear_tread, ground_clearance,
front_headroom, rear_headroom, front_legroom, rear_legroom, front_shoulderroom, rear_shoulderroom, front_hiproom, rear_hiproom,
std_transmission, opt_transmission, exhaust_system, rear_axle_ratio FROM camaro_models WHERE mid = '1292';

Any idea why I am getting a

MySQL said:
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '1305, engine_id, trans_id, std_engine, opt_engines, year, car_t

Basically ROW 1305 (variable "MID") already exists with temp information. I am trying to copy ROW 1292 (Variable "MID") and overwrite MID 1305 with the information in 1292.

[Roger_Ramjet]

In that case use an update query.

[camarosource]

Roger Ramjet;10935135 wrote:

In that case use an update query.

I did that too...

UPDATE camaro_models (1305, engine_id, trans_id, std_engine, opt_engines, year, car_type, trim_type, man_plant, front_susp,
rear_susp, steering, front_tires, rear_tires, front_brake_type, rear_brake_type, wheelbase, length, width, height, front_tread, rear_tread,
ground_clearance, front_headroom, rear_headroom, front_legroom, rear_legroom, front_shoulderroom, rear_shoulderroom, front_hiproom,
rear_hiproom, std_transmission, opt_transmission, exhaust_system, rear_axle_ratio)

SELECT mid, engine_id, trans_id, std_engine, opt_engines, year, car_type, trim_type, man_plant, front_susp, rear_susp, steering, front_tires, rear_tires, front_brake_type, rear_brake_type, wheelbase, length, width, height, front_tread, rear_tread, ground_clearance,
front_headroom, rear_headroom, front_legroom, rear_legroom, front_shoulderroom, rear_shoulderroom, front_hiproom, rear_hiproom,
std_transmission, opt_transmission, exhaust_system, rear_axle_ratio FROM camaro_models WHERE mid = '1292';

Same thing..

[camarosource]

I'm confused then..

UPDATE camaro_models (engine_id, trans_id, std_engine, opt_engines, year, car_type, trim_type, man_plant, front_susp,
 rear_susp, steering, front_tires, rear_tires, front_brake_type, rear_brake_type, wheelbase, length, width, height, front_tread, rear_tread,
ground_clearance, front_headroom, rear_headroom, front_legroom, rear_legroom, front_shoulderroom, rear_shoulderroom, front_hiproom, 
rear_hiproom, std_transmission, opt_transmission, exhaust_system, rear_axle_ratio) WHERE mid = '1305'

SELECT mid, engine_id, trans_id, std_engine, opt_engines, year, car_type, trim_type, man_plant, front_susp, rear_susp, steering, front_tires, rear_tires, front_brake_type, rear_brake_type, wheelbase, length, width, height, front_tread, rear_tread, ground_clearance, 
front_headroom, rear_headroom, front_legroom, rear_legroom, front_shoulderroom, rear_shoulderroom, front_hiproom, rear_hiproom, 
std_transmission, opt_transmission, exhaust_system, rear_axle_ratio FROM camaro_models WHERE mid = '1292';

Tried this too.. Basically I want to update part of the information from row MID 1292 into row MID 1305..

[djjjozsi]

update syntax:

update table SET field1='somethingnew', field2='somethingnewin field 2' WHERE id=12345

[camarosource]

that is the thing, I'm COPYING content from one row to another row..

[djjjozsi]

if you have a table:
test id, a,b

INSERT INTO test (a,b)
    SELECT a,b
    FROM test t WHERE t.id=1;

Then create an update form.