Me pehea e hanga ai e MySQL he tepu rangitahi? Te mahi a MySQL tepu rangitahi

MySQLMe pehea te hanga/whakataka i te ripanga temp?MySQLTe mahi a nga tepu rangitahi

MySQL tepu rangitahi

He tino whai hua te ripanga rangitahi MySQL ina hiahia tatou ki te tiaki i etahi raraunga rangitahi.Ka kitea noa nga ripanga rangitahi i roto i te hononga o naianei. Ina katia te hononga, ka muku aunoa a Mysql i te ripanga me te tuku mokowā katoa.

I taapirihia nga ripanga rangitahi ki te putanga MySQL 3.23 Mena he iti ake to putanga MySQL i te putanga 3.23, kaore e taea e koe te whakamahi i nga ripanga rangitahi MySQL.Heoi, he onge ki te whakamahi i te ahua iti nei inaianei.pātengi raraunga MySQLratonga.

Ko te ripanga rangitahi MySQL ka kitea ki te hononga o naianei. Ki te whakamahi koe i te tuhinga PHP hei hanga i tetahi ripanga rangitahi MySQL, ka ngaro aunoa te ripanga rangitahi i nga wa katoa ka mahia te tuhinga PHP.

Ki te whakamahi koe i tetahi atu papatono kiritaki MySQL ki te hono atu ki te tūmau pātengi raraunga MySQL ki te hanga tepu rangitahi, ka ngaro noa te teepu rangitahi ina katia te papatono kiritaki.

Akoranga

Ko nga mea e whai ake nei e whakaatu ana i tetahi tauira ngawari o te whakamahi i te ripanga rangitahi MySQL, ka taea te whakamahi i te waehere SQL e whai ake nei ki te mahi mysql_query() o te tuhinga PHP.

MySQL的> CREATE TEMPORARY TABLE SalesSummary （- > PRODUCT_NAME VARCHAR （50 ）NOT NULL
     - > ，TOTAL_SALES DECIMAL （12 ，2 ）NOT NULL DEFAULT 0.00 - > ，avg_unit_price DECIMAL （7 ，2 ）NOT NULL DEFAULT 0.00 - > ，total_units_sold INT UNSIGNED NOT NULL DEFAULT 0 ）; 查询OK ，0 行受影响（0.00 秒 
     
     
     

 ）

的MySQL > INSERT INTO SalesSummary - > （PRODUCT_NAME ，TOTAL_SALES ，avg_unit_price ，total_units_sold ）- > VALUES
     - > （'黄瓜' ，100.25 ，90 ，2 ）;
     
        

mysql > SELECT * FROM SalesSummary ; + -------------- + ------------- + ---------------- + --- --------------- + | product_name | total_sales | avg_unit_price | total_units_sold | + -------------- + ------------- + ---------------- + --- --------------- + | 黄瓜      | 100.25 | 90.00 | 2 | + -------------- + ------------- + ---------------- + --- --------------- + 1 行中集合（0.00 秒）



                                   

  

ina whakamahi koeWhakaatuhia nga TABLESIna whakaatu te whakahau i te rarangi o nga ripanga raraunga, kaore koe e kite i te ripanga SalesSummary.

Mena ka puta koe i te waahi MySQL o naianei, whakamahiaTīpakohiawhakahau ki te panui i nga raraunga o te ripanga rangitahi i hangaia i te tuatahi, katahi ka kitea karekau te ripanga i roto i te papanga raraunga, na te mea kua ngaro te teepu rangitahi ina puta koe.

Whakataka MySQL tepu rangitahi

Ma te taunoa, ka ngaro aunoa nga ripanga rangitahi ina momotu koe mai i te papaunga raraunga.Ko te akoranga ka taea hoki e koe te whakamahi i roto i te waahi MySQL o naianeiTE TAPA RUKAwhakahau ki te whakataka a ringa i te ripanga rangitahi.

E whai ake nei he tauira o te tuku a ringa i te ripanga rangitahi:

mysql> CREATE TEMPORARY TABLE SalesSummary (
    -> product_name VARCHAR(50) NOT NULL
    -> , total_sales DECIMAL(12,2) NOT NULL DEFAULT 0.00
    -> , avg_unit_price DECIMAL(7,2) NOT NULL DEFAULT 0.00
    -> , total_units_sold INT UNSIGNED NOT NULL DEFAULT 0
);
Query OK, 0 rows affected (0.00 sec)

mysql> INSERT INTO SalesSummary
    -> (product_name, total_sales, avg_unit_price, total_units_sold)
    -> VALUES
    -> ('cucumber', 100.25, 90, 2);

mysql> SELECT * FROM SalesSummary;
+--------------+-------------+----------------+------------------+
| product_name | total_sales | avg_unit_price | total_units_sold |
+--------------+-------------+----------------+------------------+
| cucumber     |      100.25 |          90.00 |                2 |
+--------------+-------------+----------------+------------------+
1 row in set (0.00 sec)
mysql>DROP TABLE SalesSummary ; 
mysql >   SELECT * FROM SalesSummary ; 
错误1146 ：表'chenweiliang.SalesSummary' 不存在