渗透第1天-mysql基础知识
mysql 基础知识建库:mysql> CREATE DATABASE IF NOT EXISTS bihuo_db_char
-> DEFAULT CHARACTER SET utf8
-> DEFAULT COLLATE utf8_chinese_ci;
Query OK, 1 row affected (0.03 sec)
建表:create table 表名()
create table student (id int ,
name varchar(255),
math_score int ,
english_score int,
mandarin_scoreint,
primary key (`id`))
ENGINE=InnoDB DEFAULT CHARSET=utf8;
插入数据
insert into student (name,math_score,english_score,mandarin_score) values
('bihuo', 88, 99, 89);
insert into student (name,math_score,english_score,mandarin_score) values
('bihuo1', 58, 99, 89);
查询数据
select * from student;float 和 decimal 的区别
页:
[1]