为什么把sql文件导入mysql时出错_请教下导入sql文件出错的问题

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

跟着网上的教程照抄的，导入就出错了，麻烦帮忙看下是哪里的问题。

--创建数据库

create database myshop15;

--切换数据库

use myshop15;

--建立表

create table user(

id int unsigned not null auto_increment primary key,

username varchar(50) not null,

password varchar(50) not null,

isadmin tinyint not null

);

create table advert(

id int unsigned not null auto_increment primary key,

img varchar(50) not null,

password vachar(50) not null,

isadmin tinyint not null

pos tinyint not null,

url varchar(100) not null

);

create table class(

id int unsigned not null auto_increment primary key,

name varchar(50) not null

);

create table brand(

id int unsigned not null auto_increment primary key,

name varchar(50) not null,

class_id int not null

);

create table shop(

id int unsigned not null auto_increment primary key,

name varchar (50) not null,

img varchar (50) not null,

price float not null,

stock int not null,

shelf tinyint not null

);

create table comment(

id int unsigned not null auto_increment primary key,

user_id int not null,

content text,

shop_id int not null,

time int

);

create table status(

id int unsigned not null auto_increment primary key,

name varchar(50) not null

);

create table indent(

id int unsigned not null auto_increment primary key,

num varchar(50) not null,

user_id int not null,

time int not null,

status_id int not null,

touch_id int not null

);

create table touch(

id int unsigned not null auto_increment primary key,

name varchar(50) not null,

addr varchar(100) not null,

tel varchar(50) not null,

email varchar(50) not null,

user_id int not null

);