Pehea ka hana a MySQL i kahi papa ʻaina manawa? ʻO ke kuleana o nā papa manawa pōkole MySQL

MySQLPehea e hana ai / hoʻolei i ka papaʻaina temp?MySQLʻO ke kuleana o nā papa ʻaina manawa

Pākaukau no ka manawa pōkole MySQL

He mea maikaʻi loa nā papa ʻaina MySQL i ka wā e pono ai mākou e mālama i kekahi ʻikepili pōkole.ʻIke wale ʻia nā papa ʻaina i ka pilina o kēia manawa. Ke pani ʻia ka pilina, e holoi ʻo Mysql i ka papaʻaina a hoʻokuʻu i nā wahi āpau.

Ua hoʻohui ʻia nā pākaukau manawa ma ka mana MySQL 3.23. Inā ʻoi aku ka haʻahaʻa o kāu mana MySQL ma mua o ka mana 3.23, ʻaʻole hiki iā ʻoe ke hoʻohana i nā papa ʻaina MySQL.Eia nō naʻe, kakaikahi ka hoʻohana ʻana i kahi mana haʻahaʻa i kēia manawa.MySQL waihonalawelawe.

Hiki ke ʻike ʻia ka papa ʻaina manawaleʻa o MySQL i ka pilina o kēia manawa. Inā hoʻohana ʻoe i ka palapala PHP no ka hana ʻana i kahi papa ʻaina MySQL, e hoʻopau ʻia ka papa ʻaina manawa i ka wā e hoʻokō ʻia ai ka palapala PHP.

Inā ʻoe e hoʻohana i kekahi polokalamu mea kūʻai aku MySQL e hoʻopili i ka kikowaena waihona MySQL e hana i kahi papaʻaina no ka manawa pōkole, e luku wale ʻia ka papa ʻaina i ka wā e pani ʻia ai ka polokalamu mea kūʻai aku.

laʻana

Hōʻike kēia i kahi hiʻohiʻona maʻalahi o ka hoʻohana ʻana i ka papa ʻaina manawaleʻa MySQL, hiki ke hoʻopili ʻia kēia code SQL i ka hana mysql_query() o ka palapala 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 秒）



                                   

  

ke hoohana oeNĀ HOʻOPIHEKe hōʻike ke kauoha i ka papa inoa o nā papa ʻikepili, ʻaʻole ʻoe e ʻike i ka papa SalesSummary.

Inā haʻalele ʻoe i kēia manawa MySQL, a laila hoʻohanakoho ikauoha e heluhelu i ka ʻikepili papa ʻaina i hana mua ʻia, a laila e ʻike ʻoe ʻaʻole i loaʻa ka papa ʻaina i ka waihona, no ka mea, ua luku ʻia ka papa ʻaina i kou puka ʻana.

E hoʻokuʻu i ka papaʻaina pōkole MySQL

Ma ka paʻamau, hoʻopau koke ʻia nā papa ʻaina i ka wā e hemo ai ʻoe mai ka waihona.ʻOiaʻiʻo hiki iā ʻoe ke hoʻohana i ka manawa MySQL i kēia manawaPAPA PALAPALAkauoha e hoʻokuʻu lima i ka papa ʻaina.

Eia kekahi laʻana o ka hoʻokuʻu lima ʻana i kahi papa ʻaina manawaleʻa:

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