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
扫一扫
512
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
