6.1 插入數(shù)據(jù)
語法:
INSERT INTO `表名` (
`字段1`,
`字段2`,
`字段3`,
……
`字段n`,
)
VALUES (
'字段1的數(shù)據(jù)',
'字段2的數(shù)據(jù)',
'字段3的數(shù)據(jù)',
……
'字段n的數(shù)據(jù)',
)
示例:
INSERT INTO `Student`(
`StudentName`,
`Cellphone`,
`Description`,
`InUser`,
`LastEditUser`
)
VALUES(
'黃曉明',
'13212345678',
'演什么都是黃曉明',
'admin',
'admin'
);
6.2 刪除數(shù)據(jù)
語法:
DELETE FROM `表名`
WHERE `條件字段1` = '條件字段1的值'
AND `條件字段2` = '條件字段2的值',
AND `條件字段3` = '條件字段3的值',
……
AND `條件字段n` = '條件字段n的值';
示例:
DELETE FROM `Student` WHERE StudentID=3;
說明:
對于刪除條件(WHERE),應(yīng)根據(jù)實(shí)際業(yè)務(wù)诬乞,需要幾個(gè)字段就寫幾個(gè)字段册赛。
6.3 修改數(shù)據(jù)
語法:
UPDATE `表名` SET
`字段1` = '字段1的值',
`字段2` = '字段2的值',
`字段3` = '字段3的值',
……
`字段n` = '字段n的值'
WHERE `條件字段1` = '條件字段1的值'
AND `條件字段2` = '條件字段2的值',
AND `條件字段3` = '條件字段3的值',
……
AND `條件字段n` = '條件字段n的值';
示例:
UPDATE `Student` SET
`Cellphone` = '13312345678',
`Description` = '演什么都是黃曉明,湊活看吧。'
WHERE StudentID=3;
說明:
對于更新條件(WHERE)丽惭,應(yīng)根據(jù)實(shí)際業(yè)務(wù)击奶,需要幾個(gè)字段就寫幾個(gè)字段。