增:
INSERT
INTO
LoginInfo (
[ ID ] ,
[ Name ] ,
[ Pass ] ,
[ Sex ] ,
[ TrueName ] ,
[ Phone ] ,
[ Email ] ,
[ Address ] ,
[ TrueDatetime ] ) VALUES (ID, ' Name ' , ' Pass ' , ' Sex ' , ' TrueName ' , ' Phone ' , ' Email ' , ' Address ' , ' TrueDatetime ' )
[ ID ] ,
[ Name ] ,
[ Pass ] ,
[ Sex ] ,
[ TrueName ] ,
[ Phone ] ,
[ Email ] ,
[ Address ] ,
[ TrueDatetime ] ) VALUES (ID, ' Name ' , ' Pass ' , ' Sex ' , ' TrueName ' , ' Phone ' , ' Email ' , ' Address ' , ' TrueDatetime ' )
删:
DELETE
FROM
LoginInfo
WHERE < 搜索条件 >
WHERE < 搜索条件 >
改:
UPDATE
LoginInfo
set
[ ID ] = < ID > ,
[ Name ] = < Name > ,
[ Pass ] = < Pass > ,
[ Sex ] = < Sex > ,
[ TrueName ] = < TrueName > ,
[ Phone ] = < Phone > ,
[ Email ] = < Email > ,
[ Address ] = < Address > ,
[ TrueDatetime ] = < TrueDatetime > WHERE < 搜索条件 >
[ ID ] = < ID > ,
[ Name ] = < Name > ,
[ Pass ] = < Pass > ,
[ Sex ] = < Sex > ,
[ TrueName ] = < TrueName > ,
[ Phone ] = < Phone > ,
[ Email ] = < Email > ,
[ Address ] = < Address > ,
[ TrueDatetime ] = < TrueDatetime > WHERE < 搜索条件 >
查:
SELECT
*
FROM LoginInfo
SELECT [ ID ] , [ Name ] , [ Pass ] , [ Sex ] , [ TrueName ] , [ Phone ] , [ Email ] , [ Address ] , [ TrueDatetime ]
FROM LoginInfo
FROM LoginInfo
SELECT [ ID ] , [ Name ] , [ Pass ] , [ Sex ] , [ TrueName ] , [ Phone ] , [ Email ] , [ Address ] , [ TrueDatetime ]
FROM LoginInfo