I would like to copy the values from each record in the Program table to =
another table (tblPrograms). This is the syntax I came up with:=20
select * from Program insert tblPrograms set ProgramCode=3DLocation, =
ProgramName=3DDescription;
However, it fails without telling me why. Perhaps someone could correct me =
or re-direct me on this issue?
Thank you.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw