php - MySQL - PhpMyadmin - Create Multiple Tables -

i can´t understand why query not working create table structure in phpmyadmin.

i receive error message:

1064 - have error in sql syntax; check manual corresponds mysql server version right syntax use

near 'max), foreign key (form_id) references form (id) )' @ line 4

create table form(     id int unsigned auto_increment primary key,     title varchar(500),     is_active bit,     is_trash bit,     date_created datetime ); create table form_data(     id int unsigned auto_increment primary key,     form_id int,     formdata varchar(max),     foreign key (form_id) references form (id) ); 

varchar(max) ms sql server's syntax. mysql doesn't have equivalent, you'll have use long size. additionally, once you'll solve problem, you'll encounter problem form_data.form_id not of the same type form.id (one unsigned , other isn't), cannot reference it. in short:

create table form_data(     id int unsigned auto_increment primary key,     form_id int unsigned, -- second issue     formdata varchar(4000), -- first issue      foreign key (form_id) references form (id) );