Author: mfadmin

LIKE 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

Database

Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.LIKE operator (SQL),”in SQL —[…]

Read more

Create 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)

Database

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 more

SQL 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

Database

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 more

Constraint (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

Database

Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Constraint (SQL),”A rule associated with[…]

Read more

Insert (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’

Database

Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Insert (SQL),”The insert statement is[…]

Read more