SQL query to update multiple records simultaneously

Here I’m going to show you a SQL query by which you can update multiple records at the same time. The snapshot below shows the data that is currently available in the table.

The query below would update two records with different value for the Location field. You can also see the data in the table after the update.

All you need to know about Marketing :)

A Professor explained Marketing to MBA students

1. You see gorgeous girl in party, you go to her & say I am rich marry me That’s Direct Marketing.
2. You attend party & your friend goes to a girl & pointing at you tells her. He’ is very rich, marry him – That’s Advertising.
3. Girl walks to you & says u are rich, ca…n u marry me? “That’s Brand Recognition”
4. You say I m very rich marry me & she slaps u “That’s Customer Feedback”
5. You say I m very rich marry me & she introduces you to her husband “That’s Demand & Supply Gap”
6. Before you say I m rich, marry me, your wife arrives, That’s Restriction from Entering New Market.

Guess now you got what it takes to Market something. You need to be rich. 😛