Sidee MySQL u abuurtaa/u daadisaa miis ku meel gaar ah? Doorka miisaska ku meel gaadhka ah ee MySQL

Sidee loo sameeyaa/tirtiraa jadwal ku meel gaar ah oo MySQL ah ? Waa maxay ujeeddada loo sameeyay jadwalada ku meel gaarka ah ee MySQL ?

MySQL miiska ku meel gaarka ah

Shaxda ku meel gaadhka ah ee MySQL waa mid aad faa'iido u leh markaan u baahanahay inaan kaydino xogta ku meel gaarka ah.Jadwalka ku meel gaadhka ah ayaa ka dhex muuqda xidhiidhka hadda jira, marka xidhiidhku xidhmo, Mysql waxa uu si toos ah u tirtiri doonaa miiska oo uu sii deyn doonaa dhammaan boosaska.

Miisaska ku meel gaarka ah waxaa lagu daray nooca MySQL 3.23. Haddii nooca MySQL uu ka hooseeyo 3.23, ma isticmaali kartid miisaska ku meel gaarka ah ee MySQL. Si kastaba ha ahaatee, noocyada hooseeya ee adeegyada keydka xogta MySQL ayaa si dhif ah loo isticmaalaa maalmahan.

Shaxda ku meel gaadhka ah ee MySQL waxa kaliya oo la arki kara xidhiidhka hadda jira.Haddii aad isticmaasho script PHP si aad u abuurto miis ku meel gaadh ah MySQL, miiska ku meel gaadhka ah si toos ah ayaa loo burburin doonaa mar kasta oo qoraalka PHP la fuliyo.

Haddii aad isticmaasho barnaamij kale oo macmiilka MySQL ah si aad ugu xidho server-ka MySQL si aad u abuurto miis ku meel gaadh ah, miiska ku meel gaadhka ah waxa la burburin doonaa oo kaliya marka barnaamijka macmiilku xidho.Dabcan, waxa kale oo aad gacanta ku burburin kartaa.

tusaale

Kuwa soo socdaa waxay muujinayaan tusaale fudud oo ah isticmaalka miiska ku meel gaadhka ah ee MySQL, koodhkan soo socda ee SQL waxa lagu dabaqi karaa shaqada mysql_query() ee qoraalka 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 秒）



                                   

  

Markaad isticmaasho amarka SHOW TEBLES si aad u soo bandhigto liiska jadwalka, ma arki doontid jadwalka SalesSummary.

Haddii aad ka baxdo kalfadhiga MySQL ee hadda jira ka dibna aad isticmaasho amarka SELECT si aad u akhrido xogta jadwalka ku meel gaarka ah ee hore loo sameeyay, waxaad ogaan doontaa in jadwalku uusan ku jirin kaydka xogta sababtoo ah jadwalka ku meel gaarka ah ayaa la burburiyay markii aad ka baxday.

Tuur miiska ku meel gaadhka ah ee MySQL

Sida caadiga ah, jadwalada ku meel gaarka ah si toos ah ayaa loo burburiyaa marka aad ka goyso xogta. Haddii kale, waxaad gacanta ku tirtiri kartaa jadwalada ku meel gaarka ah ee ku jira kalfadhiga MySQL ee hadda jira adoo isticmaalaya amarka DROP TABLE .

Kuwa soo socdaa waa tusaale gacanta lagu tuurayo miis ku meel gaadh ah:

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