MySQL REPLACE doesn't works how expected

Question

My table (name is primary key, id is unique key):

||   name   || id ||    col_1    ||
===================================
||  test1   ||1234||   test999   ||

Query:

REPLACE INTO `table` (`name`, `col_1`) VALUES ('NOTTEST1', 'test999').

In this case, it mustn't replace row, but it does. What am I doing wrong?

http://stackoverflow.com/questions/19820724/replace-into-query-syntax — Lucky Chingi, Nov 16 '15 at 21:40
I know it. In my case there is no same primary key, but it replaces. — Nitor, Nov 16 '15 at 21:56
You just said yourself that name is your primary key in the question. — Ultimater, Nov 16 '15 at 22:06

score 0 · Answer 1 · answered Nov 16 '15 at 22:10

It works well!

can you check if table structure is set correctly. Here's what I did:

Table:

CREATE TABLE `test` (
  `name` varchar(25) NOT NULL,
  `id` int(11) DEFAULT NULL,
  `col_1` varchar(25) DEFAULT NULL,
  PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

insert  into `test`(`name`,`id`,`col_1`) values ('test1',1234,'test999');

And when I tried this:

REPLACE INTO test (`name`,`col_1`) VALUES('test11','admin');

It created a new record.

MySQL REPLACE doesn't works how expected

1 Answers1