增:
INSERT INTO LoginInfo (
[ID] ,
[Name] ,
[Pass] ,
[Sex] ,
[TrueName] ,
[Phone] ,
[Email] ,
[Address] ,
[TrueDatetime] ) VALUES (ID,'Name','Pass','Sex','TrueName','Phone','Email','Address','TrueDatetime')
删:
DELETE FROM LoginInfo
WHERE <搜索条件>
改:
UPDATE LoginInfo set
[ID] = <ID>,
[Name] = <Name>,
[Pass] = <Pass>,
[Sex] = <Sex>,
[TrueName] = <TrueName>,
[Phone] = <Phone>,
[Email] = <Email>,
[Address] = <Address>,
[TrueDatetime] = <TrueDatetime> WHERE <搜索条件>
查:
SELECT *
FROM LoginInfo
![](http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif)
SELECT [ID],[Name],[Pass],[Sex],[TrueName],[Phone],[Email],[Address],[TrueDatetime]
FROM LoginInfo
posted @
2008-05-27 21:49
Silent's Blog
阅读(
1598)
评论()
编辑
收藏
举报