现有一个，表结构如下

a.创建数据库db_school

CREATE DATABASE db_school;

b.建表语句如下

CREATE TABLE `tb_student` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(20) CHARACTER ,
  `grade` float NOT NULL,
  PRIMARY KEY (`id`)
)

如果对你有帮助，记得采纳一下，谢谢

https://www.runoob.com/mysql/mysql-create-database.html，跟着这个教程学吧

create database db_school;

use db_school;

create table tb_student(

id int default null,

name varchar(20) not null,

grade float default null

);

insert into tb_student value(id值,name值,grade值);

-- 创建数据库
CREATE DATABASE IF NOT EXISTS db_school;
-- 指定数据库
use db_school;
-- 创建tb_student
CREATE TABLE tb_student  (
  id int NOT NULL,
  name varchar(20) NULL DEFAULT NULL,
  grade float NULL DEFAULT NULL
);
-- insert 插入一条数据
insert into tb_student(id, name, grade) values(1, '测试', 1.0)

有帮助 望采纳