CST 1204 Chapter Notes - Chapter 3: Unique Key

54 views1 pages

Document Summary

Inserting a row insert into rep values ("45", "tian", "hui", "1785 tyler ave", "northfield", "ca", "90098", 27789. 25, 0. 06); Insert a row for certain columns insert into rep (rep_num, last_name, first_name) values ("75", "parry", "annabel"); Types of data string (n) number of string spaces char (n) number of char spaces decimal (abc, cd) first number is the length of the whole decimal, second number is the length of the decimal places. "" = null in the inputs (no space!!) Update - update a value in a table. Set last_name = "perry" where rep_num = "35"; Delete from rep where rep_num="75"; table and column names must start with a letter primary key means also not null not null - input cannot be null.

Get access

Grade+20% off
$8 USD/m$10 USD/m
Billed $96 USD annually
Grade+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
40 Verified Answers
Class+
$8 USD/m
Billed $96 USD annually
Class+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
30 Verified Answers

Related Documents

Related Questions