MySQL基本练习
来源:互联网 发布:一知f君2月13号 编辑:程序博客网 时间:2024/05/17 04:30
CREATE DATABASE school;
USE school;
CREATE TABLE student(
id INT(4),
NAME VARCHAR(20) NOT NULL,
grade FLOAT
);
INSERT INTO student(id,NAME,grade)VALUES(1,”zhangsan”,98.5);
INSERT INTO student(NAME,grade,id)VALUES(“lisi”,32.1,2);
INSERT INTO student(id,NAME,grade)VALUES(3,”liangsheng”,10),(4,”sanming”,99),(5,”lujunlian”,100);
UPDATE student SET NAME=”pdd”,grade=”78” WHERE id=1;
UPDATE student SET NAME=”www”,grade=”98” WHERE id<4;
INSERT INTO student(id,NAME,grade)VALUES(6,”uu”,454);
UPDATE student SET NAME=”oo”,grade=23 WHERE id=6;
DELETE FROM student WHERE id=6;
CREATE TABLE student2(
id INT(3) PRIMARY KEY AUTO_INCREMENT,
NAME VARCHAR(20) NOT NULL,
grade FLOAT,
gender CHAR(2)
);
SELECT id,NAME,grade,gender FROM student2;
SELECT * FROM student2;
SELECT NAME FROM student2;
SELECT * FROM student2 WHERE id=1;
SELECT NAME,grade FROM student2 WHERE NAME=”zhangsan”;
SELECT * FROM student2 WHERE id IN (1,3,5);
SELECT NAME FROM student2 WHERE id NOT IN (1,3,5);
SELECT * FROM student2 WHERE id BETWEEN 1 AND 3;
SELECT NAME FROM student2 WHERE id BETWEEN 1 AND 3;
- Mysql基本语句练习
- MySQL基本练习
- MySQL基本查询语句练习
- MySql数据库基本操作练习
- MySql基本语法及练习(4)
- mysql 学习笔记--基本命令练习
- mysql基础---->基本命令与13道练习
- MySQL练习
- Mysql练习
- Mysql 练习
- mysql练习
- mysql练习
- mysql 练习
- MySql--练习
- MYSQL练习
- mysql 练习
- Mysql练习
- MySQL练习
- 求数组中区间中最小数*区间所有数和的最大值
- 55. Jump Game(dp, 贪心)
- Xcode中的Version和Build的区别
- 运用Python实现多种排序的方法
- Firefox下载文件时中文名乱码问题
- MySQL基本练习
- SDK相关问题
- 研究生入门
- Android Wifi 信息保存与忘记
- ccf 交通规划
- Centos 6.9安装docker
- PCA原理及特征脸
- shiro session 监听
- libzlib LNK2019错误之解决方法