Learn MySQL: Basics of MySQL Language by Vanamala Srinivas

Author:Vanamala, Srinivas [Vanamala, Srinivas]
Language: eng
Format: epub
Published: 2020-03-19T16:00:00+00:00

Add some data to the fees table.

3.2 Drop a Table

Dropping a table means deleting a table.

DROP is a keyword to delete the table.

SQL SYNTAX:

DROP TABLE <TABLENAME>

SQL QUERY:

DROP TABLE ‘fees’;

Step 1: Create a new Table ‘fees’ with ID and Amount Fields

Step 2: Add some Data to the ‘fees’ Table

Step 3: Delete the ‘fees’ table

* * *

3.3 INSERT Statements

INSERT is a keyword to INSERT the data in the table.

SQL SYNTAX:

INSERT INTO table_name VALUES (value1 , value2 , value3) ;

SQL QUERY:

INSERT INTO fees VALUES(10, 86);

Exercise:

Add some data to the fees table.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.