Latest tutorials

Page 80 of 105

AWS Lambda to stop an ec2 instance
AWS · Apr 22, 2019 · 2 min read
First you need to set up a role to execute lambda functions and also ec2 instance functions. Second you need to get your ec2 instance ids. Python 2.7 Java 8 Bring down ecs instances for off hours #!/usr/bin/env python “”” A Lambda Function to set the desired count of running tasks in a service […]
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- […]