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.
Este Cmap, tiene información relacionada con: SQLintroduction, (NOT) IN See if a given value is in(or not in) a set of values Syntax WHERE <value> IN|NOT IN <set>, SELECT Syntax SELECT [DISTINCT | ALL] <column-list> AS <column-name> FROM <table-names> <conditions>, (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, UPDATE <table> SET col1 = val1 [,col2 = val2...] [WHERE <condition>] example UPDATE Student SET Year = 1, Name = ‘Jane’ WHERE ID = 4, MEDIUMINT() unsigned value 0 to 16777215, Data Type time Date Time, INSERT INTO <table> [col1, col2, ...] VALUES (val1, val2, ...) example INSERT INTO Student (Name, ID) VALUES (‘Mary’, 2), DELETE is for Remove row(s) from a table, ENUM used for Chosen values from a list, VARCHAR used for Required memory only, DDL creating database CREATE DATABASE or CREATE SCHEMA, View Definition using VDL, INT 64bits BIGINT(), DML manipulates table with UPDATE, Important to note the precedence of operators This precedence can be changed with the use of brackets () Functions ROUND(X,D) Round the argument to D decimals (default is 0) TRUNCATE(X,D) Returns the number X, truncated to D decimal places (default is 0) POW(num) Return the argument raised to the specified power SQRT(num) Return the square root of the argument, INT() signed value -2147483648 to 2147483647, Structure Query Language ANSI Standarts SQL-99, [Table Name] column name [Column Name], Important to note the precedence of operators This precedence can be changed with the use of brackets () Operators +, -, /, *. DIV() Integer division % Returns the remainder of N divided by M, UPDATE conditions All rows where the condition is true have the columns set to the given values