Latest tutorials

Page 149 of 164

MySQL If
SQL · Apr 12, 2019 · 1 min read
IF function The IF function is used to evaluate an expression and return a value. The IF function consists of three parts. 1. condition to evaluate.2. expression(can be another IF function) or value if the condition is evaluated to true.3. expression(can be another IF function) or value if the…
MySQL Explain
SQL · Apr 10, 2019 · 1 min read
MySQL Stored Procedure
SQL · Apr 9, 2019 · 2 min read
Stored procedures are SQL statements that you can save into a database and reuse over and over again. Syntax to create a stored procedure. To execute a store procedure, call its name. Advantages of Stored Procedures Fast as stored procedures can be cached and the big queries can be reduced to one…
MySQL Group By
SQL · Apr 6, 2019 · 1 min read
The GROUP BY clause is used to group sets of rows into groups and returns only one row from each group. It is mostly used with aggregate functions but it does not have to. sdfsd GROUP BY with aggregate functions AVG – average value of a columnSUM – sum value of a columnMAX- […]
Git merge
Git · Apr 5, 2019 · 1 min read
The merge command is used to bring together changes from two branches. For example, if you have a feature branch that is branched off of the master branch. When you are done with that feature branch you can use the merge command to merge it back to master. We will assume receiving-branch to be […]