Is such a request possible?

Question

MySQL

SET @ba = SELECT sum(balans+200) FROM `test_db_vytrat` WHERE id = 10;

INSERT INTO `test_db_vytrat` (`id`, `data`, `cat`, `oper`, `suma_oper`, `balans`, `note`) VALUES (NULL, '2014-10-25', '4', 'dec', '150', @ba, 'hb');

I need to calculate the balance, I want to do it with one request, but how?

Answer 1

In general, he did.

SELECT @ba:= (balans + СУМА) FROM `test_db_vytrat` ORDER BY `id` DESC LIMIT 0 , 1;
INSERT INTO `test_db_vytrat` (`id`, `data`, `cat`, `oper`, `suma_oper`, `balans`, `note`) VALUES (NULL, '2014-10-25', '4', 'dec', '150', @ba, 'hb');

Answer 2

Swap ssd and hdd. That is, insert a system disk into the disk compartment, and a hard disk as storage into the optibay. These are jokes with Optibey such.
Well, unless of course you run several systems from different disks.

Answer 3

time works in Windows - do not touch! finish the game - the next post on the toaster will be - "the computer does not see any disks. neither HDD, nor SSD ... nothing ... what to do ?!"

Answer 4

1. Try changing cables
2. Try updating the ssd firmware

Answer 5

there was an article about optibey on habré or gigtimes, there were jumpers under the casing, maybe this will help.