Unit 1

01-A. How to be a successful language learner?
“Learning a language is easy, even a child can do it!”
Most adults who are learning a second language would disagree with this statement. For them, learning a language is a very difficult task. They need hundreds of hours of study and practice, and even this will not guarantee success for every adult language learner.
Language learning is different from other kinds of learning. Some people who are very intelligent and successful in their fields find it difficult to succeed in language learning. Conversely, some people who are successful language learners find it difficult to succeed in other fields.
Language teachers often offer advice to language learners: “Read as much as you can in the new language.”“ Practice speaking the language every day. ”“Live with people who speak the language.”“Don’t translate-try to think in the new language.”“ Learn as a child would learn; play with the language.”
But what does a successful language learner do? Language learning research shows that successful language learners are similar in many ways.
First of all, successful language learners are independent learners. They do not depend on the book or the teacher; they discover their own way to learn the language. Instead of waiting for the teacher to explain, they try to find the patterns and the rules for themselves. They are good guessers who look for clues and form their own conclusions. When they guess wrong, they guess again. They try to learn from their mistakes.
Successful language learning is active learning. Therefore, successful learners do not wait for a chance to use the language; they look for such a chance. They find people who speak the language and they ask these people to correct them when they make a mistake. They will try anything to communicate. They are not afraid to repeat what they hear or to say strange things; they are willing to make mistakes and try again. When communication is difficult, they can accept information that is inexact or incomplete. It is more important for them to learn to think in the language than to know the meaning of every word.
Finally, successful language learners are learners with a purpose. They want to learn the language because they are interested in the language and the people who speak it. It is necessary for them to learn the language in order to communicate with these people and to learn from them. They find it easy to practice using the language regularly because they want to learn with it.
What kind of language learner are you? If you are a successful language learner, you have probably been learning independently, actively, and purposefully. On the other hand, if your language learning has been less than successful, you might do well to try some of the techniques outlined above.


01-B. Language
When we want to tell other people what we think, we can do it not only with the help of words, but also in many other ways. For instance, we sometimes move our heads up and down when we want to say "yes” and we move our heads from side to side when we want to say "no." People who can neither hear nor speak (that is, deaf and dumb people) talk to each other with the help of their fingers. People who do not understand each other's language have to do the same. The following story shows how they sometimes do it.
An Englishman who could not speak Italian was once traveling in Italy. One day he entered a restaurant and sat down at a table. When the waiter came, the Englishman opened his mouth, put his fingers in it, took them out again and moved his lips. In this way he meant to say, "Bring me something to eat." The waiter soon brought him a cup of tea. The Englishman shook his head and the waiter understood that he didn't want tea, so he took it away and brought him some coffee. The Englishman, who was very hungry by this time and not at all thirsty, looked very sad. He shook his head each time the waiter brought him something to drink. The waiter brought him wine, then beer, then soda-water, but that wasn’t food, of course. He was just going to leave the restaurant when another traveler came in. When this man saw the waiter, he put his hands on his stomach. That was enough: in a few minutes there was a large plate of macaroni and meat on the table before him.
As you see, the primitive language of signs is not always very clear. The language of words is much more exact.
Words consist of sounds, but there are many sounds which have a meaning and yet are not words. For example, we may say "Sh-sh-sh” when we mean "keep silent.” When babies laugh, we know they are happy, and when they cry, we know they are ill or simply want something.
It is the same with animals. When a dog says “G-r-r” or a cat says "F-f-f” we know they are angry.
But these sounds are not language. Language consists of words which we put together into sentences. But animals can not do this: a dog can say “G-r-r” when he means "I am angry,” but he cannot say first "I” and then "am” and then "angry.” A parrot can talk like a man; it can repeat whole sentences and knows what they mean. We may say that a parrot talks, but cannot say that it really speaks, because it cannot form new sentences out of the words it knows. Only man has the power to do this.


