CREATE TABLE with SQL Command with PRIMARY KEY and FOREIGN KEY

 If we want to create table named "personal" with PRIMARY KEY and FOREIGN KEY then we can use below shown sql query :

CREATE TABLE personal(

id INT NOT NULL,

 name VARCHAR(50) NOT NULL,

 percentage INT NOT NULL,

 age INT NOT NULL,

 gender VARCHAR(1) NOT NULL,

 city INT NOT NULL,

 PRIMARY KEY(id),

 FOREIGN KEY(city) REFERENCES city(cid)

);

Comments

Post a Comment

Popular posts from this blog

Logical_Operators

  <?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...
Read more

Get Functions

  <?php //There are many Get Functions in PHP as shown below: //get_class, get_parent_class, get_class_methods, get_class_vars, get_object_vars, get_called_class, //get_declared_classes, get_declared_interfaces, get_declared_traits, class_alias class ParentClass {     function name ()     {         echo "Class Name : " . get_class ( $this ) . "<br>" ;   //Print the particualr Class Name         //Print the particular Parent Class Name as shown below:         echo "Parent Class Name : " . get_parent_class ( $this ) . "<br>" ;     } } class ChildClass extends ParentClass {     function __construct ()     {}     function myfunction ()     {}     function myfunction2 ()     {} } $obj = new ChildClass (); $obj -> name (); echo "Class Name is : " . get_class ( $obj ) . "<br>" ; echo "Paren...
Read more

print_Statement

  <?php     echo "Hello, Welcome Everyone" ;     echo "<b>Hello" , "World</b>" ;     echo "<h1>Hello" . " brother</h1>" ;     echo "<h1><i>Let's" . " come</i></h1>" ;     echo 2364789 ;     echo 43.98 ; //  OUTPUT: // Hello, Welcome EveryoneHelloWorld // Hello brother // Let's come // 236478943.98 Hello World ? > < html >     < head >         < title > PHP </ title >     < head >     < body >         <?php             echo "Hello World" ;         ? >     </ body > </ html >
Read more