drop table if exists rg_product;
/*==============================================================*/
/* Table: rg_product */
/*==============================================================*/
create table rg_product
(
pr_id int not null auto_increment,
pr_name varchar(50),
us_id int,
us_nickname varchar(32),
pr_time datetime,
pr_param varchcar(240),
pr_require varchar(240),
pr_function varchar(1000),
pr_point varchar(500),
pr_method varchar(500),
pr_notice varchar(800),
pr_type varchar(16),
pr_number varchar(16),
pr_pid int,
pr_apply varchar(800),
pr_price double,
pr_status varchar(6),
pr_pack varchar(100),
pr_sale varchar(100),
primary key (pr_id)
);
alter table rg_product add constraint FK_Reference_4 foreign key (us_id)
references rg_user (us_id) on delete restrict on update restrict;
Query OK, 0 rows affected
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchcar(240),
pr_require varchar(240),
pr_function v' at line 11
1146 - Table 'backstage.rg_product' doesn't exist

理论上应该先if再drop吧.