MySQL练习_(简单库表创建)

原创于 2024-07-17 23:18:16 发布 · 232 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mysql #数据库

在这里插入图片描述

1.创建mydb6_product数据库

mysql> create database mydb6_product;
mysql> use mydb6_product;#切换到mydb6_product数据库中

2.创建表

#1.employees表
mysql> create table employees(id int primary key,name varchar(50) not null
,age int,gender varchar(10) not null default 'unknown',salary float);
mysql> desc employees;#查看employees表结构
+--------+-------------+------+-----+---------+-------+
| Field  | Type        | Null | Key | Default | Extra |
+--------+-------------+------+-----+---------+-------+
| id     | int         | NO   | PRI | NULL    |       |
| name   | varchar(50) | NO   |     | NULL    |       |
| age    | int         | YES  |     | NULL    |       |
| gender | varchar(10) | NO   |     | unknown |       |
| salary | float       | YES  |     | NULL    |       |
+--------+-------------+------+-----+---------+-------+

#2.orders表
mysql> create table orders(id int primary key,name varchar(100) not null,price float,quantity int,category varchar(50));
mysql> desc orders;
+----------+--------------+------+-----+---------+-------+
| Field    | Type         | Null | Key | Default | Extra |
+----------+--------------+------+-----+---------+-------+
| id       | int          | NO   | PRI | NULL    |       |
| name     | varchar(100) | NO   |     | NULL    |       |
| price    | float        | YES  |     | NULL    |       |
| quantity | int          | YES  |     | NULL    |       |
| category | varchar(50)  | YES  |     | NULL    |       |
+----------+--------------+------+-----+---------+-------+

#3.invoices表
mysql> create table invoices(number int primary key auto_increment,order_id int,in_date date,total_amount float unsigned,foreign key(order_id) references orders(id));
mysql> desc invoices;
+--------------+----------------+------+-----+---------+----------------+
| Field        | Type           | Null | Key | Default | Extra          |
+--------------+----------------+------+-----+---------+----------------+
| number       | int            | NO   | PRI | NULL    | auto_increment |
| order_id     | int            | YES  | MUL | NULL    |                |
| in_date      | date           | YES  |     | NULL    |                |
| total_amount | float unsigned | YES  |     | NULL    |                |
+--------------+----------------+------+-----+---------+----------------+