MySQL
The following tables have already been created for you. Eachtable is already populated with some records.
Table Name: person
Field———————- Type——————– Notes
person_id—————-int(8)——————– ? Primarykey ? Auto-increment value ? Required
first_name————– varchar(25)———— ? Required
last_name————- varchar(25)———— ? Required
Table Name: contact_list
Field——————– Type——————— Notes
connection_id——– int(8)——————- ? Primary key ?Auto-increment value ? Required
person_id————– int(8)—————– ? Required
contact_id————- int(8)—————— ? Required
Table Name: message
Field——————- Type——————– Notes
message_id———– int(8)—————- ? Primary key ?Auto-increment value ? Required
sender_id————– int(8)—————– ? Required
receiver_id————- int(8)————— ? Required
message————— varchar(255)—— ? Required
send——————_datetime datetime—- ? Required
Task 1: Insert Record to the Person Table
Construct the SQL statement to add yourself to the Person table.Note: You are required to add yourself as a
PayPal Gateway not configured
PayPal Gateway not configured