MySQL导入示例数据库

MySQL导入示例数据库

在本教程中,将学习如何在MySQL命令行下将MySQL示例数据库导入到MySQL数据库服务器中。 在本教程之后,您将yiibaidb示例数据库导入到MySQL服务器中以实践和学习MySQL。

第一步: 从MySQL示例数据库文章中下载示例数据库(yiibaidb),有关示例数据库的结构,请参考: http://www.yiibai.com/mysql/sample-database.html

第二步: 将下载的文件解压缩到临时文件夹中。为了简单起见,我们将把它解压缩到D:\worksp,如下所示 –

第三步: 连接到MySQL服务器并创建数据库

D:\software\mysql-5.7.18-winx64\bin>mysql -hlocalhost -uroot -p
Enter password: ******
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 23
Server version: 5.7.9 MySQL Community Server (GPL)

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

创建数据库 –

mysql> CREATE DATABASE IF NOT EXISTS yiibaidb DEFAULT CHARSET utf8 COLLATE utf8_general_ci;

mysql> use yiibaidb;

导入数据 –

mysql> use yiibaidb;
mysql> source D:/worksp/yiibaidb.sql;

第四步: 测试导入结果

mysql> select city,phone,country from `offices`;
+---------------+------------------+-----------+
| city          | phone            | country   |
+---------------+------------------+-----------+
| San Francisco | +1 650 219 4782  | USA       |
| Boston        | +1 215 837 0825  | USA       |
| NYC           | +1 212 555 3000  | USA       |
| Paris         | +33 14 723 4404  | France    |
| Beijing       | +86 33 224 5000  | China     |
| Sydney        | +61 2 9264 2451  | Australia |
| London        | +44 20 7877 2041 | UK        |
+---------------+------------------+-----------+
7 rows in set (0.00 sec)

在本教程中,我们演示了如何使用MySQL命令行将MySQL示例数据库导入到MySQL数据库服务器中。

 

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

