TalkPHP - View Single Post - Dozens of questions which I cannot find. v_v

buggabill · 01-31-2008, 01:10 PM

I believe...if I am wrong, someone correct me, please..to insert data from a SELECT query into another table do something like the following:

SQL Code:

INSERT INTO 
    generals (name, rank, serialnum) 
SELECT 
    name, rank, serialnum 
FROM 
    allsoldiers
WHERE 
    rank="General"

The field names do not have to match, but the data type should.

By editing columns in a table, to what are you referring? Do you wish to change the data type or just the data in a specific column/field?

01-31-2008, 01:10 PM	#9 (permalink)
buggabill The Contributor Join Date: Jan 2008 Location: Maine, USA Posts: 92 Thanks: 2	I believe...if I am wrong, someone correct me, please..to insert data from a SELECT query into another table do something like the following: SQL Code: INSERT INTO generals (name, rank, serialnum) SELECT name, rank, serialnum FROM allsoldiers WHERE rank="General" The field names do not have to match, but the data type should. By editing columns in a table, to what are you referring? Do you wish to change the data type or just the data in a specific column/field? __________________ -- Bill "Why is it drug addicts and computer aficionados are both called users?" -Clifford Stoll