Hi. On Tue, Feb 19, 2002 at 04:15:36AM +0300, [EMAIL PROTECTED] wrote: > > I am a total MySQL newbie using MySQL 3.22.32. [...] > create table temp1 > -> select field_x > -> from MyData; > > But, I get a syntax error (ERROR 1064) on line 2. > > Would somebody please point me at the right direction?
The syntax you try to use does not exist in 3.22.x. According to the change history, it has been implemented in 3.23.0: http://www.mysql.com/documentation/mysql/bychapter/manual_News.html So either upgrade to a more recent version like 3.23.48 (3.22.x is quite outdated meanwhile) or use two statements. If you continue using 3.22.32, you should use the manual that came with it as future reference, because the online version of the manual always documents the most current version. Bye, Benjamin. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
