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_score int,
- 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);
复制代码
查询数据
float 和 decimal 的区别
|