DML语句影响的表的所有行得到及时更新,TPL语句包括BEGIN ,TRANSACTION ,COMMIT(提交) ,ROLLBACK(回滚)等等;
补充学习:
1.大多数数据库软件系统都允许使用编程函数在结果集中进行导航...'台时华','2016级',19,'网络工程技术'),(1005,'爱是','2013级',19,'物联网工程');
INSERT INTO user_kc VALUES (1002,"Python编程...",79.1),(1001,"JAVA编程",89.5),(1003,"LINUX编程",69.5),(1002,"Mysql数据库编程",69.9),(1005,"网络编程",79.5),(1004,..."前端HTML5",79.5),(1002,"Python编程",79.5),(1004,"C语言之精华",59.5);
基础示例:
-- 联表查询
SELECT user.xh,user.xm,user.nj..., '成绩:', kc.grade) AS '成绩信息',
FROM user AS u,user_kc AS kc
WHERE kc.xh = u.xh AND kc.kcm = 'Python编程