E fa'afefea ona faia e MySQL se laulau le tumau? Le matafaioi a MySQL laulau le tumau

MySQLE fa'afefea ona fai/tapē'ese se laulau lē tumau?MySQLLe matafaioi a laulau le tumau

MySQL laulau lē tumau

MySQL laulau le tumau e aoga tele pe a tatou manaʻomia le faʻasaoina o ni faʻamatalaga le tumau. O laulau le tumau e naʻo le vaʻaia o le fesoʻotaʻiga o loʻo iai nei Pe a tapunia le fesoʻotaʻiga, o le a otometi lava ona tape e Mysql le laulau ma faʻasaʻo avanoa uma.

Na fa'aopoopoina laulau le tumau i le MySQL version 3.23 Afai e la'ititi lau version MySQL nai lo le 3.23, e le mafai ona e fa'aogaina laulau le tumau a MySQL. Ae o lenei ua seasea ona faʻaaogaina se faʻamatalaga maualalo.MySQL databaseAuauna.

O le laulau le tumau a MySQL e na'o le feso'ota'iga o lo'o iai nei Afai e te fa'aogaina le PHP script e fai ai se laulau le tumau MySQL, o le a fa'aumatia le laulau le tumau i so'o se taimi e fa'atino ai le PHP script.

Afai e te faʻaogaina se isi polokalame MySQL client e faʻafesoʻotaʻi i le MySQL database server e fatu ai se laulau le tumau, o le laulau le tumau o le a faʻaumatia pe a tapunia le polokalama o le kalani Ioe, e mafai foi ona e faʻaumatia ma le lima.

Fa'ata'ita'iga

O lo'o fa'aalia i lalo se fa'ata'ita'iga faigofie o le fa'aogaina o se laulau le tumau MySQL Ole fa'ailoga SQL lea e mafai ona fa'aoga ile mysql_query() galuega ole 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 秒）



                                   

  

pe a e faʻaaogainaFAAALI ATUA faʻaalia e le faʻatonu se lisi o laulau faʻamaumauga, o le a le mafai ona e vaʻai i le laulau SalesSummary.

Afai e te alu ese mai le taimi nei MySQL sauniga, ona faʻaaoga leaFILIFILIpoloaiga e faitau faʻamatalaga o le laulau le tumau na faia muamua, o le ae iloa ai e le o iai le laulau i totonu o le database ona o le laulau le tumau ua faʻaumatia pe a e alu ese.

Aveese le laulau le tumau MySQL

Ona o le faaletonu, o laulau le tumau e otometi lava ona faʻaumatia pe a e motusia mai le database. Ioe e mafai foi ona e faʻaaogaina i le taimi nei MySQL saunigaLA'AU FA'ATUPoloaiga e tape ma le lima le laulau le tumau.

Ole fa'ata'ita'iga lea ole tapeina ma le lima ole laulau le tumau:

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