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
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
Get step-by-step solutions from verified subject matter experts
