Question: php 2.1 Create Table: CREATE TABLE MyGuests id INT(6) PRIMARY KEY, firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL, email VARCHAR(50), reg_date TIMESTAMP ) 5

 php 2.1 Create Table: CREATE TABLE MyGuests id INT(6) PRIMARY KEY,
php

2.1 Create Table: CREATE TABLE MyGuests id INT(6) PRIMARY KEY, firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL, email VARCHAR(50), reg_date TIMESTAMP ) 5 2.2 Do Insert: INSERT INTO MyGuests (id, firstname, lastname, email) VALUES (1, 'John', 'Doel 'john@example.com') Insert 2 or more similar rows into the table. 2.3 Do queries: 2.3.1. Get all rows from the table. 2.3.2 Get the row(s) with the firstname as 'John 24 Do Update: UPDATE MyGuests SET lastname='Doe' WHERE id=2 2.5 Do Delete: DELETE FROM MyGuests WHERE id=3

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!