WARNING:
JavaScript is turned OFF. None of the links on this concept map will
work until it is reactivated.
If you need help turning JavaScript On, click here.
This Concept Map, created with IHMC CmapTools, has information related to: SQL Introduction, SQL-99 implemented by RDBMS, INSERT conditions If you are adding a value to every column, you don’t have to list them, DML Using Data Manipulation, Structure Query Language ANSI Standarts SQL-89, BIGINT() signed value -9223372036854775808 to 9223372036854775807, (NOT) IN See if a given value is in(or not in) a set of values Comparison (NOT) BETWEEN...AND... Check whether a value is within a range of values, Data Type number INT, [Column Name] column definition Data Type, UPDATE syntax UPDATE <table> SET col1 = val1 [,col2 = val2...] [WHERE <condition>], Timestamp Neither TIMESTAMP DEFAULT 0, Date sintax YYYY-MM-DD, UPDATE <table> SET col1 = val1 [,col2 = val2...] [WHERE <condition>] example UPDATE Student SET Year = 1, Name = ‘Jane’ WHERE ID = 4, Data Definition using DDL, TINYINT() unsigned value 0 to 255, Structure Query Language used for Data Manipulation, DELETE FROM <table> [WHERE <condition>] examples DELETE FROM Student WHERE Year = 2, (column list) AS: To display the column with a different name Column Expression DISTINCT: Used to get non repeated data ALL: Default value. Show all data, INSERT conditions The number of columns and values must be the same, BIGINT() unsigned value 0 to 18446744073709551615, (NOT) BETWEEN...AND... Check whether a value is within a range of values Syntax <expression> BETWEEN <value> AND <value>