Create Table in MySQL Database

Use your database manager and create the below table in your MySQL database

Use the script below to create the table in you MySQL database

************ MySQL Script**********************

CREATE TABLE mykaddata (

guestid INT AUTO_INCREMENT PRIMARY KEY,

identification VARCHAR(40),

guestname VARCHAR(50),

address1 VARCHAR(40),

address2 VARCHAR(30),

address3 VARCHAR(30),

town VARCHAR(30),

state VARCHAR(30),

postcode VARCHAR(20),

country VARCHAR(30),

nationality VARCHAR(40),

oldicno VARCHAR(30),

ethnicity VARCHAR(20),

religion VARCHAR(20),

placeofbirth VARCHAR(40),

dateofbirth DATE,

dateofissue DATE,

gender VARCHAR(20),

timein DATETIME,

photo MEDIUMBLOB,

computername VARCHAR(60),

ipaddress varchar(16)

);

************ MSSQL Script**********************