fork(1) download
copy 
  1.  
  2. create table hotel (ID char(5),  Name char(100) , addr char(200) , country char(100) , tel char(30) )
  3.  
  4. insert into hotel (ID , Name , addr , country , tel )
  5. values 
  6. ('00001','101Amici','4F., No.1, Ln. 126, Sec. 1, Fuxing S. Rd., Da"an Dist., Taipei City 106','Taiwan (R.O.C.)','0227728101') ,
  7. ('00002','191 HOTEL','6F., No.165, Nanjing W. Rd., Datong Dist., Taipei City 103','Taiwan (R.O.C.)','0225559711'), 
  8. ('00003','9inehotel','2F., No.255, Sec. 2, Yanping N. Rd., Datong Dist., Taipei City 103','Taiwan (R.O.C.)','0225574999') ,
  9. ('00004','Aloft Taipei Zhongshan','No.1, Shuangcheng St., Zhongshan Dist., Taipei City 104','Taiwan (R.O.C.)','0277439999') ,
  10. ('00005','ART HOTEL','4F., No.142-2, Sec. 2, Changsha St., Wanhua Dist., Taipei City 108,','Taiwan (R.O.C.)','0223885558') ,
  11. ('00006','Apartment 10F','10F.-1, No.1, Sec. 1, Chongqing N. Rd., Datong Dist., Taipei City 103','Taiwan (R.O.C.)','0225597605') ,
  12. ('00007','amba Taipei Zhongshan Hotel','1-8F., No.57-1, Sec. 2, Zhongshan N. Rd., Zhongshan Dist., Taipei City 104','Taiwan (R.O.C.)','0225652828') ,
  13. ('00008','amba Songshan','17F., No.8, Sec. 7, Civic Blvd., Nangang Dist., Taipei City 115','Taiwan (R.O.C.)','0226532828') ,
  14. ('00009','Angels"s House','17F-18F., No.8,N.10, Sec. 1, Keelung Rd., Songshan Dist., Taipei City 105','Taiwan (R.O.C.)','0266176660') ,
  15. ('00010','Angels" Hostel . Taipei Ximen','2F.-2, No.51, Hengyang Rd., Zhongzheng Dist., Taipei City 100','Taiwan (R.O.C.)','0223131319') ,
  16. ('00011','ARK Hotel','3F., No.246, Sec. 2, Minsheng E. Rd., Zhongshan Dist., Taipei City 104','Taiwan (R.O.C.)','0227727750') ,
  17. ('00012','AIRLINE INN','8F., No.144, Sec. 1, Zhonghua Rd., Wanhua Dist., Taipei City 108','Taiwan (R.O.C.)','0223882466') ,
  18. ('00013','ARK HOTEL','1-4F., No.255, Sec. 2, Xinyi Rd., Zhongzheng Dist., Taipei City 100','Taiwan (R.O.C.)','0223912600') ,
  19. ('00014','An Ho Hotel','No.139, Sec. 1, Anhe Rd., Da-an Dist., Taipei City 106','Taiwan (R.O.C.)','0227005088') ,
  20. ('00015','AT Boutique Hotel','3-13F., No.468, Sec. 4, Xinyi Rd., Xinyi Dist., Taipei City 110','Taiwan (R.O.C.)','0223459777') ,
  21. ('00016','amba TAIPEI XIMENDING','5-10F., No.77, Sec. 2, Wuchang St., Wanhua Dist., Taipei City 108','Taiwan (R.O.C.)','0223755171') ,
  22. ('00017','Astar Hotel','No.98, Linsen N. Rd., Zhongshan Dist.','Taiwan (R.O.C.)','0225513131') ,
  23. ('00018','Ambience Hotel','No.64, Sec. 1, Chang’an E. Rd., Zhongshan Dist., Taipei City 104','Taiwan (R.O.C.)','0225410077') , 
  24. ('00018','Aqua Bella Hotel','1-4F., No.63, Wuncyuan Rd., Beitou District, Taipei City 112','Taiwan (R.O.C.)','0228911118') , 
  25. ('00019','Atami Hotel','No.258, Guangming Rd., Beitou Dist., Taipei City 11246','Taiwan (R.O.C.)','0228915161') , 
  26. ('00020','AY JY YUAN HOTEL','5F., No.22, Sec. 2, Keelung Rd., Xinyi Dist., Taipei City 110','Taiwan (R.O.C.)','0227295828') , 
  27. ('00021','ATTIC MOTEL','No.438, Minzu E. Rd., Zhongshan Dist., Taipei City 104','Taiwan (R.O.C.)','0225075999') , 
  28. ('00022','Alper Motel','No.325, Sec. 5, Nanjing E. Rd., Songshan Dist., Taipei City 105','Taiwan (R.O.C.)','0227645858') , 
  29. ('00023','Ambassador Hotel-Taipei','No.63, Sec.2, Zhongshan N. Rd., Zhongshan Dist.','Taiwan (R.O.C.)','0225511111') , 
  30. ('00024','ARISTOCRAT HOTEL','No.20, Lane 379, Jilin Rd., Jhongshan District, Taipei City 104','Taiwan (R.O.C.)','0225942977') , 
  31. ('00025','Beauty Hotels Taipei-Starbeauty Resort','No.38-1,38-2, Qiangang St., Shilin Dist., Taipei City 111','Taiwan (R.O.C.)','0228828080') , 
  32. ('00026','BEAUTYAGE SPRING HOTEL','No.281, Guangming Rd., Beitou Dist., Taipei City 112','Taiwan (R.O.C.)','0228912174') , 
  33. ('00027','BAY MEN HOTEL','No.3, Ln. 145, Chang’an W. Rd., Datong Dist., Taipei City 103','Taiwan (R.O.C.)','0225567797') , 
  34. ('00028','BROAD WAY HOTEL','1-4F., No.99, Wenquan Rd., Beitou Dist., Taipei City 112','Taiwan (R.O.C.)','0228956658') , 
  35. ('00029','Beauty Hotel','No.9, Lane 64, Sec. 2, Jianguo N. Rd., Jhongshan District, Taipei City 104','Taiwan (R.O.C.)','0225031133') , 
  36. ('00030','Best Love Hotel','No.219, Sec. 3, Zhongxiao E. Rd., Da’an Dist., Taipei City 106','Taiwan (R.O.C.)','0227788586') , 
  37. ('00031','BURGARY HOTEL','1-15F., No.168, Sec. 1, Zhonghua Rd., Wanhua Dist., Taipei City 108','Taiwan (R.O.C.)','0223821314') , 
  38. ('00032','backpackers hostel','No.13, Lane 25, Kangding Rd., Wanhua District, Taipei City','Taiwan (R.O.C.)','0289783666') , 
  39. ('00033','BEST HOTEL','6F., No.656,656-1, Sec. 4, Bade Rd., Songshan District, Taipei City 105','Taiwan (R.O.C.)','0227630505') , 
  40. ('00034','Beautique Hotel','NO14,Lane 38,Tianyu St,Shilin Dist,Taipei City 111','Taiwan (R.O.C.)','0228730333') , 
  41. ('00035','BEIMEN HOSTEL','2F., No.21, Yanping S. Rd., Zhongzheng Dist., Taipei City 100','Taiwan (R.O.C.)','0223821818') , 
  42. ('00036','Backpackers Inn, Taipei','2, 3, 4, 5 F No.84 Huaining St., Zhongzheng Dist., Taipei City','Taiwan (R.O.C.)','0223882833') , 
  43. ('00037','Bee House Hotel','No.57,Taiyuan Rd.,Datong Dist.,Taipei City 103','Taiwan (R.O.C.)','0225599000') , 
  44. ('00038','Brother Hotel','No.255, Sec.3, Nanjing E. Rd., Songshan Dist.','Taiwan (R.O.C.)','0227123456') ,
  45. ('00039','BEITOU HOT SPRING RESORT','3F, No.3, Zhongshan Rd., Beitou Dist., Taipei City 112','Taiwan (R.O.C.)','0228988661') ,
  46. ('00040','BIN CHERNG HOTEL','No.7, Ln. 21, Wenquan Rd., Beitou Dist., Taipei City 112','Taiwan (R.O.C.)','0228918312') ,
  47. ('00041','Best Hostel','7F., No.11, Sec. 2, Nanjing E. Rd., Zhongshan Dist., Taipei City 104','Taiwan (R.O.C.)','0225223939') ,
  48. ('00042','Bouti City Capsule Inn','1-4F, No.7, Sec.1, Chongqing S. Rd. Zhongzheng Dist Taipei City Taipei','Taiwan (R.O.C.)','0223815566') ,
  49. ('00043','Cho Hotel','No.119,-1~-6,No.117,-1~-6, Kunming St., Wanhua Dist., Taipei City 108','Taiwan (R.O.C.)','0223709830') ,
  50. ('00044','Courtyard Marriott Taipei','7F.、7F.-1,、8F.、 9F. 、 9F-1、 30F., No.359, Sec. 7, Zhongxiao E. Rd., Nangang Dist., Taipei City 115','Taiwan (R.O.C.)','0221716565') ,
  51. ('00045','ColorMIX Hotel & Hostel','No.22, Ln. 55, Neijiang St., Wanhua Dist., Taipei City 108','Taiwan (R.O.C.)','0223826000') ,
  52. ('00046','CHIC INN','1-6F., No.21, Kangding Rd., Wanhua Dist., Taipei City 108','Taiwan (R.O.C.)','0277136766') ,
  53. ('00047','CityInn Hotel Plus Fuxing N. Rd. Branch','No.338, Fuxing N. Rd., Zhongshan Dist., Taipei City 104','Taiwan (R.O.C.)','0225158777') ,
  54. ('00048','Cheers Plus Hotel','5F.-6~11、15, No.288, Nanjing W. Rd., Datong Dist., Taipei City 103','Taiwan (R.O.C.)','0225596221') ,
  55. ('00049','City Inn Hotel III','1-7F., No.77, Chang’an W. Rd., Datong Dist., Taipei City 103','Taiwan (R.O.C.)','0277327777') ,
  56. ('00050','C U Hotel Taipei','1F., No.198, Minsheng W. Rd., Datong Dist., Taipei City 103','Taiwan (R.O.C.)','0225585500') ,
  57. ('00051','Cityinn Hotel Taipei Station Branch II','No.83, Chang-an W. Rd., Datong District, Taipei City 103','Taiwan (R.O.C.)','0225555577') ,
  58. ('00052','CITY LAKE HOTEL','No.462, Sec. 5, Chenggong Rd., Neihu Dist., Taipei City 114','Taiwan (R.O.C.)','0226306636') ,
  59. ('00053','Caesar Park Hotel','No.38, Chung Hxiao West Road, Sec.1, Zhongzheng Dist.','Taiwan (R.O.C.)','0223115151') ,
  60. ('00054','CITY SUITES Taipei Nanxi','No.169, Nanjing W. Rd., Datong Dist., Taipei City 103','Taiwan (R.O.C.)','0225507722') ,
  61. ('00055','Cosmos Hotel','No.43, Sec.1, Zhongxiao W. Rd., Zhongzheng Dist.','Taiwan (R.O.C.)','0223617856') ,
  62. ('00056','Chaiin Hotel - Dongmen','3F~12F, No.163, Sec. 2, Xinyi Rd., Zhongzheng Dist., Taipei City 100','Taiwan (R.O.C.)','0223582520') ,
  63. ('00057','Capital Hotel Nanjing','No.156, Sec. 4, Nanjing E. Rd., Songshan Dist., Taipei City 105','Taiwan (R.O.C.)','0225796162') ,
  64. ('00058','Capital Hotel-SongShan branch','1-12F., No.658, Sec. 4, Bade Rd., Songshan Dist., Taipei City 105','Taiwan (R.O.C.)','0277375577') ,
  65. ('00059','Chaiin Hotel - Tzung Tung Fu','B1,7-11F., No.86, Sec. 1, Chongqing S. Rd., Zhongzheng Dist., Taipei City 100','Taiwan (R.O.C.)','0223899595') ,
  66. ('00060','Cozzi','No.31, Sec. 1, Zhongxiao E. Rd., Zhongzheng Dist.,Taipei City 100','Taiwan (R.O.C.)','0277253399') ,
  67. ('00061','CHECK INN','1-13F., No.253, Songjiang Rd., Zhongshan Dist., Taipei City 104','Taiwan (R.O.C.)','0225007100') ,
  68. ('00062','Charming Hotel','1-7F., No.16, Sec. 4, Bade Rd., Songshan Dist., Taipei City 105','Taiwan (R.O.C.)','0227630555') ,
  69. ('00063','Cityinn Hotel Plus - Ximending Branc','1-7F., No.124, Hengyang Rd., Zhongzheng Dist., Taipei City 100','Taiwan (R.O.C.)','0277252288') ,
  70. ('00064','CHAIR MAN HOTEL','1-7F., No.88, Sec. 1, Hankou St., Zhongzheng Dist., Taipei City 100','Taiwan (R.O.C.)','0223147305') ,
  71. ('00065','CITIZEN HOTEL','No.80, Sec. 1, Jinshan S. Rd., Zhongzheng Dist., Taipei City 100','Taiwan (R.O.C.)','0223971377') ,
  72. ('00066','CHYUAN DU SPRING RESORT','No.220, Guangming Rd., Beitou Dist., Taipei City 112','Taiwan (R.O.C.)','0228960077') ,
  73. ('00067','Capital Hotel','No.55-1, Nanking E. Rd., Sec. 4, Taipei','Taiwan (R.O.C.)','0287121988') ,
  74. ('00068','Capital Hotel Taipei','No.7, Sec. 2, Jianguo N. Rd., Zhongshan Dist.','Taiwan (R.O.C.)','0225075577') ,
  75. ('00069','CITY HOTEL TAIPEI','No.279, Changchun Rd., Zhongshan Dist., Taipei City 104','Taiwan (R.O.C.)','0225017601') ,
  76. ('00070','CITY SUITES Taipei Nandong','1-7F., No.411, Sec. 5, Nanjing E. Rd., Songshan Dist., Taipei City 105','Taiwan (R.O.C.)','0227425798') ,
  77. ('00071','Caishe Hotel','3 and 7 F., No.34, Nong-an St., Jhongshan District, Taipei City 104','Taiwan (R.O.C.)','0225963969') ,
  78. ('00072','C.H. HOTEL','7F., No.22, Nanjing W. Rd., Datong Dist., Taipei City 103','Taiwan (R.O.C.)','0255524513') ,
  79. ('00073','CHOTAI HOTEL','6F., No.4, Sec. 3, Yanping N. Rd., Datong Dist., Taipei City 103','Taiwan (R.O.C.)','0225859168') ,
  80. ('00074','CARRY HOTEL','No.24, Sec. 1, Roosevelt Rd., Jhongjheng District, Taipei City','Taiwan (R.O.C.)','0223415167') ,
  81. ('00075','CRYSTAL HOTEL','No.192, Xizang Rd., Wanhua Dist., Taipei City 108','Taiwan (R.O.C.)','0223029345') ,
  82. ('00076','CHICAGA HOTEL','No.41, Ln. 119, Linsen N. Rd., Zhongshan Dist., Taipei City 104','Taiwan (R.O.C.)','0955623501') ,
  83. ('00077','Charming Castle Hotel','52,sec.1,changan E.Rd.,Taipei Taiwan','Taiwan (R.O.C.)','0225312121') ,
  84. ('00078','CHARMING CITY HOTEL','No.295, Sec. 4, Xinyi Rd., Da’an Dist., Taipei City 106','Taiwan (R.O.C.)','0227049546') ,
  85. ('00079','City Inn Hotel','No.7, Huaining St., Zhongzheng Dist., Taipei City 100','Taiwan (R.O.C.)','0223148008') ,
  86. ('00080','DOWN TOWN HOTEL','2F., No.33, Sec. 2, Xinyi Rd., Zhongzheng Dist., Taipei City 100','Taiwan (R.O.C.)','0223963322') ,
  87. ('00081','DEJA VU HOTEL','1-4F., No.136, Sec. 1, Fuxing S. Rd., Da’an Dist., Taipei City 106','Taiwan (R.O.C.)','0227765877') ,
  88. ('00082','DAHSHIN HOTEL','No.2-2, Ln. 27, Sec. 2, Zhongshan N. Rd., Zhongshan Dist., Taipei City 104','Taiwan (R.O.C.)','0225652155') ,
  89. ('00083','Dasin Hotel','11-12F., No.246, Changchun Rd., Zhongshan Dist., Taipei City 104','Taiwan (R.O.C.)','0225068866') ,
  90. ('00084','Dolamanco Hotel','No.73, Sec. 3, Xinyi Rd., Da’an Dist., Taipei City 106','Taiwan (R.O.C.)','0227001200') ,
  91. ('00085','Discovery Motel Yanpin','No.23, Sec. 5, Yanping N. Rd., Shilin Dist., Taipei City 111','Taiwan (R.O.C.)','0288112588') ,
  92. ('00086','Dandy Hotel - Tianmu Branch','No.2, Ln. 728, Sec. 6, Zhongshan N. Rd., Shilin Dist., Taipei City 111','Taiwan (R.O.C.)','0228732222') ,
  93. ('00087','Delight Hotel','No. 432 Changchun Rd. Taipei','Taiwan (R.O.C.)','0227160011') ,
  94. ('00088','Dandy Hotel -Daan Park Branch','NO.33,Sec. 3,Xinyi Rd., Da’an Dist., Taipei City 106','Taiwan (R.O.C.)','0227076899') ,
  95. ('00089','Dear Hotel','8F.1.No62.Changchun Rd.Zhongshan Dist.Taipei City104','Taiwan (R.O.C.)','0225411133') ,
  96. ('00090','Di Bao Hotel','No.15, Ln. 57, Chongyang Rd., Nangang Dist., Taipei City 115','Taiwan (R.O.C.)','0226510101') ,
  97. ('00091','DONG MEN HOTEL','No.78, Linyi St., Zhongzheng Dist., Taipei City 100','Taiwan (R.O.C.)','0223560210') ,
  98. ('00092','Dong Wu Hotel','258, Sec. 2, Yan-Ping N. Rd., Taipei (103)','Taiwan (R.O.C.)','0225571261') ,
  99. ('00093','Dandy Hotel','No.13, Ln. 135, Sec. 1, Zhongshan N. Rd., Zhongshan Dist., Taipei City 104','Taiwan (R.O.C.)','0225415788') ,
  100. ('00094','Discovery Hotel.Linsen','1F., No.487, Linsen N. Rd., Zhongshan Dist., Taipei City 104','Taiwan (R.O.C.)','0225683242') ,
  101. ('00095','ding shang 66 hotel','2~4F., No.66, Sec. 1, Xinsheng N. Rd., Zhongshan Dist., Taipei City 104','Taiwan (R.O.C.)','0225232699') ,
  102. ('00096','Diary Hotel','Diary Hotel','Taiwan (R.O.C.)','0223112996') ,
  103. ('00097','Diary of Taipei','5F., No.152, Sec. 1, Xiyuan Rd., Wanhua Dist., Taipei City 108','Taiwan (R.O.C.)','0223144003') ,
  104. ('00098','Dairy of Taipei hotel wanyuo','12-13F., No.52, Hanzhong St., Wanhua Dist., Taipei City 108','Taiwan (R.O.C.)','0223112385') ,
  105. ('00099','DUCKSTAY HOSTEL','No.316,No.318, Kunming St., Wanhua Dist., Taipei City 108','Taiwan (R.O.C.)','0223080066') ,
  106. ('00100','Energy Inn','No.38, Ln. 25, Kangding Rd., Wanhua Dist., Taipei City 108','Taiwan (R.O.C.)','0223121211') ,
  107. ('00101','ECFA HOTEL','ECFA HOTEL','Taiwan (R.O.C.)','0223611010') ,
  108. ('00102','eslite hotel','No.98, Yanchang Rd., Xinyi Dist., Taipei City 110','Taiwan (R.O.C.)','0266262888') ,
  109. ('00103','Eastin Taipei Hotel','14F., No.87, Sec. 4, Zhongxiao E. Rd., Da’an Dist., Taipei City 10690','Taiwan (R.O.C.)','0227766136') ,
  110. ('00104','ELEGANCE HOTEL','No.325, Sec. 1, Neihu Rd., Neihu Dist., Taipei City 114','Taiwan (R.O.C.)','0226586167') ,
  111. ('00105','ECFA HOTEL WH','6F., No. 70, Ximing S. Rd., Wanhua Dist., Taipei City 10844','Taiwan (R.O.C.)','0223613352') ,
  112. ('00106','ECFA HOTEL','10F., No. 79, Kunming St., Wanhua Dist., Taipei City 10845','Taiwan (R.O.C.)','0223613352') ,
  113. ('00107','Easy Stay Ximen Backpackers Guest House','10F., No. 67, Ximing S. Rd., Wanhua Dist., Taipei City 10844','Taiwan (R.O.C.)','0223616167') ,
  114. ('00108','Easymind Guest House','12F., No.66, Sec. 1, Chengde Rd., Datong Dist., Taipei City 103','Taiwan (R.O.C.)','0225526176') ,
  115. ('00109','EasternBeauty Hotel','1-4F., No.33, Yijiang St., Zhongshan Dist., Taipei City 104','Taiwan (R.O.C.)','0225638866') ,
  116. ('00110','EASTERN STAR HOTEL','11F., No.209, Sec. 4, Zhongxiao E. Rd., Da’an Dist., Taipei City 106','Taiwan (R.O.C.)','0287736638') ,
  117. ('00111','Emperor Hotel','No.118, Sec.1, Nanjing E. Rd., Zhongshan Dist. ','Taiwan (R.O.C.)','0225811111') ,
  118. ('00112','Empress Hotel','No.14, Dehui St., Zhongshan Dist.','Taiwan (R.O.C.)','0225913261') ,
  119. ('00113','ECFA HOTEL WH','11F.,11F-1., No.135, Chengdu Rd., Wanhua Dist., Taipei City 108','Taiwan (R.O.C.)','0223613352') ,
  120. ('00114','Evergreen Laurel Hotel (Taipei)','Evergreen Laurel Hotel (Taipei)','Taiwan (R.O.C.)','0225019988') ,
  121. ('00115','East Fang Di Hotel','3F., No.30,32, Ln. 183, Sec. 2, Zhongshan N. Rd., Zhongshan Dist., Taipei City 104','Taiwan (R.O.C.)','0225861880') ,
  122. ('00116','ELOVERS MOTEL','1-8F., No.236, Sec. 7, Chengde Rd., Beitou Dist., Taipei City 112','Taiwan (R.O.C.)','0228288228') ,
  123. ('00117','EVER GREEN HOTEL','No.185, Xining S. Rd., Wanhua Dist., Taipei City 108','Taiwan (R.O.C.)','0223316527') ,
  124. ('00118','ELEGANCE HOTEL','No.139, Sec. 3, Heping E. Rd., Da-an District, Taipei City 106','Taiwan (R.O.C.)','0227388947') ,
  125. ('00119','EverGreen Hotel','No.29, Cingcheng St., Songshan District, Taipei City 105','Taiwan (R.O.C.)','0227188268') ,
  126. ('00120','ERIN HOTEL','No.10, Lane 123, Songjiang Rd., Jhongshan District, Taipei City 104','Taiwan (R.O.C.)','0225076666') ,
  127. ('00121','EAST DRAGON HOTEL','No.23, Sec. 2, Hankou St., Wanhua Dist., Taipei City 108','Taiwan (R.O.C.)','0223116969') ,
  128. ('00122','EMPIRE HOTEL','1-6F., No.108, Wenquan Rd., Beitou Dist., Taipei City 112','Taiwan (R.O.C.)','0289130279') ,
  129. ('00123','Fullon Hotel Taipei','No.266, Sec.1, Jianguo S. Rd., Da-an Dist.','Taiwan (R.O.C.)','0227019266') ,
  130. ('00124','FUH YUN JUANG HOTEL','2-3F., No.8, Aly. 15, Ln. 149, Fugang St., Shilin Dist., Taipei City 111','Taiwan (R.O.C.)','0228822308') ,
  131. ('00125','FORTUNE HOTEL','No.177, Nanking W. Rd., Datong Dist., Taipei City 103','Taiwan (R.O.C.)','0225551016') ,
  132. ('00126','FUH LIH AN HOTEL','5F., No.95-1, Songjiang Rd., Zhongshan Dist., Taipei City 104','Taiwan (R.O.C.)','0225041188') ,
  133. ('00127','FORTUNE HOTEL','No.62, Sec. 1, Chongqing N. Rd., Datong Dist., Taipei City 103','Taiwan (R.O.C.)','0225551122') ,
  134. ('00128','FWU LAI HOTEL','No.13, Lane 344, Nanjing W. Rd., Datong District, Taipei City','Taiwan (R.O.C.)','0225550857 / 0225550427') ,
  135. ('00129','FAR EASTEN PLAZA','No.201, Sec.2, Dunhua S. Rd., Da-an Dist.','Taiwan (R.O.C.)','0223788888 ') ,
  136. ('00130','FUTURE STAR HOTEL','4-8F., No.23 and No.1, Ln. 27, Chengdu Rd., Wanhua Dist., Taipei City 108','Taiwan (R.O.C.)','0223755500') ,
  137. ('00131','FX HOTEL','10-13F., No.131, Sec. 3, Nanjing E. Rd., Zhongshan Dist., Taipei City 104','Taiwan (R.O.C.)','0255720777') ,
  138. ('00132','FORWARD HOTEL TAIPEI','1-7F., No.3, Yijiang St., Zhongshan Dist., Taipei City 104','Taiwan (R.O.C.)','0225118896') ,
  139. ('00133','Friends Hotel Yo Yo','No.24, Changchun Rd., Zhongshan Dist., Taipei City 104','Taiwan (R.O.C.)','0225316767') ,
  140. ('00134','Friends Hotel Yoxing Regency','Friends Hotel Yoxing Regency','Taiwan (R.O.C.)','0223943121') ,
  141. ('00135','FRIENDS HOTEL Yo Tong','13F., No.197, Sec. 4, Zhongxiao E. Rd., Da’an Dist., Taipei City 106','Taiwan (R.O.C.)','0227735177') ,
  142. ('00136','FRIENDS HOTEL YO LAI','No.23-1, Shuangcheng St., Zhongshan Dist., Taipei City 104','Taiwan (R.O.C.)','0225978800') ,
  143. ('00137','FU-HAU HOTEL','No.9, Sec. 2, Fuxing S. Rd., Da’an Dist., Taipei City 106','Taiwan (R.O.C.)','0223250722') ,
  144. ('00138','FERRARY HOTEL','No.41 King Ding Road, Taipei','Taiwan (R.O.C.)','0223818111') ,
  145. ('00139','First Hotel Taipei','No.63, Sec.2, Nanjing E. Rd., Zhongshan Dist.','Taiwan (R.O.C.)','0225418234') ,
  146. ('00140','FLIP FLOP HOSTEL','No.103, Huayin St., Datong Dist., Taipei City 103','Taiwan (R.O.C.)','0225583553') ,
  147. ('00141','Forte Orange Hotel-Ximen','No. 166-2, Section 1, Zhonghua Rd., Wanhua Dist., Taipei City 10846','Taiwan (R.O.C.)','0223115556') ,
  148. ('00142','Formosa101 Hostel','Formosa101 Hostel','Taiwan (R.O.C.)','0223771579') ,
  149. ('00143','Green World Grand Nanjing','1-14F., No.8, Sec. 3, Nanjing E. Rd., Zhongshan Dist., Taipei City 104','Taiwan (R.O.C.)','0225620018') ,
  150. ('00144','GOOD DAY BOUTIQUE HOTEL','2F.-1, 2F.-45 No.282, Linsen N. Rd., Zhongshan Dist., Taipei City 104','Taiwan (R.O.C.)','0225633366') ,
  151. ('00145','Green World Hostel','7F-2., No. 107, Sec. 4, Zhongxiao E. Rd., Da’’an Dist., Taipei City 106','Taiwan (R.O.C.)','0227526533') ,
  152. ('00146','Greenworld songshan','No.149, Yucheng St., Nangang Dist., Taipei City 115','Taiwan (R.O.C.)','0227837088') ,
  153. ('00147','Green World Hotel Song Jiang','Song Jiang Road NO:485, Taipei City','Taiwan (R.O.C.)','0225098222') ,
  154. ('00148','Grand Hyatt Taipei','No.2, Songshou Rd., Xinyi Dist.','Taiwan (R.O.C.)','0227201234') ,
  155. ('00149','goodgstay','5F-1., No.28, Emei St., Wanhua Dist., Taipei City 108','Taiwan (R.O.C.)','0223140245') ,
  156. ('00150','GWO JOU HOTEL','No.208, Sec. 4, Roosevelt Rd., Wunshan District, Taipei City','Taiwan (R.O.C.)','0223672402') ,
  157. ('00151','Green World Hotel - Jianpei Suites','No.140, Sec. 1, Jianguo N. Rd., Zhongshan Dist., Taipei City 104','Taiwan (R.O.C.)','0225095151') ,
  158. ('00152','Goodlife Hotel','1-5F., No.26, Ln. 31, Shaoxing N. St., Zhongzheng Dist., Taipei City 100','Taiwan (R.O.C.)','0223217061') ,
  159. ('00153','Green World Station Hotel','No.21,1.2.6-10F and No.15, 6-10F , Sec. 1, Chongqing S. Rd., Zhongzheng Dist., Taipei City 100','Taiwan (R.O.C.)','0223819199') ,
  160. ('00154','Golden Palace Hotel','No.288, Zhifu Rd., Zhongshan Dist., Taipei City 104','Taiwan (R.O.C.)','0285026161') ,
  161. ('00155','Guandi Hotel','No.102, Wenlin Rd., Shilin Dist., Taipei City 111','Taiwan (R.O.C.)','0277226635') ,
  162. ('00156','Gloria Residence','No.357-359, Linsen N. Rd., Zhongshan Dist., Taipei City 104','Taiwan (R.O.C.)','0225310699') ,
  163. ('00157','Green Peak Hotel','No.18, Ln. 77, Sec. 2, Zhongshan N. Rd., Zhongshan Dist., Taipei City 104','Taiwan (R.O.C.)','0225112611') ,
  164. ('00158','Grand Hotel','No.1, Sec.4, Zhongshan N. Rd., Zhongzheng Dist.','Taiwan (R.O.C.)','0228868888') ,
  165. ('00159','GWO SHIUAN HOTEL','No.10, Jinzhou St., Zhongshan Dist., Taipei City 104','Taiwan (R.O.C.)','0225215205') ,
  166. ('00160','Grand View Resort','No.30, Youya Rd., Beitou Dist., Taipei City 112','Taiwan (R.O.C.)','0228988888') ,
  167. ('00161','GOSLEEP HOTEL','9F., No. 36, Ximing S. Rd., Wanhua Dist., Taipei City 10842','Taiwan (R.O.C.)','0223611321') ,
  168. ('00162','go sleeping hotel','8F,8F-1,8F-6,8F-7,8F-8,9F,9F-1,10F., No. 54, Sec.2, HanKou St., Wanhua Dist., Taipei City 108','Taiwan (R.O.C.)','0223613350') ,
  169. ('00163','GALAXY HOTEL','No.6, Ln. 147, Hanzhong St., Wanhua Dist., Taipei City 108','Taiwan (R.O.C.)','0223116606') ,
  170. ('00164','Gallery Hotel','No.59, Chongyang Rd., Nangang Dist., Taipei City 115','Taiwan (R.O.C.)','0226517770') ,
  171. ('00165','Green World Hotel Lin Sen','No.617, Linsen N. Rd., Zhongshan Dist., Taipei City 104','Taiwan (R.O.C.)','0225955225') ,
  172. ('00166','Gala Hotel','No.186, Songjiang Rd., Zhongshan Dist.','Taiwan (R.O.C.)','0225415511') ,
  173. ('00167','Gloria Hotel','No.369, Linsen N. Rd., Zhongshan Dist.','Taiwan (R.O.C.)','0225818111') ,
  174. ('00168','Golden China Hotel','No.306, Songjiang Rd., Zhongshan Dist.','Taiwan (R.O.C.)','0225215151') ,
  175. ('00169','GRAND VICTORIA HOTEL','5-10F., No.168, Jingye 4th Rd., Zhongshan Dist., Taipei City 104','Taiwan (R.O.C.)','0285020000') ,
  176. ('00170','Golden Garden Hotel','No.176, Sec. 4, Bade Rd., Songshan Dist., Taipei City 105','Taiwan (R.O.C.)','0227530772') ,
  177. ('00171','GONG LIN HOTEL','No.37, Ln. 79, Taiyuan Rd., Datong Dist., Taipei City 103','Taiwan (R.O.C.)','0225589198') ,
  178. ('00172','Good Life Hotel','No.5, Shuangcheng St., Jhongshan Dist., Taipei City 104','Taiwan (R.O.C.)','0225911190') ,
  179. ('00173','GOOD HOTEL','No.2, Ln. 624, Sec. 4, Bade Rd., Songshan Dist., Taipei City 105','Taiwan (R.O.C.)','0227609255') ,
  180. ('00174','Hotel Flowers Taipei','No.30, Huaining St., Zhongzheng Dist.','Taiwan (R.O.C.)','0223123811') ,
  181. ('00175','HOPE HOTEL','4F., No.72, Sec. 1, Zhongxiao W. Rd., Zhongzheng Dist., Taipei City 100','Taiwan (R.O.C.)','0223814755') ,
  182. ('00176','Happy Hotel','3F., No.626, Sec. 4, Bade Rd., Songshan Dist., Taipei City 105','Taiwan (R.O.C.)','0227635889') ,
  183. ('00177','HAPPINESS MOTEL','No.18, Lane 97, Songjiang Rd., Jhongshan District, Taipei City 104','Taiwan (R.O.C.)','0225177272') ,
  184. ('00178','HON CHOU HOTEL','1-7F., No.4, Hanzhong St., Wanhua Dist., Taipei City 108','Taiwan (R.O.C.)','0223319841') ,
  185. ('00179','HRYSLER HOTEL','4-6F., No.241, Sec. 3, Roosevelt Rd., Da’an Dist., Taipei City 106','Taiwan (R.O.C.)','0223626555') ,
  186. ('00180','HOPE CITY HOTEL(Daan)','No.275, Sec. 1, Fuxing S. Rd., Da-an Dist., Taipei City 106','Taiwan (R.O.C.)','0227039990') ,
  187. ('00181','HUAKUNG HOTEL','No.157, Sichang St., Wanhua District, Taipei City','Taiwan (R.O.C.)','0223142627') ,
  188. ('00182','HOTEL LEE-CHAN','7F., No.656, Sec. 4, Bade Rd., Songshan District, Taipei City 105','Taiwan (R.O.C.)','0227691135') ,
  189. ('00183','Howard Hotel','No.160, Sec.3, Ren-ai Rd., Da-an Dist.','Taiwan (R.O.C.)','0227002323') ,
  190. ('00184','Hwa Da Hotel','1-7F., No.150, Ln. 30, Yongji Rd., Xinyi Dist., Taipei City 110','Taiwan (R.O.C.)','0227635313') ,
  191. ('00185','Hotel Sense','No.477, Linsen N. Rd., Zhongshan Dist., Taipei City 104','Taiwan (R.O.C.)','0277431000') ,
  192. ('00186','HOME HOTEL','3-12F., No.90, Songren Rd., Xinyi Dist., Taipei City 110','Taiwan (R.O.C.)','0287890111') ,
  193. ('00187','Hotel Puri','No.6, Ln. 27, Chengdu Rd., Wanhua Dist., Taipei City 108','Taiwan (R.O.C.)','0223718616') ,
  194. ('00188','Hau Shuang Hotel','No.110, Zhongpo N. Rd., Nangang Dist., Taipei City 115','Taiwan (R.O.C.)','0227854117') ,
  195. ('00189','HolyPro Boutique Hotel','No.15-2, Sec. 2, Keelung Rd., Xinyi Dist., Taipei City 110','Taiwan (R.O.C.)','0223453511') ,
  196. ('00190','Hope City SungShang Hotel','1-9F., No.67, Sec. 6, Shimin Blvd., Songshan Dist., Taipei City 105','Taiwan (R.O.C.)','0227693969') ,
  197. ('00191','Hulu Hotel','No.202, Sec. 4, Chongqing N. Rd., Shilin Dist., Taipei City 111','Taiwan (R.O.C.)','0228119395') ,
  198. ('00192','HOLO Hotel','22F-2, No.50, Sec.1, Zhongxiao W. Rd., Zhongzheng Dist., Taipei City 100','Taiwan (R.O.C.)','0223317272') ,
  199. ('00193','Hsuan Mei Hotel','No.52, Sec. 1, Jianguo N. Rd., Zhongshan Dist., Taipei City 104','Taiwan (R.O.C.)','0287713066') ;
  200.  
  201.  SELECT * FROM hotel ;
  202.  
Success #stdin #stdout #stderr 0s 3448KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
Standard output is empty
stderr
copy 
Error: near line 2: near "insert": syntax error
Error: near line 201: no such table: hotel
https://ideone.com/BoTgga
language:
SQLite (sqlite 3.27.2)
created:
9 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!