В Чтв, 30.09.2004, в 00:37, [EMAIL PROTECTED] пишет:
> I have another technique for this kind of data merge that speeds things up
> (a lot!) but it requires a third table to make it work
>
> Please post the results of SHOW CREATE TABLE for both the source data
> table and the destination data table and I will show you how it works.
I dont have two tables - only one...
for example:
create table links (
link varchar(20) not null default '',
count int not null default 0,
primary key(link)
)
And I need count how many times each link is clickes... trivial...
But my main trouble is 'Duplicates'...
Another example... I have table:
create table ipsinouts (
ip int not null,
inout enum('in', 'out') not null,
sitefaceid int not null,
cnt tinyint not null,
primary key (inout, ip, sitefaceid)
)
'in' mean incoming to site, in this case sitedfaceid field mean
FACE(some page) ID. 'out' mean OUT to other site(traffic trade) and
sitefaceid mean SITE ID... ip is ip2long(...) result...
So, there is I have sometime duplicates for key, but I dont see
theoretical reasons for this errors :(((
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
