1、 Error description

1 queries executed, 0 success, 1 errors, 0 warnings
Inquire about :SELECT stu_name, course, score FROM t_student_info s LIMIT 0, 1000
Error code : 1054
Unknown column 'course' in 'field list'
Execution time consuming : 0 sec
Transmission time : 0 sec
Total time : 0 sec

2、 The reason for the error

SELECT
stu_name,
course,
score
FROM
t_student_info s
AND t_score_info sc
WHERE s.stu_id = sc.stu_id
GROUP BY stu_id 

There is no difference course Which table does the field belong to

3、 terms of settlement

SELECT
s.stu_name,
sc.course,
sc.score
FROM
t_student_info s
AND t_score_info sc
WHERE s.stu_id = sc.stu_id
GROUP BY stu_id 

Error code : 1054 Unknown column 'course' in 'field list' More articles about

  1. QQ Internet login appears (1054) Unknown column “conuintoken” in “field list”

    stay dz In the Forum QQ After the Internet login function prompt (1054) Unknown column conuintoken in field list error We see sql Error means that there is no conuintoken Word ...

  2. pymysql.err.InternalError: (1054, "Unknown column 'None' in 'field list'")

    Error message : Traceback (most recent call last): File "D:/projectwc/test/dd.py", line 43, in <m ...

  3. Report errors :pymysql.err.InternalError: (1054, &quot;Unknown column &#39;AType&#39; in &#39;field list&#39;&quot;)

    Error reporting background : Before reporting error sql Code display : List = ['] # sql = "insert into test(id, name) value ("+"'"+ L ...

  4. Mysql error :#1054 - Unknown column &#39;id&#39; in &#39;field list&#39; terms of settlement

    For the first time to use mysql, When inserting data , To report such a mistake , #1054 - Unknown column 'id' in 'field list'

  5. #1054 - Unknown column &#39;category&#39; in &#39;field list&#39;

    The reasons for this problem are : 1. There is no such field 2. Wrong table , What do you think you want to write , I didn't expect to write elsewhere , Of course, there is no such field , Check it out at this time sql Statement is not selected the wrong table , Or the wrong database

  6. Data insertion exception , as a result of : (1054, &quot;Unknown column &#39;\ufeff95001&#39; in &#39;field list&#39;&quot;)

    Use today python Title Error while calling local text to insert database , More than a ufeff. This involves the knowledge of coding and the conversion between different codes . Method 1: Just add... At the back decode Method 2: Open it with an editor , Select the corresponding code choice UT ...

  7. 【Discuz】-QQ Internet login prompt error message :Unknown column &#39;conuintoken&#39; in &#39;field list&#39;

    Prompt information discuz! Database Error(1054) Unknown column 'conuintoken' in 'field list'REPLACE INTO common_co ...

  8. MySQL5.7 Appears when the password is changed ERROR 1054 (42S22): Unknown column &#39;password&#39; in &#39;field list&#39;

    from :http://blog.csdn.net/u010603691/article/details/50379282 Newly installed MySQL5.7, Password error when logging in , The password was not changed during the installation , Later adopted ...

  9. OperationalError:(1054 - &quot;Unknown column &#39;game.lable1&#39; in &#39;field list&#39; &quot;) terms of settlement

    There was a mistake during the day , It's the first time I've had such a problem , Database problem , Baidu has found a lot of answers and blog articles problem :OperationalError:(1054 - "Unknown column 'gam ...

Random recommendation

  1. be based on 2D-RNN Robust pedestrian tracking

    be based on 2D-RNN Robust pedestrian tracking Recurrent Neural Networks RNN Pedestrian tracking read "G.L. Masala, et.al., 2D Recurrent Neural N ...

  2. 【SDOI2009】HH The necklace of

    Luogu topic link The question : Given a long 5w Static sequences , inquiry 20w Time , Find the number of element types in an interval each time The dyeing problem is so annoying , I've just been able to do , We can use a unified method to feel it First, we need to calculate the position of the nearest previous element that is the same as an element ...

  3. Nde Module article

    /* There are two types of modules : Native module and file module . The native module is Node.js API Native modules provided , The native module has been loaded at startup . The file module is the dynamic loading module , The work of loading the file module is mainly done by the native module module To achieve and accomplish ...

  4. ASP.NET Cache Some summary and share of

    Recently, our system is facing severe performance bottleneck problems , This is due to increased visits , Client requests increase at the same time , This forces us to solve this problem from two aspects , Increase hardware and system performance . 1.1.1 Abstract Recently, our system is facing severe performance bottleneck ...

  5. MVC verification 03- Custom validation rules 、 It is forbidden to enter certain values

    original text :MVC verification 03- Custom validation rules . It is forbidden to enter certain values This article continues to experience custom validation rules , The requirement is to prohibit the entry of certain values . This paper is the same as before 2 Article correlation , Please refer to :MVC verification 01- Basics . Remote Authentication    MVC verification 02- Custom validation rules . Post ...

  6. hdu1599 find the mincost route

    Topic link floyd Find the smallest ring Well understood. #include<algorithm> #include<iostream> #include<cstdlib> #incl ...

  7. elasticsearch( One ) And elasticsearch First time to know

    Catalog One .elasticsearch Two . elasticsearch A term is used to explain colony (cluster) node (node) Indexes (index) type( type ) Document( file ) shar ...

  8. R1 Learning record

    libevent Frame learning features : 1. Portable line , Cross platform 2. Fast ,libevent Will use the fastest non blocking of all platforms IO function 3. Extensibility 4. Convenience consists of : 1.evutil: Abstract the platforms network Function of ...

  9. ToDictionary Usage of

    I checked it last time , This time I forgot ... It seems necessary to record : linq Query results often ToList.ToArray What? , however ToDictionary Use less , Lead to often forget how to use ... ToDictiona ...

  10. VB

    on error resume next: Start with this statement , The program will not stop when it encounters an error , There will be no error prompts , Will continue to run . Scope until the end of the program or the end of the function where the statement Public Property : Read or write ...