这是一组数据,你主要看编码和id的对应关系(A表):17 一次风机A primary_air_fan_A 18 一次风机B primary_air_fan_B 19 主汽轮机 main_steam_turbine 20 凝结水泵A condensate_pump_A 21 凝结水泵B condensate_pump_B 22 引风机A induced_draft_fan_A 23 引风机B induced_draft_fan_B 24 磨煤机A coal_mill_A 25 磨煤机B coal_mill_B 26 磨煤机C coal_mill_C 27 磨煤D coal_mill_D 28 磨煤机E coal_mill_E 29 磨煤机F coal_mill_F 30 给水泵A feed_pump_turbine_A 31 给水泵B feed_pump_turbine_B 32 送风机A forced_draught_blower_A 33 送风机B forced_draught_blower_B下面这个你需要看两个id之间的对应关系(B表,前面一个是新id,后面的是上面的id):148 32 217 18 218 19 219 20 220 21 221 22 222 17 223 23 224 24 225 25 226 26 227 27 228 28 229 29 230 30 231 31 232 33。下面是目标表C的SQL:CREATE TABLE "JNPF_INIT"."BIZ_MEASURE_POINT" ( "ID" BIGINT IDENTITY(21, 1) NOT NULL, "MEASURE_POINT_NAME" VARCHAR(100) NOT NULL, "MEASURE_POINT_KEY" VARCHAR(50) NOT NULL, "SID" BIGINT NOT NULL, "ATTRIBUTE_TYPE_ID" VARCHAR(50), "MEASURE_POINT_TYPE_ID" VARCHAR(50), "UNIT_NAME" VARCHAR(10), "LIMIT_TYPE" INT DEFAULT 0 NOT NULL, "UPPER_LIMIT" REAL, "LOWER_LIMIT" REAL, "FIELD_NAME" VARCHAR(50), "CREATED_AT" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP() NOT NULL, "UPDATED_AT" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP() NOT NULL, "DELETED_AT" TIMESTAMP(0), "F_TENANT_ID" VARCHAR(50) NOT NULL, "F_FLOW_ID" VARCHAR(50), "F_FLOW_TASK_ID" VARCHAR(50), NOT CLUSTER PRIMARY KEY("ID"), CONSTRAINT "MEASURE_POINT_KEY" UNIQUE("MEASURE_POINT_KEY"), CHECK("SID" >= 0)) STORAGE(ON "MAIN", CLUSTERBTR);。最后是要导入的数据:{"primary_air_fan_A": ["w3_unit1_10hlb30cf001", "w3_unit1_10hla30cp001", "w3_unit1_10hlv30m02ai01", "w3_unit1_10hlv30m01ai01", "w3_unit1_10hlb30m01ai01", "w3_unit1_10hlb30cy012", "w3_unit1_10hlb30cy011", "w3_unit1_10hlb30ct066", "w3_unit1_10hlb30ct065", "w3_unit1_10hlb30ct064", "w3_unit1_10hlb30ct063", "w3_unit1_10hlb30ct062", "w3_unit1_10hlb30ct061", "w3_unit1_10hlb30ct052", "w3_unit1_10hlb30ct051", "w3_unit1_10hlb30ct043", "w3_unit1_10hlb30ct042", "w3_unit1_10hlb30ct041", "w3_unit1_10hlb30ct033", "w3_unit1_10hlb30ct032", "w3_unit1_10hlb30ct031", "w3_unit1_10hlb30ct023", "w3_unit1_10hlb30ct022", "w3_unit1_10hlb30ct021", "w3_unit1_10hlb30ct013", "w3_unit1_10hlb30ct012", "w3_unit1_10hlb30ct011", "w3_unit1_10hla30ct003", "w3_unit1_10hla30ct002", "w3_unit1_10hla30ct001"], "primary_air_fan_B": ["w3_unit1_10hlb40cf001", "w3_unit1_10hla40ct003", "w3_unit1_10hla40ct002", "w3_unit1_10hla40ct001", "w3_unit1_10hla40cp001", "w3_unit1_10hlv40m02ai01", "w3_unit1_10hlv40m01ai01", "w3_unit1_10hlb40m01ai01", "w3_unit1_10hlb40cy012", "w3_unit1_10hlb40cy011", "w3_unit1_10hlb40ct066", "w3_unit1_10hlb40ct065", "w3_unit1_10hlb40ct064", "w3_unit1_10hlb40ct063", "w3_unit1_10hlb40ct062", "w3_unit1_10hlb40ct061", "w3_unit1_10hlb40ct052", "w3_unit1_10hlb40ct051", "w3_unit1_10hlb40ct043", "w3_unit1_10hlb40ct042", "w3_unit1_10hlb40ct041", "w3_unit1_10hlb40ct033", "w3_unit1_10hlb40ct032", "w3_unit1_10hlb40ct031", "w3_unit1_10hlb40ct023", "w3_unit1_10hlb40ct022", "w3_unit1_10hlb40ct021", "w3_unit1_10hlb40ct013", "w3_unit1_10hlb40ct012", "w3_unit1_10hlb40ct011"], "main_steam_turbine": ["w3_unit1_10qjdzj10ct001", "w3_unit1_10qjdzj10cq001", "w3_unit1_10mav74ct032", "w3_unit1_10mav74ct031", "w3_unit1_10max22ct001", "w3_unit1_10max21ct001", "w3_unit1_10max17ct001", "w3_unit1_10mav74ct011", "w3_unit1_10mav74cp038", "w3_unit1_10mav60ct010", "w3_unit1_10mav50ct010", "w3_unit1_10mav40ct010", "w3_unit1_10mav30ct010", "w3_unit1_10mav20ct010", "w3_unit1_10mav10ct010", "w3_unit1_10mav10cp010", "w3_unit1_10mav00ct020", "w3_unit1_10mav00ct010", "w3_unit1_10maa50ct004", "w3_unit1_10maa50ct003", "w3_unit1_10maa50ct002", "w3_unit1_10maa50ct001", "w3_unit1_10cjj31001cra00r", "w3_unit1_10max12m01ai01", "w3_unit1_10mav74m02ai01", "w3_unit1_10mav73m03ai01", "w3_unit1_10xav10m03ai01", "w3_unit1_10xav10m02ai01", "w3_unit1_10max16m02ai01", "w3_unit1_10max16m01ai01", "w3_unit1_10max11m01ai01", "w3_unit1_10mav74m01ai01", "w3_unit1_10mav73m02ai01", "w3_unit1_10mav73m01ai01", "w3_unit1_10mav73ct011", "w3_unit1_10mav73cl001", "w3_unit1_10mav74ct021", "w3_unit1_10mac50ct004", "w3_unit1_10mac50ct003", "w3_unit1_10mac50ct002", "w3_unit1_10mac50ct001"], "condensate_pump_A": ["w3_unit1_10xac20cy042", "w3_unit1_10xac20cy041", "w3_unit1_10lcb11ct014", "w3_unit1_10lcb11ct013", "w3_unit1_10lcb11ct012", "w3_unit1_10lcb11ct011", "w3_unit1_10lcb11ct010", "w3_unit1_10lcp13m01ai01", "w3_unit1_10lcb11m01ai01", "w3_unit1_10lcb11ct009", "w3_unit1_10lcb11ct008", "w3_unit1_10lcb11ct007", "w3_unit1_10lcb11ct006", "w3_unit1_10lcb11ct005", "w3_unit1_10lcb11ct004", "w3_unit1_10lcb11ct003", "w3_unit1_10lcb11ct002", "w3_unit1_10lcb11ct001", "w3_unit1_10lca11cp001", "w3_unit1_10lca20cp001", "w3_unit1_10lca20ct002"], "condensate_pump_B": ["w3_unit1_10xac20cy052", "w3_unit1_10xac20cy051", "w3_unit1_10lcb12ct014", "w3_unit1_10lcb12ct013", "w3_unit1_10lcb12ct012", "w3_unit1_10lcb12ct011", "w3_unit1_10lcb12ct010", "w3_unit1_10lcp12m01ai01", "w3_unit1_10lcb12m01ai01", "w3_unit1_10lcb12ct009", "w3_unit1_10lcb12ct008", "w3_unit1_10lcb12ct007", "w3_unit1_10lcb12ct006", "w3_unit1_10lcb12ct005", "w3_unit1_10lcb12ct004", "w3_unit1_10lcb12ct003", "w3_unit1_10lcb12ct002", "w3_unit1_10lcb12ct001", "w3_unit1_10lca10cp001", "w3_unit1_10lca20cp001", "w3_unit1_10lca20ct002"], "induced_draft_fan_A": ["w3_unit1_10hnc10ct163", "w3_unit1_10hnc10ct162", "w3_unit1_10hnc10ct161", "w3_unit1_10hnv10cp101", "w3_unit1_10hnc10ct102", "w3_unit1_10hnc10ct101", "w3_unit1_10hnc10ct100", "w3_unit1_10hnc10cf001", "w3_unit1_10hna10ct004", "w3_unit1_10hna10cp003", "w3_unit1_10hna10cp002", "w3_unit1_10hnc10m01ai01", "w3_unit1_10hnc10ct017", "w3_unit1_10hnc10ct016", "w3_unit1_10hnc10ct015", "w3_unit1_10hnc10ct014", "w3_unit1_10hnc10ct013", "w3_unit1_10hnc10ct012", "w3_unit1_10hnc10ct011", "w3_unit1_10hnc10ct010", "w3_unit1_10hnc10ct009", "w3_unit1_10hnc10ct008", "w3_unit1_10hnc10ct007", "w3_unit1_10hnc10ct006", "w3_unit1_10hnc10ct005", "w3_unit1_10hnc10ct004", "w3_unit1_10hnc10ct003", "w3_unit1_10hnc10ct002", "w3_unit1_10hnc10ct001", "w3_unit1_10hnc10cg002", "w3_unit1_10hnc10cg001"], "induced_draft_fan_B": ["w3_unit1_10hnc20ct163", "w3_unit1_10hnc20ct162", "w3_unit1_10hnc20ct161", "w3_unit1_10hnc20cp101", "w3_unit1_10hnc20ct102", "w3_unit1_10hnc20ct101", "w3_unit1_10hnc20ct100", "w3_unit1_10hnc20cf001", "w3_unit1_10hna20ct004", "w3_unit1_10hna20cp003", "w3_unit1_10hna20cp002", "w3_unit1_10hnc20m01ai01", "w3_unit1_10hnc20ct017", "w3_unit1_10hnc20ct016", "w3_unit1_10hnc20ct015", "w3_unit1_10hnc20ct014", "w3_unit1_10hnc20ct013", "w3_unit1_10hnc20ct012", "w3_unit1_10hnc20ct011", "w3_unit1_10hnc20ct010", "w3_unit1_10hnc20ct009", "w3_unit1_10hnc20ct008", "w3_unit1_10hnc20ct007", "w3_unit1_10hnc20ct006", "w3_unit1_10hnc20ct005", "w3_unit1_10hnc20ct004", "w3_unit1_10hnc20ct003", "w3_unit1_10hnc20ct002", "w3_unit1_10hnc20ct001", "w3_unit1_10hnc20cg002", "w3_unit1_10hnc20cg001"], "coal_mill_A": ["w3_unit1_10hfc12ct016", "w3_unit1_10hfc10ct022", "w3_unit1_10hfc10ct021", "w3_unit1_10hfc10cp011", "w3_unit1_10hfc10cp001", "w3_unit1_10hfv12ct011", "w3_unit1_10hfv12cp011", "w3_unit1_10hfv11ct001", "w3_unit1_10hfe10cp002", "w3_unit1_10hfc12ct015", "w3_unit1_10hfc12ct014", "w3_unit1_10hfc12ct013", "w3_unit1_10hfc12ct012", "w3_unit1_10hfc12ct011", "w3_unit1_10hfc10ct036", "w3_unit1_10hfc10ct035", "w3_unit1_10hfc10ct034", "w3_unit1_10hfc10ct033", "w3_unit1_10hfc10ct032", "w3_unit1_10hfc10ct031", "w3_unit1_pri_flow_a", "w3_unit1_10hfe10ct001", "w3_unit1_10hfe10cp001", "w3_unit1_10hfc10ct013", "w3_unit1_10hfc10ct012", "w3_unit1_10hfc10ct011"], "coal_mill_B": ["w3_unit1_10hfc22ct016", "w3_unit1_10hfc20ct022", "w3_unit1_10hfc20ct021", "w3_unit1_10hfc20cp011", "w3_unit1_10hfc20cp001", "w3_unit1_10hfv22ct011", "w3_unit1_10hfv22cp011", "w3_unit1_10hfe20cp002", "w3_unit1_10hfc22ct015", "w3_unit1_10hfc22ct014", "w3_unit1_10hfc22ct013", "w3_unit1_10hfc22ct012", "w3_unit1_10hfc22ct011", "w3_unit1_10hfc20ct036", "w3_unit1_10hfc20ct035", "w3_unit1_10hfc20ct034", "w3_unit1_10hfc20ct033", "w3_unit1_10hfc20ct032", "w3_unit1_10hfc20ct031", "w3_unit1_pri_flow_b", "w3_unit1_10hfe20ct001", "w3_unit1_10hfe20cp001", "w3_unit1_10hfc20ct013", "w3_unit1_10hfc20ct012", "w3_unit1_10hfc20ct011"], "coal_mill_C": ["w3_unit1_10hfc32ct016", "w3_unit1_10hfc30ct022", "w3_unit1_10hfc30ct021", "w3_unit1_10hfc30cp011", "w3_unit1_10hfc30cp001", "w3_unit1_10hfv32ct011", "w3_unit1_10hfv32cp011", "w3_unit1_10hfe30cp002", "w3_unit1_10hfc32ct015", "w3_unit1_10hfc32ct014", "w3_unit1_10hfc32ct013", "w3_unit1_10hfc32ct012", "w3_unit1_10hfc32ct011", "w3_unit1_10hfc30ct036", "w3_unit1_10hfc30ct035", "w3_unit1_10hfc30ct034", "w3_unit1_10hfc30ct033", "w3_unit1_10hfc30ct032", "w3_unit1_10hfc30ct031", "w3_unit1_pri_flow_c", "w3_unit1_10hfe30ct001", "w3_unit1_10hfe30cp001", "w3_unit1_10hfc30ct013", "w3_unit1_10hfc30ct012", "w3_unit1_10hfc30ct011"], "coal_mill_D": ["w3_unit1_10hfc42ct016", "w3_unit1_10hfc40ct022", "w3_unit1_10hfc40ct021", "w3_unit1_10hfc40cp011", "w3_unit1_10hfc40cp001", "w3_unit1_10hfv42ct011", "w3_unit1_10hfv42cp011", "w3_unit1_10hfe40cp002", "w3_unit1_10hfc42ct015", "w3_unit1_10hfc42ct014", "w3_unit1_10hfc42ct013", "w3_unit1_10hfc42ct012", "w3_unit1_10hfc42ct011", "w3_unit1_10hfc40ct036", "w3_unit1_10hfc40ct035", "w3_unit1_10hfc40ct034", "w3_unit1_10hfc40ct033", "w3_unit1_10hfc40ct032", "w3_unit1_10hfc40ct031", "w3_unit1_pri_flow_d", "w3_unit1_10hfe40ct001", "w3_unit1_10hfe40cp001", "w3_unit1_10hfc40ct013", "w3_unit1_10hfc40ct012", "w3_unit1_10hfc40ct011"], "coal_mill_E": ["w3_unit1_10hfc50ct022", "w3_unit1_10hfc50ct021", "w3_unit1_10hfc50cp011", "w3_unit1_10hfc50cp001", "w3_unit1_10hfv52ct011", "w3_unit1_10hfv52cp011", "w3_unit1_10hfe50cp002", "w3_unit1_10hfc52ct015", "w3_unit1_10hfc52ct014", "w3_unit1_10hfc52ct013", "w3_unit1_10hfc52ct012", "w3_unit1_10hfc52ct011", "w3_unit1_10hfc50ct036", "w3_unit1_10hfc50ct035", "w3_unit1_10hfc50ct034", "w3_unit1_10hfc50ct033", "w3_unit1_10hfc50ct032", "w3_unit1_10hfc50ct031", "w3_unit1_pri_flow_e", "w3_unit1_10hfe50ct001", "w3_unit1_10hfe50cp001", "w3_unit1_10hfc50ct013", "w3_unit1_10hfc50ct012", "w3_unit1_10hfc50ct011", "w3_unit1_10hfc40ct011"], "coal_mill_F": ["w3_unit1_10hfc62ct016", "w3_unit1_10hfc60ct022", "w3_unit1_10hfc60ct021", "w3_unit1_10hfc60cp011", "w3_unit1_10hfc60cp001", "w3_unit1_10hfv62ct011", "w3_unit1_10hfv62cp011", "w3_unit1_10hfe60cp002", "w3_unit1_10hfc62ct015", "w3_unit1_10hfc62ct014", "w3_unit1_10hfc62ct013", "w3_unit1_10hfc62ct012", "w3_unit1_10hfc62ct011", "w3_unit1_10hfc60ct036", "w3_unit1_10hfc60ct035", "w3_unit1_10hfc60ct034", "w3_unit1_10hfc60ct033", "w3_unit1_10hfc60ct032", "w3_unit1_10hfc60ct031", "w3_unit1_pri_flow_f", "w3_unit1_10hfe60ct001", "w3_unit1_10hfe60cp001", "w3_unit1_10hfc60ct013", "w3_unit1_10hfc60ct012", "w3_unit1_10hfc60ct011"], "feed_pump_turbine_A": ["w3_unit1_10xac10ct094", "w3_unit1_10xac10ct093", "w3_unit1_10xac10ct092", "w3_unit1_10xac10ct091", "w3_unit1_10xac10cp001", "w3_unit1_10xaa13cp001", "w3_unit1_10xaa12cp011", "w3_unit1_10xaa12cp001", "w3_unit1_10lbr11cp001", "w3_unit1_10xac10ct081", "w3_unit1_10xac10ct008", "w3_unit1_10xac10ct007", "w3_unit1_10xac10ct006", "w3_unit1_10xac10ct005", "w3_unit1_10xac10ct004", "w3_unit1_10xac10ct003", "w3_unit1_10xac10ct002", "w3_unit1_10xac10ct001", "w3_unit1_10xaa11ct201", "w3_unit1_10xaa11cp001", "w3_unit1_10xaa11ct135", "w3_unit1_load"], "feed_pump_turbine_B": ["w3_unit1_10xac20ct094", "w3_unit1_10xac20ct093", "w3_unit1_10xac20ct092", "w3_unit1_10xac20ct091", "w3_unit1_10xac20cp001", "w3_unit1_10xaa23cp001", "w3_unit1_10xaa22cp011", "w3_unit1_10xaa22cp001", "w3_unit1_10lbr12cp001", "w3_unit1_10xac20ct081", "w3_unit1_10xac20ct008", "w3_unit1_10xac20ct007", "w3_unit1_10xac20ct006", "w3_unit1_10xac20ct005", "w3_unit1_10xac20ct004", "w3_unit1_10xac20ct003", "w3_unit1_10xac20ct002", "w3_unit1_10xac20ct001", "w3_unit1_10xaa21ct201", "w3_unit1_10xaa21cp001", "w3_unit1_10xaa21ct135", "w3_unit1_load"], "forced_draught_blower_A": ["w3_unit1_10hla10cp001", "w3_unit1_10hlv10m01ai01", "w3_unit1_10hlb10m01ai01", "w3_unit1_10hlb10cy012", "w3_unit1_10hlb10cy011", "w3_unit1_10hlb10ct066", "w3_unit1_10hlb10ct065", "w3_unit1_10hlb10ct064", "w3_unit1_10hlb10ct063", "w3_unit1_10hlb10ct062", "w3_unit1_10hlb10ct061", "w3_unit1_10hlb10ct042", "w3_unit1_10hlb10ct041", "w3_unit1_10hlb10ct033", "w3_unit1_10hlb10ct032", "w3_unit1_10hlb10ct031", "w3_unit1_10hlb10ct023", "w3_unit1_10hlb10ct022", "w3_unit1_10hlb10ct021", "w3_unit1_10hlb10ct013", "w3_unit1_10hlb10ct012", "w3_unit1_10hlb10ct011", "w3_unit1_10hla10ct003", "w3_unit1_10hla10ct002", "w3_unit1_10hla10ct001", "w3_unit1_10hlb10cf003", "w3_unit1_10hlb10cf002", "w3_unit1_10hlb10cf001"], "forced_draught_blower_B": ["w3_unit1_10hla20cp001", "w3_unit1_10hlv20m02ai01", "w3_unit1_10hlb20m01ai01", "w3_unit1_10hlb20cy012", "w3_unit1_10hlb20cy011", "w3_unit1_10hlb20ct066", "w3_unit1_10hlb20ct065", "w3_unit1_10hlb20ct064", "w3_unit1_10hlb20ct063", "w3_unit1_10hlb20ct062", "w3_unit1_10hlb20ct061", "w3_unit1_10hlb20ct042", "w3_unit1_10hlb20ct041", "w3_unit1_10hlb20ct033", "w3_unit1_10hlb20ct032", "w3_unit1_10hlb20ct031", "w3_unit1_10hlb20ct023", "w3_unit1_10hlb20ct022", "w3_unit1_10hlb20ct021", "w3_unit1_10hlb20ct013", "w3_unit1_10hlb20ct012", "w3_unit1_10hlb20ct011", "w3_unit1_10hla20ct003", "w3_unit1_10hla20ct002", "w3_unit1_10hla20ct001", "w3_unit1_10hlb20cf003", "w3_unit1_10hlb20cf002", "w3_unit1_10hlb20cf001"]}。你需要做的是编写表C的插入SQL。这个插入SQL中MEASURE_POINT_NAME字段采用表A中的中文,但是是加一个序号比如说:一次风机B1、一次风机B2。MEASURE_POINT_KEY字段则是去上面的数据中匹配,这个里面有多少条数据就表示这个要插入多少条:"primary_air_fan_B": ["w3_unit1_10hlb40cf001", "w3_unit1_10hla40ct003", "w3_unit1_10hla40ct002", "w3_unit1_10hla40ct001", "w3_unit1_10hla40cp001", "w3_unit1_10hlv40m02ai01", "w3_unit1_10hlv40m01ai01", "w3_unit1_10hlb40m01ai01", "w3_unit1_10hlb40cy012", "w3_unit1_10hlb40cy011", "w3_unit1_10hlb40ct066", "w3_unit1_10hlb40ct065", "w3_unit1_10hlb40ct064", "w3_unit1_10hlb40ct063", "w3_unit1_10hlb40ct062", "w3_unit1_10hlb40ct061", "w3_unit1_10hlb40ct052", "w3_unit1_10hlb40ct051", "w3_unit1_10hlb40ct043", "w3_unit1_10hlb40ct042", "w3_unit1_10hlb40ct041", "w3_unit1_10hlb40ct033", "w3_unit1_10hlb40ct032", "w3_unit1_10hlb40ct031", "w3_unit1_10hlb40ct023", "w3_unit1_10hlb40ct022", "w3_unit1_10hlb40ct021", "w3_unit1_10hlb40ct013", "w3_unit1_10hlb40ct012", "w3_unit1_10hlb40ct011"], SID字段的匹配方式根据表A和表B的数据来,比如说表A是18 一次风机B primary_air_fan_B,这个数据就对应表B的217 18。那么SID就是18。也就是说所有的primary_air_fan_B的SID都是18。剩下的字段"ATTRIBUTE_TYPE_ID" VARCHAR(50), "MEASURE_POINT_TYPE_ID" VARCHAR(50), "UNIT_NAME" VARCHAR(10), "LIMIT_TYPE" INT DEFAULT 0 NOT NULL, "UPPER_LIMIT" REAL, "LOWER_LIMIT" REAL, 字段全部固定值:714801548705677637 714801636857364805 ℃ 1 100 60。最后说一遍,你需要把我给你的json字符串中的数据变成这个C表的插入SQL。我使用的达梦数据库。请将他们一一匹配好。
最新发布
09-19
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值