编辑代码

create database itcast;
use itcast database;
set names 'utf8';

create table a(
    No int not null primary key auto_increment,
    Name text not null,
    cpu text,
    memory text,
    disk text
);

insert into a (Name,cpu,memory,disk) values
    ('it001','i5-9400','4G','128G-SSD'),
    ('it002','i5-9400','4G','128G-SSD'),
    ('it003','i5-9400','4G','128G-SSD'),
    ('it004','i5-9400','4G','128G-SSD'),
    ('it005','i5-9400','4G','128G-SSD');
select * from a;