01-31-2008, 01:12 PM
|
#10 (permalink)
|
|
The Prestige
Join Date: Dec 2007
Posts: 1,044
Thanks: 193
|
Quote:
Originally Posted by buggabill
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? |
I was trying to list some news entries, then show a checkbox to delete it or edit it. :/
__________________
VillageIdiot can have my babbies ;d
|
|
|
|