Error 1032 : Can't find Record in

Hello, I'm curently testing partitioning with mysql 5.1.11 on linux (.rpm from mysql.com site). Table Structure: CREATE TABLE `adr-0` ( Adr varchar(255) COLLATE latin1_german1_ci NOT NULL DEFAULT '', Qty int(10) NOT NULL, PRIMARY KEY (Adr), ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE

Insert into table select * ... union

Hello, I'm collecting data into a very simple table with one varchar(100) field ("myValue") and one int(10) field ("Qty"). I'm doing this with a simple "insert into . on duplicate key update qty = qty +1". After the table has reached a count of several 10 million records every insert takes

RE: error 1064 when trying to create table

Hi, You are using a reserved function name "AREA" (polygon function) as a fieldname. Simply change the field's name or try using quotes around it... Detlev > [...] > FOREIGN KEY (A_areaNum) REFERENCES Area(areaNum), > [...] > Any ideas? -- MySQL General Mailing List For list archives: