MySQL Functions
MySQL has many built-in MySQL Functions. This reference contains string, numeric, date, and some advanced functions in MySQL. MySQL String […]
SQL
SQL
SQL Constraints
SQL Constraints are the rules enforced on the data columns of a table. These are used to limit the type
SQL
SQL Keywords
This SQL keywords reference contains the reserved words in SQL. Keyword Description ADD Adds a column in an existing table
SQL
SQL TEMP TABLE
The concept of temporary SQL TEMP TABLE is introduced by SQL server. It helps developers in many ways: Temporary tables(
SQL
SQL COPY TABLE
SQL COPY TABLE : If you want to copy a SQL table into another table in the same SQL server
SQL
SQL TRUNCATE TABLE
SQL TRUNCATE TABLE : A truncate SQL statement is used to remove all rows (complete data) from a table. It
SQL
SQL ALTER TABLE
SQL ALTER TABLE Statement The ALTER TABLE statement is used to add, delete, or modify columns in an existing table.
SQL
SQL RENAME TABLE
SQL RENAME TABLE syntax is used to change the name of a table. Sometimes, we choose non-meaningful name for the table.
SQL
SQL DROP Table
The SQL DROP TABLE statement is used to remove a table definition and all the data, indexes, triggers, constraints and permission specifications
SQL
SQL CREATE Table
The SQL CREATE TABLE Statement The CREATE TABLE statement is used to create a new table in a database. Syntax