![](https://img-blog.csdnimg.cn/20201014180756918.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sql
myazq
这个作者很懒,什么都没留下…
展开
-
数据库批量更新 删除
--批量更新 update stuMarks set writtenExam=(case when writtenExamthen writtenExam+5 else 100 end); update stuMarks set labExam=(case when labExam<95 then labExam+5 when labExam>=95 then 100原创 2017-03-28 16:07:19 · 284 阅读 · 0 评论 -
数据库 视图
use test1; CREATE VIEW resulet1 AS SELECT 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 评论 -
mysql查询表所有列名
mysql查询表所有列名,并用逗号分隔 SELECT GROUP_CONCAT(COLUMN_NAME SEPARATOR ",") FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'db_name' AND TABLE_NAME = 'table_name' 修改红色部分为自己数据库的名字和表名字 ...原创 2019-10-09 15:54:03 · 799 阅读 · 0 评论