DDL and DML MySQL Exercises

Exercises on Data Manipulation Language (DML) & Data Definition Language (DDL) 1. Write a SQL statement to create a simple table countries including columns country_id,country_name and region_id. Solution 2. Write a SQL statement to create a simple table countries including columns country_id,country_name and region_id which is already exists. Solution 3. Write a SQL statement to create the structure … Read more

Python Environment Setup

Environment Setup Python is available on a wide variety of platforms including Linux and Mac OS X. Let’s understand how to set up our Python environment. Local Environment Open a terminal window and type “python” to find out if it is already installed and which version is installed. Downloading Python You can download Python from https://www.python.org/downloads/. … Read more

PHP Function Return Type Declarations

PHP Function Return Type Declarations PHP 7 also supports Type Declarations for the return statement. Like with the type declaration for function arguments, by enabling the strict requirement, it will throw a “Fatal Error” on a type mismatch. To declare a type for the function return, add a colon ( : ) and the type right before the opening … Read more