<?php $age = 20 ; $age1 = 25 ; if ( $age >= 18 && $age <= 21 ) { echo "You are Eligible<br>" ; } if ( $age >= 18 || $age <= 21 ) { echo "You are Eligible<br>" ; } //Below condition is True So that "Not Operator(!)" will return False condition if (!( $age >= 18 )) { echo "You are Eligible<br>" ; } //Below condition is False So that "Not Operator(!)" will return True condition if (!( $age <= 18 )) { echo "You are Eligible<br>" ; } //If both condition is "True" OR "False" at that time xor will return "False" and if one condition is //"True" and s...
In "personal" table, there are 6 columns named id, name, percentage, age, gender, city. In "personal" table, column name "id" is PRIMARY KEY and column name "city" is FOREIGN KEY. In "courses" table, there are 2 columns named course_id and course_name. In "courses" table, column name "course_id" is PRIMARY KEY. In "city" table, there are 2 columns named cid and cityname. In "city" table, column name "cid" is PRIMARY KEY. In "lecturers" table, there are 6 columns named id, name, percentage, age, gender, id_of_personal. In "lecturers" table, column name "id" is PRIMARY KEY and column name "id_of_personal" is FOREIGN KEY. UNION and UNION ALL Syntax : SELECT column1, column2 FROM table1 UNION/UNION ALL SELECT column1, column2 FROM table2; RULES : 1) Each SELECT statement within UNION must have the same number of columns. 2) The columns must also have ...
Comments
Post a Comment