I-MySQL iyenza/yiwisa njani itafile yethutyana? Indima yeetafile zethutyana zeMySQL

MySQLUyila/uwisa njani itafile yetempe?MySQLIndima yeetafile zexeshana

Itafile yethutyana yeMySQL

Itafile yethutyana yeMySQL iluncedo kakhulu xa sifuna ukugcina idatha yethutyana.Iitafile zexeshana zibonakala kuphela kunxibelelwano lwangoku.Xa uxhulumaniso luvaliwe, iMysql izakucima ngokuzenzekelayo itafile kwaye ikhulule yonke indawo.

Iitheyibhile zexeshana zongezwa kwi-MySQL version 3.23. Ukuba uguqulelo lwakho lweMySQL lungaphantsi kunenguqulo 3.23, awukwazi ukusebenzisa iitafile zethutyana zeMySQL.Nangona kunjalo, kunqabile ukusebenzisa inguqulelo ephantsi ngolo hlobo ngoku.MySQL databaseinkonzo.

Itheyibhile yethutyana yeMySQL ibonakala kuphela kuqhagamshelo lwangoku Ukuba usebenzisa iscript sePHP ukwenza itafile yethutyana yeMySQL, itheyibhile yethutyana iya kutshatyalaliswa ngokuzenzekelayo nanini na xa umbhalo wePHP usenziwa.

Ukuba usebenzisa enye inkqubo yomxhasi weMySQL ukudibanisa kwiseva yedatha yeMySQL ukwenza itafile yethutyana, itafile yethutyana iya kutshatyalaliswa kuphela xa inkqubo yomxhasi ivaliwe.Kakade, unokuyitshabalalisa ngesandla.

Umzekelo

Oku kulandelayo kubonisa umzekelo olula wokusetyenziswa kwetafile yethutyana yeMySQL, le khowudi ilandelayo yeSQL ingasetyenziswa kumysql_query() umsebenzi wescript sePHP.

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



                                   

  

xa usebenzisaBONISA AMABHADIXa umyalelo ubonisa uluhlu lweetafile zedatha, awuyi kukwazi ukubona iSalesSummary table.

Ukuba uphuma kwiseshoni yangoku yeMySQL, sebenzisaKHETHAUmyalelo wokufunda idatha yetafile eyenzelwe ekuqaleni, ngoko uya kufumanisa ukuba itafile ayikho kwisiseko sedatha, kuba itheyibhile yexeshana itshatyalalisiwe xa uphuma.

Lahla itafile yethutyana yeMySQL

Ngokungagqibekanga, iitafile zexeshana zitshatyalaliswa ngokuzenzekelayo xa ukhulula uqhagamshelwano kwisiseko sedatha.Ewe unokusebenzisa kwiseshoni yangoku yeMySQLYIYIPHI ITABILEumyalelo wokuwisa ngesandla itafile yethutyana.

Oku kulandelayo ngumzekelo wokuwisa ngesandla itafile yethutyana:

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