Grzegorz Paszka <[EMAIL PROTECTED]> wrote:
> Hi.
>
> I use MySQL 4.0.17 from rpm.
> When I want insert new row by perl script to one of my table I get such error :
> DBD::mysql::st execute failed: Duplicate entry '- Modified the spec file provided by
> ...' for key 3
> Table looks :
> mysql>
Hi.
I use MySQL 4.0.17 from rpm.
When I want insert new row by perl script to one of my table I get such error :
DBD::mysql::st execute failed: Duplicate entry '- Modified the spec file provided by
...' for key 3
Table looks :
mysql> desc spak;
+--++--+-+-
Hi all,
i have an application writing bulk inserts periodically to a MyISAM
table. This table has a multi-column index on two integer fields, in
this way i can have an good query speed. Bulk insert are very speed, but
when the table grows up to 20/25 MB, almost the inserts have a very slow
spe
> Hi,
I have a Mysql database with one Master and one slave
> I have a problem with the following table "session":
> +--+-+--+-+-+---+
> | Field | Type | Null |
> Key | Default | Extra |
> +---
Hi,
assume a table as follows:
CREATE TABLE Posts (
Board varchar(100) NOT NULL,
Number int(11) unsigned NOT NULL auto_increment,
Posted int(11) unsigned DEFAULT '0' NOT NULL,
Subject text,
Body text,
PRIMARY KEY (Number),
KEY index1 (Number, Board),
KEY index2 (Board),
t: Problem with index, where clause and order by
Hi,
assume a table as follows:
CREATE TABLE Posts (
Board varchar(100) NOT NULL,
Number int(11) unsigned NOT NULL auto_increment,
Posted int(11) unsigned DEFAULT '0' NOT NULL,
Subject text,
Body text,
PRIMARY KEY (Nu
Hi,
assume a table as follows:
CREATE TABLE Posts (
Board varchar(100) NOT NULL,
Number int(11) unsigned NOT NULL auto_increment,
Posted int(11) unsigned DEFAULT '0' NOT NULL,
Subject text,
Body text,
PRIMARY KEY (Number),
KEY index1 (Number, Board),
KEY index2 (Board),