已安装。
create database mydb6_product;
use mydb6_product;
mysql> create table employees(id int primary key,name varchar(50) not null,age int,gender varchar(10) not null default 'unknown',salary float);
Query OK, 0 rows affected (0.02 sec)
mysql> create table orders(id int primary key not null,name varchar(100) not null,pric
e float,category varchar(50));
Query OK, 0 rows affected (0.02 sec)
mysql> create table invoices (number int primary key auto_increment, order_id int , foreign key(order_id ) references orders(id), in_date date, total_amount float );
Query OK, 0 rows affected (0.02 sec)
