SQL Reference

SQL Reference

10 - 50 downloads

Add this app to your lists
View bigger - SQL Reference for Android screenshot
View bigger - SQL Reference for Android screenshot
View bigger - SQL Reference for Android screenshot
View bigger - SQL Reference for Android screenshot
SQL Tutorial
All the SQL commands needed to control access to any database:

- SELECT: SELECT is used to query data.
- DISTINCT SQL: DISTINCT is used to eliminate duplicate data queries.
-SQL WHERE: WHERE is used include conditions for the data we want to consult.
- SQL AND OR: AND and OR are used to include 2 or more conditions to a query.
- SQL ORDER BY: ORDER BY is used to sort the query results.
- SQL INSERT: INSERT is used to insert data.
- SQL UPDATE: UPDATE is used to update or modify existing data.
- SQL DELETE: DELETE is used to delete data.
- SQL TOP: TOP is used to specify the number of rows to display in the result.
- SQL Lite: LIKE is used in the WHERE clause to search for a pattern.
-SQL Wildcards: Wildcards (wildcards) are special characters that are used to perform special searches.
- SQL IN: IN to select multiple values ​​in a WHERE clause.
- SQL BETWEEN: BETWEEN is used in the WHERE clause to select values ​​from a range of data.
- SQL ALIAS: ALIAS is used to rename a table or column
- SQL JOINS: JOIN can query data from 2 or more tables.
- SQL INNER JOIN: INNER JOIN is used to combine each row in a table with each row in another table.
- SQL LEFT JOIN: LEFT JOIN is used to combine the values ​​of the first table with the values ​​of the second table. Always return the rows in the first table.
- SQL RIGHT JOIN: RIGHT JOIN is used to combine the values ​​of the first table with the values ​​of the second table. Always return the rows in the second table.
- SQL FULL JOIN: FULL JOIN is used to combine the values ​​of the first table with the values ​​of the second table. Always return the rows from both tables.
- SQL UNION: UNION is used to accumulate the results of two SELECT statements.
- SQL UNION ALL: SQL UNION ALL is used to accumulate the results of two SELECT statements, even rows will be repeated.
- SQL SELECT INTO: SELECT INTO is used to copy data from one table to another table.
- SQL CREATE DATABASE: CREATE DATABASE is used to create databases.
- SQL RESTRICTIONS: Restrictions are used to limit the data type of a column.
- SQL NOT NULL: NOT NULL is used to specify that a column does not accept NULL.
- SQL UNIQUE: UNIQUE is used to uniquely identify each row in a table
- UNIQUE SQL ALTER TABLE: ALTER TABLE to add UNIQUE UNIQUE to a column of a table, after being created.
- SQL PRIMARY KEY: PRIMARY KEY is used to uniquely identify each row in a table.
- SQL FOREIGN KEY: FOREIGN KEY is used to identify a column that is primary key in another table.
- SQL CHECK: CHECK to limit the range of values ​​in a column.
- SQL DEFAULT: DEFAULT default value for a column
- SQL CREATE INDEX: CREATE INDEX to create an index on a table.
- SQL DROP: DROP erases any element (index, table or database).
- TRUNCATE SQL: TRUNCATE is used to erase the data (not structure) of a table
- SQL ALTER: ALTER is used to modify the definition of a column in a table.
- SQL AUTO INCREMENT: AUTO INCREMENT generating auto-incrementing number for a column in a table.
- SQL VIEWS: VIEWS serves to create a virtual table (not an actual table) with the results of a query.
- SQL DATES: DATE defines different data types for dates and times.
- SQL NULL VALUES: NULL represents an undefined value.
- SQL FUNCTIONS NULL: NULL FUNCTIONS used to use NULL values.
- SQL TEXT DATA MySQL: MySQL TEXT DATA defines the different formats of text fields for MySQL.
- SQL NUMERICAL MySQL: MySQL NUMERICAL DATA defines the different formats of numeric fields for MySQL.
- SQL MySQL DATA DATE: DATE DATA MySQL defines the different formats for date fields MySQL.

Tags: sql create, values used in query database in, sql auto increment in virtual table, sql reference, book mysql.

Comments and ratings for SQL Reference

  • There aren't any comments yet, be the first to comment!