#1054号错误-Unknown Column ‘Tami‘ in ‘field list‘怎么解决啊啊啊啊啊！！！

create schema movieco4;
use movieco4;
create table if not exists membership(mem_num int,mem_fname char(20),
mem_lname char(20), mem_street char(40),mem_city char(20),mem_state char(20),mem_zip int,mem_balance char(20));
insert into membership(mem_num,mem_fname,mem_lname,mem_street,mem_city,mem_state,mem_zip,mem_balance)
VALUES
(102,`Tami`,`Dawson`,`2632 Takli Circle`,`Norene`,`TN`,37136,`11`),
(103,`Curt`,`Knight`,`4025 Cornell Court`,`Flatgap`,`KY`,41219,`6`),
(104,`Jamal`,`Melendez`,`788 East 145th Avenue`,`Quebeck`,`TN`,38579,`0`),
(105,`lva`,`Mcclain`,`6045 Musket Ball Circle`,`Summit`,`KY`,42783,`15`),
(106,`Miranda`,`Parks`,`4469 Maxwell Place`,`Germantowwn`,`TN`,38183,`0`),
(107,`Rosario`,`Elliott`,`7578 Danner Avenue`,`Columbia`,`TN`,38402,`5`),
(108,`Mattie`,`Guy`,`4390 Evergreen Street`,`Lily`,`KY`,40740,`0`),
(109,`Clint`,`Ochoa`,`1711 Elm Street`,`Greenevile`,`TN`,37745,`10`),
(110,`Lewis`,`Rosales`,`4524 Southwind Circle`,`Counce`,`TN`,38326,`0`),
(111,`Stacy`,`Mann`,`2789 East Cook Avenue`,`Murfreesboro`,`TN`,37132,`8`),
(112,`Luis`,`Trujillo`,`7267 Melvin Avenue`,`Heiskell`,`TN`,37754,`3`),
(113,`Minnie`,`Gonzales`,`6430 Vasili Drive`,`Williston`,`TN`,38076,`0`);


create table rental(rent_num int,rent_date date,men_num int);
insert into rental(rent_num,rent_date,rent_num)
VALUES(1001,`01-MAR-18`,103),
      (1002,`01-MAR-18`,105),
      (1003,`02-MAR-18`,102),
      (1004,`02-MAR-18`,110),
      (1005,`02-MAR-18`,111),
      (1006,`02-MAR-18`,107),
      (1007,`02-MAR-18`,104),
      (1008,`03-MAR-18`,105),
      (1009,`03-MAR-18`,111);
create table price(price_code int,price_description char(20),price_rentfee float,price_dailylatefee float);
insert into price(price_code ,price_description,price_rentfee,price_dailylatefee)
VALUES(1,`Standerd`,`2`,1),
      (2,`New Realease`,`3.5`,3),
      (3,`Discount`,`1.5`,1),
      (4,`Weekly Special`,`1`,5);


create table movie(movie_num int,movie_title char(40),movie_year int,movie_cost float,movie_genre char(10),price_code int);
insert into movie(movie_num,movie_title,movie_year,movie_cost,movie_genre,movie_code)
VALUES
(1234,`The Ceser Family Christmas`,2016,39.95,`FAMILY`,2),
(1235,`Smokey Mountain Wildlife`,2013,59.95,`ACTION`,1),
(1236,`Richard Goodhope`,2017,59.95,`DRAMA`,2),
(1237,`Beatnik Fever`,2016,29.95,`COMEDY`,2),
(1238,`Constant Companion`,2017,89.95,`DRAMA`,NULL),
(1239,`Where Hope Dies`,2007,25.49,`DRAMA`,3),
(1245,`Time to Burn`,2014,45.49,`ACTION`,1),
(1246,`What He Dose not Know`, 2015,58.29,`COMEDY`,1);
create table vedio(vid_num int,vid_indate date,movie_num int);

insert into vedio(vid_num,vid_indate,movie_num)
VALUES
(54321,18-JUN-17,1234),
(54324,18-JUN-17,1234),
(54325,18-JUN-17,1234),
(34341,22-JAN-16,1235),
(34342,22-JAN-16,1235),
(34366,02-MAR-18,1236),
(34367,02-MAR-18,1236),
(34368,02-MAR-18,1236),
(34369,02-MAR-18,1236),
(44392,21-OCT-17,1237),
(44397,21-OCT-17,1237),
(59237,14-FEB-18,1237),
(61388,25-JAN-16,1239),
(61353,28-JAN-15,1245),
(61354,28-JAN-15,1245),
(61367,30-JUL-17,1246),
(61369,30-JUL-17,1246);

create table detailrental (rent_num int,vid_num int,detail—_fee float,detail_duedate date,detail_returndate date,detail_dailylatefee int);
insert into detailrental(rent_num ,vid_num ,detail—_fee ,detail_duedate ,detail_returndate ,detail_dailylatefee )
VALUES
(1001,34342,2,04-MAR-18,02-MAR-18,'NULL'),
(1001,61353,2,04-MAR-18,03-MAR-18,1),
(1002,59237,3.5,04-MAR-18,04-MAR-18,3),
(1003,54325,3.5,04-MAR-18,09-MAR-18,3),
(1003,61369,2,06--MAR-18,09-MAR-18,1),
(1003,61388,0,06-MAR-18,09-MAR-18,1),
(1004,44392,3.5,05-MAR-18,07-MAR-18,3),
(1004,34367,3,5,05-MAR-18,07-MAR-18,3),
(1004,34341,2,07-MAR-18,07-MAR-18,1),
(1005,34342,2,07-MAR-18,05-MAR-18,1),
(1005,44397,3.5,05-MAR-18,05-MAR-18,3),
(1006,34366,3.5,05-MAR-18,04-MAR-18,3),
(1006,61367,2,07-MAR-18, `NULL`,1),
(1007,34368,3.5,05-MAR-18, `NULL`,3),
(1008,34369,3.5,05-MAR-18,05-MAR-18,3),
(1009,54324,3.5,05-MAR-18,`NULL`,3),
(1001,34366,3.5,04-MAR-18,02-MAR-18,3);





  

 

#1054号错误-Unknown Column 'Tami' in 'field list'怎么解决啊啊啊啊啊！！！