实例一:
创建数据库:school
创建数据表:info
name | sex | age | class | score |
sex:性别; class:班级; score:成绩
创建完毕后在数据表中插入如下数据:
tom | male | 20 | 1 | 85 |
lily | female | 21 | 2 | 68 |
tony | male | 23 | 1 | 65 |
bob | male | 22 | 2 | 78 |
john | male | 21 | 3 | 89 |
lucy | female | 24 | 3 | 59 |
male:男士; female:女士
1.创建school数据库
2.创建数据表并设置数值类型
实例二:
创建数据库:company
数据表: products
数据表:sales