那个company_info的数据库我写好了,但是不会插入。求各位解答一下
create database company_info; -- 打开数据库 use company_info; -- 创建 Employee create table Employee( EmployeeID int primary key auto_increment, EmployeeName char(8) not null, EmployeeSex char(2) not null default '女', Emplthday datetime , HiringTime datetime not null, Specialty varchar(50), Salary double ) -- 创建Category create table Category( TypeID int primary key, TypeNmae char(30) not null, TypeNote char(50) ) -- 创建 Product create table Product( ProductID int primary key, Productname char(10) not null, TypeID int, foreign key(TypeID) references Category(TypeID), UnitPrice double not null, Inventory int not null ) -- 创建 Customer create table Customer( CustomerID int primary key, CompanyName char(30) not null, ContactName char(8) not null, Contactipone char(13), address char(30), Cod char(6) ) -- 创建 P_order create table P_order ( OrderID int primary key, ProductID int, foreign key(ProductID) references Product(ProductID), number int not null, EmployeeID int, foreign key(EmployeeID) references Employee(EmployeeID), CustomerID int, foreign key(CustomerID) references Customer(CustomerID), OrderTime datetime not null )