使用query获取mysql记录中的query

wkyowqbh  于 2021-06-21  发布在  Mysql
关注(0)|答案(0)|浏览(249)

我创建了一个如下表

CREATE TABLE IF NOT EXISTS order_det
        ( order_id INT(4) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT,
         Cust_name_1 CHAR(20) DEFAULT '' NOT NULL,
        P_desc_1 CHAR(20) DEFAULT '' NOT NULL,
        Drawing_num_1 CHAR(20) DEFAULT '' NOT NULL,
        Material_1 CHAR(20) DEFAULT '' NOT NULL,
         Operation_1 CHAR(20) DEFAULT '' NOT NULL,
         Quantity_1 INT(4) UNSIGNED ZEROFILL NOT NULL DEFAULT 0,
         date_1 CHAR(20) DEFAULT '' NOT NULL,
          Cust_name_2 CHAR(20) DEFAULT '' NOT NULL,
         P_desc_2 CHAR(20) DEFAULT '' NOT NULL,
        Drawing_num_2 CHAR(20) DEFAULT '' NOT NULL,
        Material_2 CHAR(20) DEFAULT '' NOT NULL,
         Operation_2 CHAR(20) DEFAULT '' NOT NULL ,
         Quantity_2 INT(4) UNSIGNED ZEROFILL NOT NULL DEFAULT 0,
         date_2 CHAR(20) DEFAULT '' NOT NULL,
         Cust_name_3 CHAR(20) DEFAULT '' NOT NULL,
         P_desc_3 CHAR(20) DEFAULT '' NOT NULL,
        Drawing_num_3 CHAR(20) DEFAULT '' NOT NULL,
        Material_3 CHAR(20) DEFAULT '' NOT NULL,
         Operation_3 CHAR(20) DEFAULT '' NOT NULL,
         Quantity_3 INT(4) UNSIGNED ZEROFILL NOT NULL DEFAULT 0,
         date_3 CHAR(20) DEFAULT '' NOT NULL,
         Cust_name_4 CHAR(20) DEFAULT '' NOT NULL,
         P_desc_4 CHAR(20) DEFAULT '' NOT NULL,
        Drawing_num_4 CHAR(20) DEFAULT '' NOT NULL,
        Material_4 CHAR(20) DEFAULT '' NOT NULL,
         Operation_4 CHAR(20) DEFAULT '' NOT NULL,
         Quantity_4 INT(4) UNSIGNED ZEROFILL NOT NULL DEFAULT 0,
         date_4 CHAR(20) DEFAULT '' NOT NULL,
         Cust_name_5 CHAR(20) DEFAULT '' NOT NULL,
         P_desc_5 CHAR(20) DEFAULT '' NOT NULL,
        Drawing_num_5 CHAR(20) DEFAULT '' NOT NULL,
        Material_5 CHAR(20) DEFAULT '' NOT NULL,
         Operation_5 CHAR(20) DEFAULT '' NOT NULL,
         Quantity_5 INT(4) UNSIGNED ZEROFILL NOT NULL DEFAULT 0,
         date_5 CHAR(20) DEFAULT '' NOT NULL,
        PRIMARY KEY(order_id))

表中有个条目。当我给予

SELECT * FROM order_det;

它工作正常,结果如图1所示
但是当我给

SELECT P_desc_1 FROM order_det WHERE Cust_name_1='vw';

它不返回任何内容。如图2所示
我不知道我哪里出错了
提前谢谢

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题