93 Responses

  1. Ogugwt说道:

    order furosemide 100mg generic buy doxycycline 200mg online cheap order albuterol

  2. Lwgexv说道:

    escitalopram 20mg without prescription purchase naltrexone without prescription order naltrexone 50 mg without prescription

  3. Yoeyeu说道:

    strattera canada buy zoloft online cheap purchase sertraline generic

  4. Rcqqfv说道:

    purchase urso for sale buy ursodiol 300mg pills order zyrtec pill

  5. Cxlval说道:

    azithromycin buy online azithromycin 500mg usa buy neurontin sale

  6. Pcaezw说道:

    ppi stronger than prilosec over the counter medication list medications that cause excessive flatulence

  7. Zsrukf说道:

    order prednisone 10mg without prescription buy prednisone generic brand amoxil 500mg

  8. Qonnzr说道:

    birth control prescription renew online 10 best male enhancement pills best prescription for premature ejaculation

  9. Fztyae说道:

    brand phenergan stromectol for sale ivermectin 6 mg over the counter

  10. Bjpepm说道:

    erosions in the duodenal bulb peptic ulcer diagnosis and treatment gram positive bacteria causing uti

  11. Sektik说道:

    order generic cymbalta 40mg glucotrol 10mg cheap order modafinil

  12. Trysfy说道:

    prescription strength antifungal cream 5 most common hypertensive medications how does sodium affect blood pressure

  13. Iyafhv说道:

    periactin 4 mg pills cost luvox brand nizoral 200mg

  14. Pwfpza说道:

    valacyclovir how long to take prediabetes drugs list diabetes diet pills that work

  15. Sftwnb说道:

    medroxyprogesterone price praziquantel uk order microzide

  16. Rfngfl说道:

    best brand for quit smoking best prescription arthritis pain reliever can you buy painkillers online

  17. Blshmc说道:

    oral letrozole order albendazole 400 mg for sale abilify 30mg without prescription

  18. Epcier说道:

    uksleepingpillsonline.com buying sleeping tablets on internet fda approved weight loss pills

  19. Fvptul说道:

    buy minocin pills order requip 2mg without prescription buy ropinirole generic

  20. Skdxom说道:

    buy uroxatral paypal does benadryl make you sweat prescription meds for stomach cramps

  21. Wpukzu说道:

    brand catapres 0.1 mg tiotropium bromide pill spiriva over the counter

  22. Crtdev说道:

    dermatologist acne treatment pills trileptal 300mg sale trileptal pills

  23. Inyynh说道:

    buy amoxicillin 500mg generic trimox 250mg without prescription order clarithromycin 500mg pills

  24. Agornd说道:

    calcitriol 0.25 mg without prescription order calcitriol 0.25mg buy fenofibrate 200mg pill

  25. Onhcni说道:

    buy an assignment essay on the help cefixime 100mg brand

  26. Etnodp说道:

    buy custom research papers casino games real money casino games online real money

  27. Agwkes说道:

    aspirin cost purchase aspirin without prescription best online gambling sites

  28. Ocfznj说道:

    order lamisil 250mg online cheap list online gambling real money online poker

  29. Oofdjp说道:

    order trazodone generic buy suhagra online cheap buy clindac a without prescription

  30. Tbuxso说道:

    order tadalafil 20mg online cheap order voltaren 100mg for sale indocin 50mg generic

  31. Wpmmqk说道:

    order ceftin 500mg for sale buy careprost without prescription methocarbamol 500mg generic

  32. Vcrcuh说道:

    nolvadex uk where can i buy betahistine rhinocort nasal spray

  33. Occgip说道:

    retin cream oral buy retin cream online cheap buy generic avanafil over the counter

  34. Uenixa说道:

    lamictal buy online buy generic lamotrigine vermox us

  35. Nogjsw说道:

    flagyl 400mg cheap order flagyl 200mg sale buy keflex generic

  36. Atcccz说道:

    aurogra 50mg without prescription order estradiol 2mg online cheap estradiol 2mg cost

  37. Naifcn说道:

    diflucan online order generic acillin cipro 500mg sale

  38. Ennznw说道:

    do my term paper academia writing online essay writing

  39. Uxcfen说道:

    order aldactone 25mg sale order proscar 5mg without prescription order proscar without prescription

  40. Pxrqro说道:

    buy domperidone pills buy generic tetracycline over the counter tetracycline 250mg ca

  41. Xmtcnl说道:

    order tamsulosin generic ondansetron 4mg brand order zocor

  42. Ygmbqw说道:

    buy generic buspar for sale buy cheap generic ezetimibe generic amiodarone 200mg

  43. Ibzbjf说道:

    order zantac 300mg online celecoxib pill order celebrex 100mg generic

  44. Pnqqob说道:

    allopurinol 100mg drug how to get temovate without a prescription crestor 10mg brand

  45. Cmtwpx说道:

    order imitrex 50mg sale sumatriptan over the counter avodart 0.5mg over the counter

  46. Sarlft说道:

    buy nexium medication buy mirtazapine 15mg for sale order topiramate 100mg without prescription

  47. Bucmwh说道:

    astelin 10 ml nasal spray azelastine buy online irbesartan over the counter

  48. Wddont说道:

    order pepcid without prescription losartan 50mg price buy tacrolimus tablets

  49. Ygqssj说道:

    buy orlistat 60mg online order asacol sale buy diltiazem

  50. Qkytsu说道:

    coumadin sale buy coumadin no prescription buy metoclopramide 20mg generic

  51. Jzvwee说道:

    glimepiride 1mg us misoprostol 200mcg usa arcoxia pill

  52. Urvvyi说道:

    order generic nortriptyline cheap methotrexate 5mg cost acetaminophen 500 mg

  53. Lzblsz说道:

    buy inderal generic clopidogrel usa order plavix 75mg generic

  54. Qphjxx说道:

    generic alendronate 35mg buy colchicine pills generic nitrofurantoin 100 mg

  55. Mhsokj说道:

    buy baclofen pill buy generic toradol toradol 10mg usa

  56. Qwmnxd说道:

    brand claritin 10mg how to buy tritace dapoxetine 90mg price

  57. Jdwlbp说道:

    baclofen 25mg us oral endep 50mg toradol cost

  58. Mlzuig说道:

    buy perindopril 4mg for sale buy clarinex 5mg pills allegra 120mg cost

  59. Aajdgn说道:

    buy generic dilantin buy flexeril generic where can i buy ditropan

  60. Fvohxt说道:

    order levitra generic order lanoxin 250mg pill purchase tizanidine generic

  61. Doqxny说道:

    buy medrol 4 mg online order aristocort 4mg online cheap triamcinolone brand

  62. Lnntzb说道:

    oral clomiphene brand imdur 40mg buy imuran generic

  63. Baerco说道:

    amantadine 100mg us buy amantadine 100 mg generic buy avlosulfon paypal

  64. Bwdwdj说道:

    free slot buy levothroid generic cheap levoxyl generic

  65. Whdtmj说道:

    casino slots online casinos for real money ivermectin purchase

  66. Newjja说道:

    where can i buy pantoprazole protonix generic order pyridium 200mg online cheap

  67. Oeuyha说道:

    cash poker online doxycycline usa order albuterol 4mg

  68. Ftpygk说道:

    roulette online with real money play casino slots buy lasix generic

  69. Euwugf说道:

    atorvastatin over the counter lipitor 40mg ca amlodipine 5mg for sale

  70. Yivfip说道:

    buy azithromycin online cheap buy generic gabapentin over the counter gabapentin price

  71. Trqbvy说道:

    isotretinoin 40mg sale zithromax where to buy purchase azithromycin pills

  72. Dteqrj说道:

    cefdinir 300mg canada order metformin 500mg without prescription order prevacid 30mg generic

  73. Lmdudf说道:

    modafinil ca buy modafinil 200mg deltasone 40mg canada

  74. Ujmrsp说道:

    order cenforce 100mg for sale oral cenforce 50mg buy chloroquine online cheap

  75. Zfiifn说道:

    cheap telmisartan 20mg order generic molnunat movfor price

  76. Nkzhfk说道:

    buy cialis 40mg purchase viagra generic viagra overnight shipping usa

  77. Cmwmlj说道:

    omeprazole cost buy generic prilosec over the counter metoprolol 100mg ca

  78. Mmtzpj说道:

    premarin 600 mg for sale viagra 100mg ca viagra 50mg over the counter

  79. Tlcmkv说道:

    brand latanoprost purchase latanoprost sale rivastigmine uk

  80. Ydcjmk说道:

    vasotec 5mg brand buy vasotec for sale how to buy lactulose

  81. Rdtefi说道:

    ferrous tablet ascorbic acid 500 mg price betapace 40mg price

  82. Xhjxny说道:

    mestinon 60 mg pills order maxalt 5mg online order maxalt 5mg generic

  83. Owmvgb说道:

    buy prasugrel generic prasugrel 10 mg ca tolterodine without prescription

  84. Zznxal说道:

    etodolac 600 mg cheap colospa 135mg drug cilostazol 100mg us

  85. Ijfxfl说道:

    buy fludrocortisone paypal buy loperamide without a prescription buy imodium cheap

  86. Tqgycw说道:

    dydrogesterone 10 mg price brand dapagliflozin 10 mg purchase jardiance for sale

  87. Lhkgze说道:

    order dipyridamole pills purchase felodipine generic order generic pravachol 20mg

  88. Wizbrx说道:

    melatonin 3 mg cheap buy generic cerazette order danazol generic

  89. Brpioo说道:

    aspirin usa hydroquinone for sale order imiquad sale

  90. Parfpf说道:

    order acarbose 25mg online precose 50mg usa buy griseofulvin 250 mg pills

  91. Hsqisb说道:

    minoxytop over the counter buy minoxidil sale erection pills online

  92. Ktywnt说道:

    ketotifen 1mg tablet ketotifen 1 mg price imipramine 75mg drug

  93. Oibcqa说道:

    tricor pills buy fenofibrate 160mg pill tricor 200mg sale

发表回复

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

CAPTCHAis initialing...