Re: database question

joe@jWebMedia.com wrote: > > > http://www.mysql.com/documentation/mysql/bychapter/manual_Compatibility.html#Missing_SELECT_INTO_TABLE > > Select into table isn't supported in mysql, however, there are ways > aroud it. Check the link, it gives a few options. > > Joe Although "SELECT INTO TABLE" is not supported you can still use "INSERT INTO SELECT". The syntax is: INSERT [LOW_PRIORITY | DELAYED] [IGNORE] [INTO] tbl_name [(col_name,...)] SELECT ... Look here for details: http://www.mysql.com/documentation/mysql/commented/manual.php?section=INSERT - Jesper Juhl juhl@eisenstein.dk