select from one table, put into another

[vocoder]

I have a couple of questions.

first is

what would be the sql (using mysql) to select 2 fields from one table and then take those results and put them in a new table?

example i have state and county in one table (plus lots of other fields that i'm not interested in)..well, i made a new table and need to put those same results in a new table that has different fields but does include those same 2.

my other question would be, say i have a field that includes a number that is based on a month/day/year (but is not used as a date field)...so like 10112003...10122003 , etc etc...now what i want to do is select that field and if possible i need to break up that number and put it in a new table that has 3 different fields...ie, 10 would go in the 1st field, 11 would go in the 2nd field, and 2003 would go in the 3rd field......is that even possible?

[leatherback]

Hi,

How about:

$query = "select field1, field2 from table1";

$result = mysql_query($query);

while ($row =@ mysql_fetch_array($result))
{

$insQuery = "insert into table2 (field1, field2) values ($row[field1], $rowfield2])";

$insert=mysql_query($insQuery);

}

For the second question: You coudl convert the number into a string variable, and then use (?) substr() to get hte right section.

J