![](https://img-blog.csdnimg.cn/20201014180756930.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sql语句
myazq
这个作者很懒,什么都没留下…
展开
-
数据库批量操作 数据复制sql语句
--insert into 新表名(列名)--select 原列名--from 原表--导数据insert into StudentAddress(StudentNo,phone,[address],Email)select StudentNo,phone,[address],Emailfrom Student;select * from studentAddr原创 2017-03-27 18:07:14 · 882 阅读 · 0 评论 -
数据库批量更新 删除
--批量更新update stuMarkssetwrittenExam=(case whenwrittenExamthenwrittenExam+5 else 100end);update stuMarksset labExam=(casewhen labExam<95then labExam+5 when labExam>=95 then 100原创 2017-03-28 16:07:19 · 284 阅读 · 0 评论 -
数据库 事物
CREATE TABLE al(id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,name VARCHAR(50) NOT NULL,money DOUBLE UNSIGNED);insert into al VALUES(null,'小刘',1500);insert into al VALUES(null,'小张',100);原创 2017-06-28 19:01:26 · 174 阅读 · 0 评论 -
数据库 视图
use test1;CREATE VIEW resulet1ASSELECT stu.StudentNo,stu.StudentName from grade g,result r,student stu,`subject` sub where g.GradeId=stu.GradeId AND stu.StudentNo=r.StudentNo AND r.Subje原创 2017-06-28 19:02:03 · 237 阅读 · 0 评论