(Solved) : Mysql Following Tables Already Created Table Already Populated Records Table Name Person Q30001244 . . . .

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

mysql> SHOW TABLES;
+———————+
| Tables_in_messaging |
+———————+
| contact_list———– |
| image—————— |
| message————– |
| message_image— |
| person————— |
+———————+
5 rows in set (0.00 sec)

mysql> SELECT * FROM contact_list;
+—————+———–+————+———-+
| connection_id |