菁英数字科技（猩码）-猩码学苑-专注软件开发人才菁英教育

标题: 冯文直-前端-20230111 [打印本页]

作者: 。5962 时间: 2023-1-11 22:34
标题: 冯文直-前端-20230111

今日学习内容：

Navicat数据库的使用方法（增删改查）：

1.新建

Insert into student_list(name,password,sex,age,tel) values("蜻蜓队长","986","男",168,12345678901);

2. 删除

delete from student_list where id=571;

删除全部信息：delete from student;

3. 更新信息

update student_list set name="胡歌",password="852",sex="男",age=38,tel=56239874125 where id=569;

4.查询

select name,age from student_list; 查询name和age

SELECT * from student_list; 查询全部信息

select * from student_list where age>100;

select * from student_list where name="小花";

select * from student_list where age between 200 and 300;

select * from student_list where sex <> "女";

select * from student_list where sex = "女";

select * from student_list where age >= 800;

select * from student_list where age < 20;

SELECT * from student list where (name="小花" age>999)&&(sex!="男");

SELECT *from student list where sex!="男";

SELECT * from student list where name="小花"&&age>2;

二、今日问题：上课让写的《综合实践项目A》只完成了部分内容，大部分的Js内容未完成，希望老师予以讲解。

三、解决方案：无

欢迎光临菁英数字科技（猩码）-猩码学苑-专注软件开发人才菁英教育 (http://www.xingmaxueyuan.com/)