dbTalk Databases Forums  

error 1064 at USING BTREE

comp.databases.mysql comp.databases.mysql


Discuss error 1064 at USING BTREE in the comp.databases.mysql forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jivanmukta
 
Posts: n/a

Default error 1064 at USING BTREE - 10-19-2010 , 08:21 AM






MySQL 5.0.51a-3ubuntu5.7 doesn't accept USING BTREE in CREATE TABLE.

ERROR 1064 (42000): 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 'USING
BTREE,
KEY `index_client_name` (`payer_name`) USING BTREE
) ENGINE=InnoD' at line 13

The instruction CREATE TABLE was generated by another MySQL.

CREATE TABLE `statement_positions` (
`statement_no` varchar(20) NOT NULL COMMENT 'Numer wyciagu',
`position_no` smallint(6) NOT NULL COMMENT 'Numer pozycji',
`announcement_year` smallint(4) DEFAULT NULL COMMENT 'Rok
ogloszenia',
`announcement_month` tinyint(2) DEFAULT NULL COMMENT 'Miesiac
ogloszenia',
`announcement_no` int(5) DEFAULT NULL COMMENT 'Numer ogloszenia',
`payer_name` varchar(61) DEFAULT NULL COMMENT 'Nazwa / imie nazwisko
klienta',

`title` varchar(20) NOT NULL COMMENT 'Tytul operacji',
`amount_paid` decimal(5,2) NOT NULL COMMENT 'Kwota operacji',
`payment_date` date NOT NULL COMMENT 'Data operacji',
PRIMARY KEY (`statement_no`,`position_no`),
KEY `index_statement_no` (`statement_no`),
KEY `index_year_month_announcement_no`
(`announcement_year`,`announcement_mont
h`,`announcement_no`) USING BTREE,
KEY `index_client_name` (`payer_name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin2 COMMENT='Pozycje na wyciagu
bankowym';

Maybe diagnostics is not right?
Please help.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.