Paste the SQL commands you wrote to create the table: Paste a screen shot shows

Question

Paste the SQL commands you wrote to create the table: Paste a screen shot shows the created table in MyPHPAdmin: Answer: Paste a screen shot shows the data you added to the "thlActor": {"actors": [{"name.": "Brad Pitt", "description": "Brad Pitt is an American actor and film producer. He has received a Golden Globe Award, a Screen Actors Guild Award, and three Academy Award nominations in acting categories", "dob": "December 18, 1963", "country."United States", "image"." http: \ ors.com\brad.jpg"}, {"name": "Tom Cruise", "description": "Tom Cruise, is an American film actor and producer. He has been nominated for three Academy Awards and has won three Golden Globe Awards.", "dob": "July 3, 1962", "country": "United States", "image": "http: \Actors.com\tom.jpg"}, {"name": "Angelina Jolie", "description": "Angelina Jolie is an American actress, film director, screenwriter,

Explanation / Answer

[1]

CREATE TABLE tblActor
{
name         VARCHAR(20),
description VARCHAR(100),
dob          DATE,
country      VARCHAR(20),
image        NVARCHAR(100)
}

[2]

INSERT INTO tblActor
VALUES ('Leonardo DiCaprio','Titanic Actor','11-NOV-1974','American')

INSERT INTO tblActor
VALUES ('Tom Hanks','The Green Mile Actor','09-JUL-1956','American')

INSERT INTO tblActor
VALUES ('Will Smith','Independence Day Actor','25-SEP-1968','American')

INSERT INTO tblActor
VALUES ('Tom Cruise','Top Gun Actor','03-JUL-1962','American')

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---