List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:November 18 1999 2:31am
Subject:Re: Example problem
View as plain text  
At 11:54 AM +1100 11/18/99, Kevin Waterson wrote:
>In the MySQL (3.22.26) docs they give the following example:

This only works as of MySQL 3.23.

>CREATE TABLE test (a int not null auto_increment,
>                  primary key (a), key(b))
>                  TYPE=HEAP SELECT b,c from test2;
>The only problem is that when I run that exact example I get:
>ERROR 1064: You have an error in your SQL syntax near 'SELECT b,c from
>test2' at line 3
>Can anyone offer a clue on this?

Paul DuBois, paul@stripped
using index with or's..Alex Krohn18 Nov
  • Stored ProceduresChristian Schrader18 Nov
    • Example problemKevin Waterson18 Nov
      • Re: Example problemPaul DuBois18 Nov