Save the particular div in PDF format onclick using Jquery

MYSQL functions are useful while performing mathematical calculations, string concatenations, sub-strings etc. SQL provides many built in functions to performe these functionality or performing calculations on data. The most commonly used MySQL functions including:

Aggregate functions
String functions
Date time functions
control flow functions

TRUNCATE COMMAND

The SQL truncate command is used for delete all the data from an existing table. TRUNCATE table is similar to DELETE command in sql with no where clause.

SYNTAX

TRUNCATE TABLE table_name

Here is an Example explaining it.

truncate table Employee;

The above query will delete all the records of Employee table.

DROP COMMAND

The SQL DROP command is used for completely removes a table from database. This command also destroy the table struncture also. It is used to remove a table definition and all data, indexes, triggers, constraints, and permission specifications for that table.

SYNTAX

drop table table_name

Here is an Example explaining it.

drop table Employee;

The above query will delete the Employee table completely.

The DROP command can also be used on Databases.

SYNTAX

drop database database_name;

Here is an Example explaining it.

drop database Organization;

The above query will drop a database named Organization from the system.

RENAME COMMAND

rename command is used to rename a table.

SYNTAX

rename table old-table-name to new-table-name

old-table-name:Specifies the name of the table to be renamed.

new-table-name:Specifies the new name of the table.

Here is an Example explaining it.

rename table Employee to Employee_details;

The above query will rename Employee table to Employee_details.