Page 100 - Computer Software Application TP - Volume 1

COMPUTER SOFTWARE APPLICATION - CITS

To find the structure of a table called employee, you can use the MySQL DESCRIBE command:
DESCRIBE employee;

3 Insert Query: Adding new records to the table
INSERT INTO your table name (column1, column2, column3)
VALUES (‘value1’, ‘value2’, ‘value3’);
Ex: INSERT INTO employee(first name, last name)
VALUES (‘Bob’, ‘Smith’);

For show the records
SELECT * FROM employee;

85

CITS : IT & ITES - Computer Software Application - Exercise 27