黑马程序员——数据库视频笔记

关注

原创最新推荐文章于 2026-05-26 12:31:10 发布 1.4k 阅读 AI 写同款· GEO 优化 ›

【笔记】黑马程序员 MySQL数据库入门到精通 —— 基础篇_实践创建： create database b1;#查询： show databases;查询所有数据库 select . database() 查询当前使用的数据库 show create database db1;查看数据库b1的创建语句 # 删除： Drop database db1; 阅读详情

之前有过数据库基础，所以数据库的做的有点少
use stu
insert into T_Student(Name,Age)
values('Y%K',29),
      ('kkkk',23),
      ('aaa啊啊',20),
      ('saha1',23),
      ('aadfaa啊啊',20),
      ('haha2',23),
      ('awetra啊啊',20),
      ('hgha2',23),
      ('aghj',20),
      ('haha4',23),
      ('aaaghj啊5',80)

select Top (50) percent * from T_Student

delete from T_Student where Age=23

update T_Student set Age=Age+100,AiHao='Speak' where Age<25

select * from T_Student where Name='YZK'

select Name as 姓名,GETDATE() from T_Student

select MAX(Age) as maxAge,MIN(Age) as minAge from T_Student

select COUNT(*),MIN(Age) from T_Student where Age>100

select top 6 * from T_Student

select * from T_Student

select * from T_Student where Name like 'Y%'

select * from T_Student where Name like 'a%k'

select * from T_Student where Name like '%k%'

显示刚插入数据的id
insert into T_Student(Name,Age) output inserted.Id values('元芳',180)

收录于