MySQL示例数据库

MySQL示例数据库

在本MySQL教程中,大部分操作是基于yiibaidb这个数据库作为学习MySQL示例数据库,这样的话有助于您快速有效地使用MySQL。yiibaidb数据库是一个典型汽车零售商数据库模型。它包含典型的业务数据,如客户,产品,销售订单,销售订单等。

我们在MySQL教程中使用此示例数据库来演示从简单查询到复杂存储过程的许多MySQL功能。

下载MySQL示例数据库

可以在以下链接中下载本MySQL教程所使用的示例数据库(yiibaidb)。

示例数据库下载地址:http://www.yiibai.com/downloads/yiibaidb.zip

在解压缩上面的文件后,可以将示例数据库导入到MySQL数据库服务器中,方法如下:将示例数据库导入到MySQL数据库服务器中,并使用以下SQL语句进行测试:

USE yiibaidb;
SELECT * FROM customers;

上面语句首先将当前数据库切换到yiibaidb数据库下,并从customers表查询数据。如果您看到返回的客户数据,说明已成功将示例数据库(yiibaidb)导入MySQL数据库服务器了。

MySQL示例数据库结构

MySQL示例数据库模式由以下表组成:

  • customers: 存储客户的数据。
  • products: 存储汽车的数据。
  • productLines: 存储产品类别数据。
  • orders: 存储客户订购的销售订单。
  • orderDetails: 存储每个销售订单的订单产品数据项。
  • payments: 存储客户订单的付款数据信息。
  • employees: 存储所有员工信息以及组织结构,例如,直接上级(谁向谁报告工作)。
  • offices: 存储销售处数据,类似于各个分公司。

表与表之间的关系,请参考以下ER图 –

我们建议您打印出此 ER 图,并将其粘贴到桌面上,以便在学习MySQL的过程中熟悉其中的表之间的关联关系。

 

移动端:请扫描本页面底部(右侧)二维码并关注微信公众号,回复:”教程” 选择相关教程阅读

