Säg jag har denna
Kod:
CREATE TABLE mysql_test (
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
firstname VARCHAR(30) NOT NULL,
lastname VARCHAR(30) NOT NULL,
email VARCHAR(50),
reg_date TIMESTAMP
);
INSERT INTO `mysql_test` (`id`, `firstname`, `lastname`, `email`, `reg_date`) VALUES ('1', 'Jsdfohn', 'Doe', 'john.doe@sqltest.net', CURRENT_TIMESTAMP);
INSERT INTO `mysql_test` (`id`, `firstname`, `lastname`, `email`, `reg_date`) VALUES ('2', 'Jddohn', 'Doe', 'john.doe@sqltest.net', CURRENT_TIMESTAMP);
INSERT INTO `mysql_test` (`id`, `firstname`, `lastname`, `email`, `reg_date`) VALUES ('3', 'Josssshn', 'Doe', 'john.doe@sqltest.net', CURRENT_TIMESTAMP);
INSERT INTO `mysql_test` (`id`, `firstname`, `lastname`, `email`, `reg_date`) VALUES ('4', 'Jofffffhn', 'Doe', 'john.doe@sqltest.net', CURRENT_TIMESTAMP);
Jag vill nu uppdatera alla rader för firstname till "test", allt annat ska vara oförändrat. Detta fungerar inte
Kod:
UPDATE mysql_test SET `firstname`='test';
select * from mysql_test;
Det kan lika gärna vara 100 rader.