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

MySQLSidee loo abuuraa/hoos u dhigaa miiska heerkulka?MySQLDoorka miisaska ku meel gaarka ah

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.

Shaxano ku meel gaadh ah ayaa lagu daray MySQL nooca 3.23. Haddii nooca MySQL uu ka hooseeyo nooca 3.23, ma isticmaali kartid miisaska ku meel gaadhka ah ee MySQL.Si kastaba ha ahaatee, waa dhif in la isticmaalo nooca hooseeya hadda.database MySQLadeeg

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



                                   

  

marka aad isticmaashoMAWDUUCA TUSAALOOYINMarka amarku soo bandhigo liiska shaxanka xogta, ma awoodi doontid inaad aragto shaxda IibkaSummary.

Haddii aad ka baxdo fadhiga MySQL ee hadda, isticmaalDooroamar si aad u akhrido xogta miiska ku meel gaadhka ah ee asal ahaan la sameeyay, ka dibna waxaad ogaan doontaa in miiska uusan ku jirin kaydka xogta, sababtoo ah miiska ku meel gaarka ah ayaa la burburiyay markaad ka baxdo.

Tuur miiska ku meel gaadhka ah ee MySQL

Sida caadiga ah, miisaska ku meel gaadhka ah si toos ah ayaa loo burburiyaa marka aad ka baxdo xogta xogta.Dabcan waxaad sidoo kale isticmaali kartaa fadhiga MySQL ee haddaMIISKA DHICIamar in gacanta lagu tuuro miiska ku meel gaarka ah.

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