Search for a command to run...
Articles tagged with #sql
Motivation learning what is transaction Transaction is a unit of work, that we want to be treated as a whole. We want either it completes or it should fail. Lets say we have bought some momo's from a shop and we are now paying it with the upi. So thi...
Learning Use the below mentioned query to insert multiple records this is the fastest way available. -- don't add "UNION ALL" statement on the last line INSERT INTO mytable(companyid, category, sub, catalogueref) SELECT '10197', 'cat', 'sub', '123' U...
Motivation I daily read blogposts and one of the guy with 700 post motivated me write every single day. How to insert data in a table insert into employee (empid,empname) values(1,'sandy'); How to insert data only in some columns insert into employee...
So Today we will be learning and practicing the subquery
