On Tuesday 10 June 2014 15:19:56 Roberto Spadim wrote:
Hi guys, i'm running slackware 14.1, i upgrade to slackware-current,
and downloaded the mariadb-10.0.11 x64 with glibc 2.19
the point is... whern i run mysql, it requires a 'deprecated' library,
libtinfo.so.5, this one was replaced by
Hi, Roberto!
On Jun 10, Roberto Spadim wrote:
Hi guys, i'm running slackware 14.1, i upgrade to slackware-current,
and downloaded the mariadb-10.0.11 x64 with glibc 2.19
the point is... whern i run mysql, it requires a 'deprecated' library,
libtinfo.so.5, this one was replaced by
hi sergei! :)
the glibc is slackware glibc version
and the package was from mariadb, glibc 2.14+ , i downloaded it yesterday
mariadb-10.0.11-linux-glibc_214-x86_64.tar.gz (requires GLIBC_2.14+)
Guys, i'm with a newbie question
I need to swap a primary key value, for example:
create table test (
id int not null default 0,
other varchar(255) not null default '',
primary key(id)
);
insert into test (1,'a');
insert into test (2,'b');
now i want that (2,'b') becomes (1,'b') and (1,'a')
The MariaDB project is pleased to announce the immediate availability
of MariaDB Galera Cluster 10.0.11
This is a Beta release. See the Release Notes and Changelog for
details.
- - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
MariaDB Galera Cluster 10.0.11
- Release
On Wed, Jun 11, 2014 at 8:32 PM, Roberto Spadim robe...@spadim.com.br wrote:
Guys, i'm with a newbie question
I need to swap a primary key value, for example:
create table test (
id int not null default 0,
other varchar(255) not null default '',
primary key(id)
);
insert into test
ok it with a innodb/transactional table
what about a aria/myisam/connect/federated table?
2014-06-12 0:45 GMT-03:00 Pavel Ivanov piva...@google.com:
On Wed, Jun 11, 2014 at 8:32 PM, Roberto Spadim robe...@spadim.com.br
wrote:
Guys, i'm with a newbie question
I need to swap a primary key
I think you need to explain better what the big task is. This
particular problem is solved with this:
update test set other = case
when other = 'a' then 'b'
when other = 'b' then 'a'
end;
I wonder though how would this be different from two different updates
if MySQL gets interrupted after
that's the point, i think aria have a log before commit, and myisam commit
at everychange
must check, maybe the only possible method is transactional or aria, i will
try
2014-06-12 0:57 GMT-03:00 Pavel Ivanov piva...@google.com:
I think you need to explain better what the big task is. This
update test set id = case
when id = '1' then '2'
when id = '2' then '1'
end;
/* Erro SQL (1062): Duplicate entry '2' for key 'PRIMARY' */
2014-06-12 1:26 GMT-03:00 Roberto Spadim robe...@spadim.com.br:
that's the point, i think aria have a log before commit, and myisam commit
at
aria and myisam don't support
2014-06-12 1:27 GMT-03:00 Roberto Spadim robe...@spadim.com.br:
update test set id = case
when id = '1' then '2'
when id = '2' then '1'
end;
/* Erro SQL (1062): Duplicate entry '2' for key 'PRIMARY' */
2014-06-12 1:26 GMT-03:00 Roberto Spadim
alter table test engine=innodb;
begin;
update test set id = case
when id = '1' then '2'
when id = '2' then '1'
end;
commit;
/* Erro SQL (1062): Duplicate entry '2' for key 'PRIMARY' */
2014-06-12 1:28 GMT-03:00 Roberto Spadim robe...@spadim.com.br:
aria and myisam don't support
i think neither the first idea should work...
alter table test engine=innodb;
begin;
update test set id = 1 where id=2;
/* Erro SQL (1062): Duplicate entry '1' for key 'PRIMARY' */
update test set id = 2 where id=1;
commit;
2014-06-12 1:29 GMT-03:00 Roberto Spadim robe...@spadim.com.br:
Note, that I didn't say to change id, I said to change 'other'.
On Wed, Jun 11, 2014 at 9:30 PM, Roberto Spadim robe...@spadim.com.br wrote:
i think neither the first idea should work...
alter table test engine=innodb;
begin;
update test set id = 1 where id=2;
/* Erro SQL (1062): Duplicate
14 matches
Mail list logo