1.创建数据库
create database dataBaseName;
# 创建学生信息表
create database studentInfo;
2.应用数据库
# use databaseName；
use studentInfo；
3. 删除数据库
drop databaseName;
4.创建数据表
# create table tablename （column_1 int primary key, column_2 varchar(20) nut null, column_3 varchar nut null );
create table student ( id int auto_increment primary key, name varchar(20) not null, age int not null );
5.插入数据
# insert into （column_1, column2）values ( value, value);
insert into student(id, name, age) values(202101, ‘ghostdot‘, 18);
6.修改数据
# update tableName set column_1 = value, columne = value where clause;
update student set name = ‘ghost‘ where id = 2020101;
7. 删除数据
# delete from tableName where clause;
delete from student where name = ‘ghost‘;
8.数据查询教程：
基础查询
https://www.cnblogs.com/ghostdot/p/12523864.html
高级查询
https://www.cnblogs.com/ghostdot/p/12543002.html
原文：https://www.cnblogs.com/ghostdot/p/12551856.html
如果您也喜欢它,动动您的小指点个赞吧
602392714
清零编程群