SQL language

SQL language

creat

    
    
CREATE TABLE User(
	name VARCHAR(128),
	email VARCHAR(128)
)

insert

    
    
INSERT INTO User(name,email) VALUES('Kristin','kf@umich.edu')

delete

    
    
DELETE   FROM User WHERE email='ted@umich.edu'

update (if it doesn't have, it won't change)

    
    
UPDATE User SET name='Charles' WHERE email='csev@umich.edu'

select

    
    
SELECT * FROM User WHERE email='csev@umich.edu'
SELECT * FROM User ORDER BY email

count

    
    
SELECT COUNT(*) FROM User