96 Responses

  1. Ttehmm说道:

    lexapro brand lexapro drug revia 50 mg sale

  2. Bzgpgw说道:

    buy clavulanate pill order serophene online clomiphene for sale online

  3. Ylpszj说道:

    buy cheap strattera order sertraline 50mg sale buy sertraline 100mg online cheap

  4. Rhqrfh说道:

    order generic furosemide 40mg doxycycline 100mg usa cheap albuterol

  5. Ppkgdw说道:

    cost actigall generic actigall cetirizine tablet

  6. Gpvgpj说道:

    is mylanta better than rolaids acid reflux medicine name what to take for flatulence

  7. Tqsyyg说道:

    order zithromax 250mg pill neurontin 800mg pills oral gabapentin

  8. Uuzjnq说道:

    buy birth control pills walgreens vitamin to increase women’s libido medications for early ejaculation

  9. Wkdvyy说道:

    buy deltasone 40mg sale oral prednisone 40mg buy amoxil 1000mg pill

  10. Aferbf说道:

    stomach ulcers medications list best online doctors for uti gram negative bacilli examples

  11. Atvzsn说道:

    promethazine 25mg over the counter how to buy phenergan where to buy ivermectin

  12. Urglow说道:

    strongest natural antifungal 4 types of antifungal medicaments high blood pressure treatment online

  13. Nugalc说道:

    cymbalta 40mg ca order provigil 100mg for sale order provigil 100mg online

  14. Yyzuiv说道:

    antiviral drugs uses expected findings type 2 diabetes best meds for pre diabetics

  15. Gxparv说道:

    cyproheptadine 4mg over the counter buy cyproheptadine 4mg sale buy nizoral 200 mg without prescription

  16. Gjxicn说道:

    free meds to quit smoking online doctors for pain medication buy strong painkillers online uk

  17. Rompjs说道:

    provera uk microzide usa hydrochlorothiazide without prescription

  18. Jeotqi说道:

    prescription drug for sleep olumiant approved for alopecia what is the strongest weight loss prescription pill

  19. Bgahma说道:

    buy letrozole cheap abilify 30mg generic aripiprazole 20mg pills

  20. Yidfij说道:

    buy alfuzosin cheap drugs for gerd prescription medication thats makes you puke

  21. Wwtuxs说道:

    acne treatment for teenage girl trileptal order online cost oxcarbazepine

  22. smeri说道:

    The perfect way to spend summer is at the beach. Well, if you can’t be at the beach right now, why not role play a beach day on Roblox? Take some photos and enjoy your time roleplaying with friends. Collect dozens of cute and exotic animals as you explore a magical island in DreamCraft’s massively popular social roleplay game Adopt Me. Build and customize your house. Raise your pets and teach them new tricks. Or simply hang out with your friends: go camping, throw a pool party, and so much more. There are multiple different roles to choose from in Emergency Response: Liberty County on its high player count servers. Players can be a DoT worker, a Police Officer, a Sheriff, a Firefighter, or a Hospital Worker. Players can also choose to play civilian roles, like being a Farmer, and can even be a Criminal who incites the emergencies that need responding to.
    https://socialsocial.social/user/gamersindia
    You can read more about the gameplay of one of the best games here. After many years, Charles Martinet has stepped down and will no longer be voicing Mario; he is now a Mario ambassador. Super Mario Bros. Wonder will welcome Kevin Afghani as the voice of Mario as well as his brother, Luigi. Mario vs. Donkey Kong was announced during today’s Nintendo Direct. Launching on February 16, this new title is the first entry in the Mario vs. Donkey Kong series to hit the Nintendo Switch and the latest in the series since its last entry in 2016. ROM sizes vary, but generally the newer the console, the bigger the file size. Super Mario Bros. 3, for instance, is only about 384KB, whereas Super Mario Sunshine reaches almost 1GB. Join Mario, Luigi, and pals for single-player or multiplayer* fun anytime, anywhere!

  23. Pksffp说道:

    rocaltrol 0.25mg sale trandate oral buy fenofibrate

  24. Nvnksg说道:

    catapres medication meclizine for sale online buy tiotropium medication

  25. Mtpfoa说道:

    dissertation writers online free money no deposit betting casino bonus

  26. Gjpbeb说道:

    trimox 250mg generic buy macrobid online purchase biaxin without prescription

  27. Ejnswi说道:

    order aspirin online slots games free best online poker sites

  28. Tpmetu说道:

    essays writing order suprax 200mg without prescription buy suprax 100mg pills

  29. Xilssv说道:

    order generic desyrel how to get clindac a without a prescription clindamycin uk

  30. Ydhwpm说道:

    buy generic ceftin 250mg cost lumigan robaxin 500mg ca

  31. Roodjr说道:

    buy cheap lamisil pennsylvania online gambling bill online black jack

  32. Wgvora说道:

    purchase nolvadex for sale symbicort inhalers where to buy symbicort without a prescription

  33. Ntvtzd说道:

    how to buy tadacip order indocin 75mg pills buy indomethacin 50mg sale

  34. Lwjviq说道:

    brand cleocin 300mg buy erythromycin 500mg online buy sildenafil 50mg for sale

  35. Esutlw说道:

    buy tretinoin tablets oral tadalis buy avanafil without prescription

  36. Hedpyz说道:

    buy flagyl 200mg for sale how to buy bactrim order keflex without prescription

  37. Wthxvv说道:

    order generic lamictal 50mg buy generic nemazole online vermox usa

  38. Glraox说道:

    cost diflucan 100mg ampicillin uk cipro without prescription

  39. Joasys说道:

    buy sildenafil 50mg for sale buy estradiol 2mg online estradiol 1mg without prescription

  40. Iqpmtk说道:

    spironolactone 25mg oral order spironolactone 25mg pills order propecia 5mg generic

  41. Oaavmx说道:

    write research papers college essay service cheap essay writer

  42. Rgvfdq说道:

    order generic tamsulosin 0.4mg buy tamsulosin pills for sale simvastatin order online

  43. Vegyko说道:

    order motilium 10mg generic order sumycin 250mg sale buy sumycin for sale

  44. Xapggo说道:

    zantac medication celebrex 100mg cheap buy cheap generic celecoxib

  45. Qzcelk说道:

    buspirone 10mg pills purchase amiodarone online order amiodarone 200mg generic

  46. Vzmebv说道:

    purchase imitrex pill imitrex online buy dutasteride medication

  47. Lphjgd说道:

    purchase zyloprim for sale order clobetasol generic cheap crestor 20mg

  48. Vpqddk说道:

    esomeprazole order order topiramate 200mg generic buy topiramate 200mg pill

  49. Gplahi说道:

    order famotidine pills famotidine online order prograf 1mg without prescription

  50. Srzmqt说道:

    astelin 10 ml ca buy generic azelastine online irbesartan 300mg pill

  51. Jovkuh说道:

    buy coumadin 2mg paxil 20mg sale order metoclopramide 20mg online

  52. Frtjsp说道:

    order xenical generic generic mesalamine diltiazem order

  53. Pdcbho说道:

    order nortriptyline 25 mg pills buy anacin 500 mg for sale order anacin generic

  54. Dwtoms说道:

    buy inderal 20mg without prescription buy inderal 20mg buy clopidogrel 75mg without prescription

  55. Cfjbam说道:

    buy fosamax 70mg sale order colcrys for sale purchase furadantin

  56. Qyajli说道:

    lioresal for sale order endep 50mg generic order generic toradol 10mg

  57. Purrcs说道:

    purchase glimepiride without prescription buy etoricoxib cheap cheap etoricoxib 60mg

  58. Ofxygt说道:

    purchase lioresal generic ketorolac for sale toradol 10mg price

  59. Bmxkrw说道:

    loratadine 10mg sale buy dapoxetine 60mg without prescription order generic dapoxetine 90mg

  60. Kjookw说道:

    dilantin 100 mg for sale ditropan 5mg sale ditropan online buy

  61. plags说道:

    You can email the site owner to let them know you were blocked. Please include what you were doing when this page came up and the Cloudflare Ray ID found at the bottom of this page. In The Hand of Midas ci sono due tipi di simboli. I primi sono le carte da gioco e hanno un basso valore. Gli altri sono simboli tematici e pagano piuttosto bene. Dal più basso al più alto troviamo: la coppa di vino, il cesto di frutta, il forziere colmo di monete, la figlia di Odino trasformata in una statua d’oro, il Dio Dionisio e infine il re Mida. Sul nostro sito puoi giocare alle slot online, senza spendere soldi e senza registrazione né deposito. Per chi volesse incrementare le chance di vittoria, si può scegliere di aggiungere un moltiplicatore di 20x o di 25x. Si possono inoltre comprare un numero variabile di giri gratis. Ci sono 3 opzioni:
    https://www.tool-bookmarks.win/siti-stranieri-bonus-senza-deposito
    Il Cabernet Sauvignon – come lo Chardonnay, varietà non riconosciuta dal disciplinare dell’epoca – fu impiantato per la prima volta in Sicilia nella Tenuta Regaleali nel 1985. E’ il primo Cabernet Sauvignon in purezza realizzato in Sicilia, pluripremiato per la sua personalità e per l’originalità con cui esprime il territorio da cui proviene, la Tenuta Regaleali. Rosso rubino intenso, al naso esprime la quintessenza del varietale, con un tocco mediterraneo, grazie ad aromi di frutti di bosco e sentori di spezie, pepe nero, tabacco, cannella, vaniglia. Al palato è ricco ed elegante, caratterizzato da tannini persistenti e morbidi, molto equilibrato e lunghissimo. Tasca d’Almerita Bignami vini e liquori Tasca d’Almerita 9,40 € Tasca d’Almerita Tenuta Regaleali Perricone Guarnaccio Sicilia DOC – Pz per Cartone: 6…..

  62. Coednd说道:

    vardenafil 20mg for sale buy cheap generic zanaflex purchase tizanidine for sale

  63. Kzxfew说道:

    buy aceon online aceon 8mg brand allegra 120mg pill

  64. Pbasfg说道:

    clomiphene drug imdur brand buy imuran for sale

  65. Vkliam说道:

    online casino buy levothyroxine without a prescription order levoxyl pills

  66. Inagkd说道:

    medrol cost in usa buy medrol canada order aristocort 10mg online cheap

  67. Frjxjz说道:

    best online casino for money stromectol online order ivermectin 5ml

  68. Dscmsw说道:

    buy amantadine 100mg sale buy atenolol generic aczone online buy

  69. Ovlkko说道:

    free slot play free casino slot games purchase albuterol for sale

  70. Svwvpr说道:

    online blackjack spins website gambling games purchase lasix sale

  71. Ynkmss说道:

    buy pantoprazole 20mg online order protonix 20mg online order phenazopyridine 200mg for sale

  72. Mzemda说道:

    azithromycin 500mg cost buy neurontin sale neurontin 600mg tablet

  73. Alkznp说道:

    accutane price isotretinoin 20mg pill azithromycin order

  74. Nrvugz说道:

    generic lipitor 40mg purchase lipitor online order norvasc pills

  75. Aozufi说道:

    modafinil 200mg uk buy cheap generic promethazine deltasone for sale online

  76. Popsvl说道:

    cefdinir 300 mg tablet purchase prevacid generic purchase lansoprazole

  77. Tmggyj说道:

    purchase cenforce naproxen 250mg us chloroquine 250mg uk

  78. Xjgsag说道:

    oral telmisartan plaquenil 400mg uk brand molnupiravir

  79. Ygtyky说道:

    cheap premarin 0.625mg purchase cabergoline pills sildenafil australia

  80. Waceos说道:

    prilosec 20mg sale omeprazole sale order metoprolol 50mg pill

  81. Ighmyo说道:

    brand latanoprost order capecitabine 500mg online order exelon 3mg generic

  82. Mvdfvu说道:

    generic betahistine 16mg buy haloperidol paypal order benemid 500mg

  83. Htmpwg说道:

    how to get pyridostigmine without a prescription buy generic piroxicam 20mg maxalt canada

  84. Lcwvqe说道:

    how to get vasotec without a prescription vasotec over the counter order duphalac

  85. Jayads说道:

    ferrous 100mg ca buy betapace 40 mg generic buy betapace medication

  86. Xujkmc说道:

    etodolac 600 mg price cilostazol 100mg price generic pletal

  87. Kkvnqs说道:

    purchase prasugrel pills dimenhydrinate order buy detrol 1mg for sale

  88. Zgbyjv说道:

    dydrogesterone pill order januvia generic purchase empagliflozin online

  89. Gudnna说道:

    fludrocortisone 100mcg for sale pill loperamide 2 mg order imodium without prescription

  90. Efevsb说道:

    order generic melatonin desogestrel tablet danazol where to buy

  91. Ovfxvm说道:

    aspirin 75mg usa buy levoflox 250mg online buy zovirax cream for sale

  92. Qpthzk说道:

    order dipyridamole online cheap pravastatin 20mg pills buy pravachol pills

  93. Wzhvck说道:

    how to buy mintop minoxidil online ed pills online

  94. Wiwxxx说道:

    cost acarbose buy generic acarbose for sale order griseofulvin 250 mg sale

  95. Dybcss说道:

    cialis tadalafil cheap generic sildenafil cheap sildenafil 100mg

  96. Nubncw说道:

    tricor over the counter order tricor 160mg generic fenofibrate price

发表回复

您的电子邮箱地址不会被公开。 必填项已用 * 标注

CAPTCHAis initialing...