This is set of simple operations each developer should know, what tutoring do you want?

|
mashaibumamlaka1 2021-11-16 16:44:58
Interesting, I thought it should?
MasterZiv 2021-11-16 16:45:13
You thought wrong
mashaibumamlaka1 2021-11-16 16:45:30
How best should it be written?
mashaibumamlaka1 2021-11-16 16:45:55
BEGIN Transaction
UPDATE item
SET item cost price = item cost price +200
WHERE itemID =001;
UPDATE item
SET itemCostPrice = itemCostPrice – 100, itemID=003
WHERE itemID =001;
UPDATE item
SET item cost price = item cost price – 20
WHERE itemID = 002;
COMMIT
MasterZiv 2021-11-16 16:45:56
I don’t understand the question.
mashaibumamlaka1 2021-11-16 16:46:27
mashaibumamlaka1 2021-11-16 16:45:55
BEGIN Transaction
UPDATE item
SET item cost price = item cost price +200
WHERE itemID =001;
UPDATE item
SET itemCostPrice = itemCostPrice – 100, itemID=003
WHERE itemID =001;
UPDATE item
SET item cost price = item cost price – 20
WHERE itemID = 002;
COMMIT

How best is this code supposed to be written to be able to generate an output?

MasterZiv 2021-11-16 16:46:47
mashaibumamlaka1 2021-11-16 16:46:27
How best is this code supposed to be written to be able to generate an output?

I don’t know

mashaibumamlaka1 2021-11-16 16:46:59
Damn!
MasterZiv 2021-11-16 16:47:18
whatafuck is that? one more stupid interview queston ?
mashaibumamlaka1 2021-11-16 16:47:25
I thought i would get some help on this number right here…
MasterZiv 2021-11-16 16:47:55
mashaibumamlaka1 2021-11-16 16:47:25
I thought i would get some help on this number right here…

ask a decent question and you can get help

mashaibumamlaka1 2021-11-16 16:47:56
MasterZiv 2021-11-16 16:47:18
whatafuck is that? one more stupid interview queston ?

No, its not.

I am generating a question to use for teaching…

MasterZiv 2021-11-16 16:48:54
mashaibumamlaka1 2021-11-16 16:47:56
No, its not.

I am generating a question to use for teaching…

then, this is still yet another stupid interview question.

mashaibumamlaka1 2021-11-16 16:49:31
mashaibumamlaka1 2021-11-16 16:41:38
What’s the output?

Here is the question.

The table show the original figures before a new transaction begins. What would be the output after the code is deployed?

MasterZiv 2021-11-16 16:50:23
mashaibumamlaka1 2021-11-16 16:49:31
Here is the question.

The table show the original figures before a new transaction begins. What would be the output after the code is deployed?

it is a bad question. But ok, I have said enough

mashaibumamlaka1 2021-11-16 16:52:17
Thanks mate
svart 2021-11-16 18:08:19
madno 2021-11-11 06:29:41
added innodb status
https://www.toptal.com/developers/hastebin/orobuwuwup.sql

Out of my knowledge. Sounds quite weird because seems that index pushdown does not work. Sorry can’t help here

private_String 2021-11-16 20:50:32
Hi, can i ask a question about deploy to heroku (clear db ignite) of java web app?
MasterZiv 2021-11-17 05:45:40
private_String 2021-11-16 20:50:32
Hi, can i ask a question about deploy to heroku (clear db ignite) of java web app?

This is chat for mySQL only

yadukrishna38 2021-11-17 11:22:56
mysql_en-14125.jpg
why rollback is not working in workbench
ColonelMustang 2021-11-17 14:26:42
How can I alter a table with Enum columns and convert it into a String?
MasterZiv 2021-11-17 17:06:26
ColonelMustang 2021-11-17 14:26:42
How can I alter a table with Enum columns and convert it into a String?

Only manually.
Create a new column, create a dictionary table and manyally remap values one-by one.
Then drop the old field

ColonelMustang 2021-11-17 18:37:56
MasterZiv 2021-11-17 17:06:26
Only manually.
Create a new column, create a dictionary table and manyally remap values one-by one.
Then drop the old field

Can you link me to a tutorial? I have never heard of dictionary table before this

MasterZiv 2021-11-17 18:43:31
ColonelMustang 2021-11-17 18:37:56
Can you link me to a tutorial? I have never heard of dictionary table before this

there is no tutorial

Kum Pra 2021-11-17 22:08:46
How do we create event funnels in mysql making sure a particular event occurs only after certain other event
rodrigo_tc7 2021-11-18 00:54:29
yadukrishna38 2021-11-17 11:22:56
why rollback is not working in workbench

Autocommit?

ColonelMustang 2021-11-18 06:37:36
MasterZiv 2021-11-17 18:43:31
there is no tutorial

No other online resource?

MasterZiv 2021-11-18 06:52:31
ColonelMustang 2021-11-18 06:37:36
No other online resource?

This is set of simple operations each developer should know, what tutoring do you want?

ColonelMustang 2021-11-18 14:50:34
MasterZiv 2021-11-18 06:52:31
This is set of simple operations each developer should know, what tutoring do you want?

I do not understand what you mean by dictionary table, nor do I get relevant MySQL related results from google

MasterZiv 2021-11-19 11:37:14
ColonelMustang 2021-11-18 14:50:34
I do not understand what you mean by dictionary table, nor do I get relevant MySQL related results from google

I mean the table that you will use as replacement for ENUM field.

ColonelMustang 2021-11-19 12:15:30
MasterZiv 2021-11-19 11:37:14
I mean the table that you will use as replacement for ENUM field.

Ah got it. Thanks

Rupesh Sase 2021-11-19 15:42:18
Anyone have mysql documents
piterden 2021-11-19 15:46:47
Rupesh Sase 2021-11-19 15:42:18
Anyone have mysql documents

What kind of documents do you mean?

Rupesh Sase 2021-11-19 15:49:16
I want to learn mysql dba activity so relevant to that
Rupesh Sase 2021-11-19 15:51:22
Database installation, monitoring
|