PHP MYSQL Evidance Exam

Evidence MYSQL

Q1. Create a table name Student with the following field’s        

                                                                                                        12

 id – type integer, size 10, auto increment ,primary key

name- type string, size 20, not null

email- type string , size 20, not null

address- type string, size 100, null

password- type string ,size 50, null

and unique email

Note: engine-myisam

Q2. Insert five records to Student table

 

                                                                                              7

Q3. Show the records

                                                                                                                                                         1