Page 100 - Computer Software Application TP - Volume 1
P. 100

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
   95   96   97   98   99   100   101   102   103   104   105