Error message

------=_NextPart_000_0009_01C51F72.7BAC9D50
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

Error 1064 Message,

I'm new to MySQL and I have a very simple test database in Access that I'm
trying to replicate in MySQL. There are three tables: Clients, Orders and
Catalog. When I set up queries using each of these tables individually in
Access as well as combinations using two and the all three of the tables,
everything runs fine. When I try it in MySQL, everything works until I
include the Catalog table, which I describe below:


Field Type Length/Values Null

ItemID varchar 10 not null

ItemDesc varchar 50 not null


Whenever I include this table and try to run the SQL query or even try to
run a query using only that table, I get a message that says:

SELECT Catalog.ItemID, Catalog.ItemDesc
FROM [Catalog]
LIMIT 0 , 30

#1064 - You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use near
'[Catalog] LIMIT 0, 30' at line 2

Am I missing something basic here?

Thanks,
Peter



Peter Crosby CIH, CSP, CHMM
Exposure Assessment Strategies, Inc.
www.eastrat.com
973-655-0145

"Protecting Your Most Important Assets..."



------=_NextPart_000_0009_01C51F72.7BAC9D50--

Re: Error message

First requirement: what level of MySQL?!

But try LIMIT 0 OFFSET 30, according to Sec 6.4 of the 4.1.1alpha doc..

HTH, G.


----- Original Message -----
From: "Peter Crosby"
To: "'MySqlWin32'"
Sent: Wednesday, March 02, 2005 9:55 PM
Subject: Error message


> Error 1064 Message,
>
> I'm new to MySQL and I have a very simple test database in Access that I'm
> trying to replicate in MySQL. There are three tables: Clients, Orders and
> Catalog. When I set up queries using each of these tables individually in
> Access as well as combinations using two and the all three of the tables,
> everything runs fine. When I try it in MySQL, everything works until I
> include the Catalog table, which I describe below:
>
>
> Field Type Length/Values Null
>
> ItemID varchar 10 not null
>
> ItemDesc varchar 50 not null
>
>
> Whenever I include this table and try to run the SQL query or even try to
> run a query using only that table, I get a message that says:
>
> SELECT Catalog.ItemID, Catalog.ItemDesc
> FROM [Catalog]
> LIMIT 0 , 30
>
> #1064 - You have an error in your SQL syntax. Check the manual that
> corresponds to your MySQL server version for the right syntax to use near
> '[Catalog] LIMIT 0, 30' at line 2
>
> Am I missing something basic here?
>
> Thanks,
> Peter
>
>
>
> Peter Crosby CIH, CSP, CHMM
> Exposure Assessment Strategies, Inc.
> www.eastrat.com
> 973-655-0145
>
> "Protecting Your Most Important Assets..."
>
>
>



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Error message

Don't enclose the table name Catalog in the square brackets, they are
not required in mysql. Cheers.

Armando

Graeme St.Clair wrote:
> First requirement: what level of MySQL?!
>
> But try LIMIT 0 OFFSET 30, according to Sec 6.4 of the 4.1.1alpha doc..
>
> HTH, G.
>
>
> ----- Original Message ----- From: "Peter Crosby"
> To: "'MySqlWin32'"
> Sent: Wednesday, March 02, 2005 9:55 PM
> Subject: Error message
>
>
>> Error 1064 Message,
>>
>> I'm new to MySQL and I have a very simple test database in Access that
>> I'm
>> trying to replicate in MySQL. There are three tables: Clients, Orders
>> and
>> Catalog. When I set up queries using each of these tables
>> individually in
>> Access as well as combinations using two and the all three of the tables,
>> everything runs fine. When I try it in MySQL, everything works until I
>> include the Catalog table, which I describe below:
>>
>>
>> Field Type Length/Values Null
>>
>> ItemID varchar 10 not null
>>
>> ItemDesc varchar 50 not null
>>
>>
>> Whenever I include this table and try to run the SQL query or even try to
>> run a query using only that table, I get a message that says:
>>
>> SELECT Catalog.ItemID, Catalog.ItemDesc
>> FROM [Catalog]
>> LIMIT 0 , 30
>>
>> #1064 - You have an error in your SQL syntax. Check the manual that
>> corresponds to your MySQL server version for the right syntax to use near
>> '[Catalog] LIMIT 0, 30' at line 2
>>
>> Am I missing something basic here?
>>
>> Thanks,
>> Peter
>>
>>
>>
>> Peter Crosby CIH, CSP, CHMM
>> Exposure Assessment Strategies, Inc.
>> www.eastrat.com
>> 973-655-0145
>>
>> "Protecting Your Most Important Assets..."
>>
>>
>>
>
>
>

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org