Create a table in MySQL and create a table in mysql

Create a table in MySQL and create a table in mysql

-- Create DATABASE test
Use test;

Drop table if EXISTS zones;
Create table zones
(
Z_id int primary key auto_increment,
Z_name VARCHAR (50) NOT NULL
) ENGINE = INNODB;

Drop table if exists user_info;
Create table user_info
(
'User _ id' INT,
'Email 'VARCHAR (50 ),
'Pwd' VARCHAR (50) not null,
'Uname' VARCHAR (50 ),
'Zone 'int not null,
'Age' INT,
'Create _ time' datetime not null,
Primary key ('user _ id', 'email '),
Foreign key (zone) REFERENCES zones (z_id)
) ENGINE = INNODB;

-- Drop table if exists 'user _ info ';
-- Create table 'user _ info '(
-- 'User _ id' int (11) not null,
-- 'Email 'varchar (50) not null,
-- 'Pwd' varchar (50) not null,
-- 'Uname' varchar (50) default null,
-- 'Zone 'int (11) not null,
-- 'Age' int (11) default null,
-- 'Create _ time' datetime not null,
-- Primary key ('user _ id', 'email ')
--) ENGINE = MyISAM default charset = utf8;