MySQL inogadzira sei / inodonhedza tafura yenguva pfupi? Basa reMySQL temporary tables

MySQLMaitiro ekugadzira / kudonhedza tafura yenguva?MySQLBasa rematafura enguva pfupi

MySQL temporary table

MySQL temporary tables inobatsira zvikuru kana tichida kuchengeta imwe data yenguva pfupi.Matafura enguva pfupi anongoonekwa mukubatana kwazvino.Kana iyo yekubatanidza yavharwa, Mysql inodzima tafura uye kusunungura nzvimbo yese.

Matafura enguva pfupi akawedzerwa muMySQL vhezheni 3.23 Kana shanduro yako yeMySQL yakaderera pane vhezheni 3.23, haugone kushandisa MySQL temporary tables.Zvisinei, kashoma kushandisa shanduro yakadaro yakaderera ikozvino.MySQL databaseservice.

MySQL's temporary table inongo onekwa kune yazvino kubatanidza.Kana ukashandisa PHP script kugadzira MySQL temporary table, temporary table inozoparadzwa otomatiki pese panoitwa PHP script.

Kana iwe ukashandisa imwe MySQL client program kuti ubatanidze kune MySQL database server kuti ugadzire tafura yenguva pfupi, tafura yenguva pfupi ichaparadzwa chete kana purogiramu yeklayiti yakavharwa.

muenzaniso

Izvi zvinotevera muenzaniso wakapfava wekushandisa MySQL temporary table, inotevera SQL kodhi inogona kuiswa kune mysql_query() basa reiyo PHP script.

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 秒）



                                   

  

paunoshandisaRatidza TABLESKana rairo richiratidza runyorwa rwematafura edata, haugone kuona iyo SalesSummary tafura.

Kana iwe ukabuda kunze kweiyo MySQL musangano, wobva washandisaSELECTkuraira kuverenga iyo yakasikwa yenguva tafura data, ipapo iwe uchaona kuti tafura haipo mudhatabhesi, nekuti tafura yenguva pfupi yaparadzwa paunobuda.

Drop MySQL temporary table

Nekutadza, matafura enguva pfupi anoparadzwa otomatiki kana iwe ukabvisa kubva kudhatabhesi.Ehe iwe unogona zvakare kushandisa mune yazvino MySQL musanganoDROP TABLEraira kuti udonhedze tafura yenguva.

Unotevera muenzaniso wekudonhedza tafura yenguva mawoko:

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' 不存在