SQL stands for ?
SQL stands for ?
Structured Query Language
Create a database called Mydatabase;
CREATE DATABASE Mydatabase;
CREATE a table called Employees (ID (key), Name, Salary
CREATE TABLE employees ( ID INTEGER PRIMARY KEY, Nom TEXT, Poste TEXT, Salaire FLOAT, Date_Embauche DATE );
ADD 2 entries to employees
UPDATE Employes SET Name ='Maria', Salary=50000 WHERE ID =1 SET Name= 'TOM', Salary=30000 WHERE ID =2
ADD a column 'TASK'
ALTER employees ADD COLUMN TASK Text;
DROP the column 'TASK'
ALTER TABLE Employees DROP Column Task;
Select entire table from a database ?
SELECT * FROM name_of the database; i.e. SELECT * FROM German_class;
Select columns "Writing" and "ORAL"
SELECT Writing, Oral FROM German_class; columsnames are called fields in SqL and rows are called records
Select unique entries in a column
SELECT DISTINCT Writing FROM German_class
SELECT rows that contains "pass"?
SELECT * FROM German_class WHERE writing="pass"
How do you say SELECT not (!= in R)
WHERE NOT Writting="pass"