MySQL e theha / e theola tafole ea nakoana joang? Karolo ea litafole tsa nakoana tsa MySQL

MySQLMokhoa oa ho theha/ho theola tafole ea mocheso?MySQLKarolo ea litafole tsa nakoana

Tafole ea nakoana ea MySQL

Litafole tsa nakoana tsa MySQL li thusa haholo ha re hloka ho boloka data ea nakoana.Litafole tsa nakoana li bonahala feela khokahanong ea hajoale. Ha khokahano e koetsoe, Mysql e tla hlakola tafole ka bo eona ebe e lokolla sebaka sohle.

Litafole tsa nakoana li kentsoe mofuta oa 3.23 oa MySQL. Haeba mofuta oa MySQL o le tlase ho mofuta oa 3.23, u ke ke ua sebelisa litafole tsa nakoana tsa MySQL.Leha ho le joalo, ha hoa tloaeleha ho sebelisa mofuta o tlase joalo hona joale.MySQL databasetshebeletso.

Tafole ea nakoana ea MySQL e bonahala feela ho khokahanyo ea hajoale.Haeba u sebelisa sengoloa sa PHP ho theha tafole ea nakoana ea MySQL, tafole ea nakoana e tla senngoa ka bo eona neng kapa neng ha mongolo oa PHP o etsoa.

Haeba u sebelisa lenaneo le leng la bareki ba MySQL ho hokahanya le seva sa database sa MySQL ho etsa tafole ea nakoana, tafole ea nakoana e tla senngoa feela ha lenaneo la bareki le koetsoe.

Mohlala

Se latelang se bontša mohlala o bonolo oa ho sebelisa tafole ea nakoana ea MySQL, khoutu e latelang ea SQL e ka sebelisoa mosebetsing oa mysql_query() oa 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 秒）



                                   

  

ha u sebelisaBONTŠA LITABAHa taelo e bontša lethathamo la litafole tsa data, u ke ke ua khona ho bona tafole ea SalesSummary.

Haeba u tsoa ka har'a lenaneo la hona joale la MySQL, sebelisaKhethataelo ea ho bala data ea nakoana ea nakoana e bōpiloeng, joale u tla fumana hore tafole ha e eo ho database, hobane tafole ea nakoana e senyehile ha u tsoa.

Tlosa tafole ea nakoana ea MySQL

Ka ho sa feleng, litafole tsa nakoana li senyeha ka bo eona ha o itokolla ho database.Ke 'nete hore u ka boela ua sebelisa lenaneong la hona joale la MySQLTS'ELISI TABELAtaelo ea ho theola tafole ea nakoana ka letsoho.

Se latelang ke mohlala oa ho liha tafole ea nakoana ka letsoho:

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