时间:2021-07-01 10:21:17 帮助过:24人阅读
create database ssm default character set utf8; use ssm; create table flower( id int(10) primary key auto_increment comment‘编号‘, name VARCHAR(30) not null comment ‘花名‘, price float not null comment ‘价格‘, production varchar(30) not null comment ‘原产地‘ ); insert into flower values(default,‘矮牵牛‘,2.5,‘南美阿根廷‘); insert into flower values(default,‘百日草‘,5.0,‘墨西哥‘); insert into flower values(default,‘半枝莲‘,4.3,‘巴西‘); select * from flower;
建库,建表,添加数据 SQL命令
标签:sql命令 rac key com char base 建库 comment float