Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Join (SQL),”Joins allow you to[…]
Read moreLatest Posts
Aggregate Functions
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review. Aggregate Functions MIN returns[…]
Read moreDrop (SQL)
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Drop (SQL) “The drop table[…]
Read moreDelete (SQL)
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Delete (SQL) “Delete data from[…]
Read moreUpdate (SQL),”Update a row in a table.General: update “”tablename””set “”columnname”” = “”newvalue”” [,””nextcolumn”” = “”newvalue2″”…]where “”columnname”” OPERATOR “”value”” [and|or “”column”” OPERATOR “”value””]; [] = optionalex. update phone_book set area_code = 623 where prefix = 979;update phone_book set last_name = ‘Smith’, prefix=555
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Update (SQL),”Update a row in[…]
Read moreInsert (SQL),”The insert statement is used to insert or add a row of data into the table.General: insert into “”tablename”” (first_column,…last_column) values (first_value,…last_value);ex. insert into employee (first, last, age, address, city, state) values (‘Luke’, ‘Duke’, 45, ‘2130 Boars Nest’, ‘Hazard Co’
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Insert (SQL),”The insert statement is[…]
Read moreConstraint (SQL),”A rule associated with a column that the data entered into that column must follow. For example, a “”unique”” constraint specifies that no two records can have the same value in a particular column. They must all be unique. The other two most popular constraints are “”not null”” which specifies that a column can’t be left blank
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Constraint (SQL),”A rule associated with[…]
Read moreSQL Data types,”char(size) Fixed-length character string. Size is specified in parenthesis. Max 255 bytes.varchar(size) Variable-length character string. Max size is specified in parenthesis.number(size) Number value with a max number of column digits specified in parenthesis.date Date valuenumber(size,d) Number value with a maximum number of digits of “”size”” total
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.SQL Data types,”char(size) Fixed-length character[…]
Read moreCreate table (SQL),”create table “”tablename””(“”column1″” “”data type””, “”column2″” “”data type””, “”column3″” “”data type””);ex. (see SQL data type card)create table employee(first varchar(15), last varchar(20), age number(3), address varchar(30), city varchar(20)
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Create table (SQL),”create table “”tablename””(“”column1″”[…]
Read moreLIKE operator (SQL),”in SQL — allows you to select only rows that are “”like”” what you specify. The percent sign “”%”” can be used as a wild card to match any possible character that might appear before or after the characters specified. select first, last, city from empinfo where first LIKE ‘Er%’;// matches any name where first name begins with Erselect first
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.LIKE operator (SQL),”in SQL —[…]
Read more