Hi there,
I am about to create tools to maintain addresses (companies, persons, groups)
As this is probably done allredy a million times over I would like to ask if
somebody could point me from where I migth download the database structure for
such a feat or whether someone of you could provide
On Aug 12, 2008, at 2:30 AM, robert rottermann wrote:
Hi there,
I am about to create tools to maintain addresses (companies,
persons, groups)
As this is probably done allredy a million times over I would like
to ask if somebody could point me from where I migth download the
database
Jason Pruim schrieb:
On Aug 12, 2008, at 2:30 AM, robert rottermann wrote:
Hi there,
I am about to create tools to maintain addresses (companies, persons,
groups)
As this is probably done allredy a million times over I would like to
ask if somebody could point me from where I migth download
Hi all,
I try to generate a unique id for each row in a Mysql-InnoDB Table. Because of
many deletes I can’t use an auto_increment column.
After a Mysql restart, the next value for an auto_increment-column is
max(auto_increment-column)+1, and I need a really unique id.
My first solution
I strongly advise you to use an off-the-shelf solution. In fact, if you can
afford it you should go with a CRM vendor. They will have all kinds of
features, such as address duplication detection, that you will need.
An open-source system would only be a good alternative if it is easily
extensible
I try to generate a unique id for each row in a Mysql-InnoDB Table.
Because of many deletes I can't use an auto_increment column.
After a Mysql restart, the next value for an auto_increment-column is
max(auto_increment-column)+1, and I need a really unique id.
[JS] See if the UUID() function
Hello all,
We've experienced a MySQL problem, during which few of the tables got
corrupted. Because of this, few of the websites contained gibberish and we
had to restore from backup.
This problem was caused by overloaded CPU and unwritten data to the hard disk.
We are looking for a
Why would the auto_increment not work for you? The only case where you
would have a problem is if the last record was deleted before mysql
shutdown. If you are really concerned about this unique scenario,
insert a dummy record before shutdown to guard against it and delete
the dummy record after
You should be able to do it with the select you already have,
something like this:
delete ACCOUNTACTION from ACCOUNTACTION join (
select ACCOUNTACTION.ID from ACCOUNTACTION
where ACCOUNTACTION.ACTIONDATE like '2008-08-01 02:00%'
group by ACCOUNTACTION.ACCOUNT_ID
having
Hi,
there is a table with several trees in nested set form in it.
CREATE TABLE IF NOT EXISTS `posts` (
`id` int(11) unsigned NOT NULL auto_increment,
`root_id` int(11) unsigned NOT NULL,
`lft` int(11) unsigned NOT NULL,
`rgt` int(11) unsigned NOT NULL,
`date` datetime NOT NULL,
I agree with Jerry. Take a look at the UUID() function.
http://dev.mysql.com/doc/refman/5.1/en/miscellaneous-functions.html#function_uuid
Second Life (http://secondlife.com) uses UUIDs to track millions and millions
of unique items every day.
CheersFish
-Original Message-
From:
First, you might want to move the WHERE...t3.int_a = some integer
condition into the join condition for t3.
Your not using anything from t4, so I'm not sure why you have that
table in your query.
You can suggest or force mysql to use an index if it's using the wrong
one:
Hi all,
Connecting to mysql server (Production) is taking 5 to 6 seconds. Production
has 16Gb ram. Previously it was using only 6GB ram. The details are as
follows. DNS looks fine.
free -m
total used free sharedbuffers cached
Mem: 15899 15877
13 matches
Mail list logo