pCloud Partner Program

SQL Fiddle好用線上資料庫語法測試工具

程式技術/Database 2016/12/29 05:13
views: 17355 times
線上的前端有好用的 jsfiddle (https://jsfiddle.net/), CodePen (http://codepen.io/), 今天發現了一個很棒的資料庫語法測試工具, SQL Fiddle, 網址如下:

http://sqlfiddle.com/

這個好用的工具分為左右兩側, 分別是 DDL,DML 與 SQL 兩塊, 左側的 DDL, DML 可以直接定義資料表與資料內容, 當然, 還是用標準的資料庫語法. 右邊則是於 DDL, DML 執行之後, 才能使用的 SQL 語法查詢與測試用.

這樣不僅能快速定義資料表供應用外, 最重要的是可以測試 SQL 的查詢語法. 從左上角 Menu 可以看到支援的資料庫有:

MySQL 5.6
MySQL 5.5
Oracle 11g R2
PostgreSQL 9.3
SQLite (WebSQL)
SQLite (SQL.js)
MS SQL Server 2014
MS SQL Server 2008

8種不同資料庫與版本, 十分方便. 另外於 DDL/DML的部分, 也可以直接用上方 Text To DDL 進行設定, 更加方便, 讓不會使用 DDL/DML 的人員, 也能無痛建立資料表, 例如:

用戶插入圖片

table name: t_staff,
data:
name, age, title
Mary, 25, manager
Charlie, 18, Clerk
Fiona, 19, Clerk

(第一列為欄位名, 之後為資料)

就會生出以下語法:

用戶插入圖片

接下來, 就可以在右側進行查詢, 如:

select * from t_staff where age > 20

就可以查出對應的資料了, 十分方便, 尤其對於要查找資料時的不同資料庫語法間的應用, 都有很大的幫助. 另外已完成的結果, 還能快速分享, 對於查找問題, 有更多可以協同作業的可能, 上面的範例如下:

http://sqlfiddle.com/#!9/18a360/1
top

Trackback Address :: http://diary.tw/tim/trackback/1171

  1. Tracked from Tenant Improvement 2017/01/10 18:25 DELETE

    Subject: Tenant Improvement

    Find here top tenant improvements construction currently in stock and at the best price today!
  2. Tracked from clockkit 2017/01/10 18:50 DELETE

    Subject: clockkit

    See the best day light savings time currently available and reasonably priced today!
  3. Tracked from facility construction 2017/01/10 19:52 DELETE

    Subject: facility construction

    Find top quality Industrial Contractors that's in stock plus reasonably priced today!
  4. Tracked from clock movement kit 2017/01/10 20:30 DELETE

    Subject: clock movement kit

    Find here the best clock parts suppliers now available plus currently on sale today!
  5. Tracked from metal building erection 2017/01/10 20:32 DELETE

    Subject: metal building erection

    Find professional steel building contractors currently available and at the best price today!
  6. Tracked from clock mechanism kit 2017/01/10 20:39 DELETE

    Subject: clock mechanism kit

    Find here top selling DIY clock kits now now in stock plus currently on sale today!
  7. Tracked from clock parts 2017/01/10 21:08 DELETE

    Subject: clock parts

    See the greatest faux wood dials that's available and on sale today!
  8. Tracked from best flashlight 2017/01/10 21:32 DELETE

    Subject: best flashlight

    See the best torch lite now in stock and currently available today!
  9. Tracked from 200 lumen flashlight 2017/01/10 22:15 DELETE

    Subject: 200 lumen flashlight

    Find here the brightest cree flashlights that is in stock and reasonably priced today!
  10. Tracked from industrial construction services 2017/01/10 22:43 DELETE

    Subject: industrial construction services

    See professional tenant improvement contractor that's now in stock plus at the best price today!
  11. Tracked from best quality quartz clock movements 2017/01/10 22:59 DELETE

    Subject: best quality quartz clock movements

    Find here the best clock dials currently in stock plus at the best price today!
  12. Tracked from simon cree led flashlight 2017/01/11 00:31 DELETE

    Subject: simon cree led flashlight

    Find here the brightest brightest led flashlight that's in stock and at the best cost today!
  13. Tracked from battery clock movements 2017/01/11 00:58 DELETE

    Subject: battery clock movements

    Get the best mantle clock replacement motor that are in stock and currently on sale today!
  14. Tracked from battery clock movements 2017/01/11 01:09 DELETE

    Subject: battery clock movements

    Get the greatest metall wall dials now available plus at the best price today!
  15. Tracked from 200 lumens flashlight 2017/01/11 05:38 DELETE

    Subject: 200 lumens flashlight

    Find the greatest Cree flashlight that is in stock and on sale today!
  16. Tracked from brightest tactical flashlight 2017/01/11 07:34 DELETE

    Subject: brightest tactical flashlight

    Find here the best Cree LED Flashlights now available plus at great cost today!
  17. Tracked from metal building construction 2017/01/11 07:55 DELETE

    Subject: metal building construction

    Find top facility construction that's available plus reasonably priced today!
  18. Tracked from industrial construction services 2017/01/11 08:21 DELETE

    Subject: industrial construction services

    Get top building erectors that's now in stock plus reasonably priced today!
  19. Tracked from cree led t6 2017/01/11 09:05 DELETE

    Subject: cree led t6

    Find the greatest brightest led flashlight that is now in stock plus currently available today!
  20. Tracked from brightest tactical flashlight 2017/01/11 10:02 DELETE

    Subject: brightest tactical flashlight

    Find the best Cree led Flashlight that's available and on sale today!
  21. Tracked from best flashlight 2017/01/11 10:19 DELETE

    Subject: best flashlight

    Find the best brightest flashlights that is available and at the best cost today!
  22. Tracked from replacement quartz clock movements 2017/01/11 15:27 DELETE

    Subject: replacement quartz clock movements

    Find here the greatest antiques clock Repair that are now in stock and reasonably priced today!
  23. Tracked from torch lite 2017/01/11 16:57 DELETE

    Subject: torch lite

    See the top brightest led flashlight that is now in stock plus currently available today!
  24. Tracked from Cree led Flashlight 2017/01/11 18:35 DELETE

    Subject: Cree led Flashlight

    Find the greatest brightest pen flashlight currently now in stock and currently available today!
  25. Tracked from instagram marketing service 2017/01/12 04:37 DELETE

    Subject: instagram marketing service

    Get the best information on diy online marketing currently currently available and at the best cost today!
  26. Tracked from steel warehouse construction 2017/01/12 05:35 DELETE

    Subject: steel warehouse construction

    Find here the best steel building contractors that's in stock and on sale today!
  27. Tracked from metal building erection 2017/01/12 06:54 DELETE

    Subject: metal building erection

    Find here the best specialized building construction that are in stock and reasonably priced today!
  28. Tracked from online marketing diy 2017/01/12 07:01 DELETE

    Subject: online marketing diy

    Find here the best instruction on Instagram Marketing now online plus on sale today!
  29. Tracked from traffic generation strategies 2017/01/12 07:48 DELETE

    Subject: traffic generation strategies

    Find here the greatest information on lottie tomlinson instagram currently available and currently available today!
  30. Tracked from online marketing 2017/01/12 09:12 DELETE

    Subject: online marketing

    Find here the greatest instruction on instagram marketing strategy now currently available plus on sale today!
  31. Tracked from online marketing company 2017/01/12 10:16 DELETE

    Subject: online marketing company

    Get the best info on Traffic currently online plus on sale today!
  32. Tracked from twitter marketing statistics 2017/01/12 13:03 DELETE

    Subject: twitter marketing statistics

    See the greatest info on optimize for quality that is available plus at great cost today!
  33. Tracked from commercial building contractor 2017/01/12 14:48 DELETE

    Subject: commercial building contractor

    See professional steel warehouses currently available and at great prices today!
  34. Tracked from online marketing 2017/01/12 15:04 DELETE

    Subject: online marketing

    Get the top info on instagram marketing strategy now currently available plus at great cost today!
  35. Tracked from cree police flashlight 2017/01/12 15:19 DELETE

    Subject: cree police flashlight

    Find the best Cree Flashlights that's in stock and reasonably priced today!
  36. Tracked from search engine ranking factors 2017/01/12 16:00 DELETE

    Subject: search engine ranking factors

    Find the brightest information on local seo now currently available plus at the best cost today!
  37. Tracked from seo ranking factors 2016 2017/01/12 18:09 DELETE

    Subject: seo ranking factors 2016

    Get the best information on SEO that's currently available and currently available today!
  38. Tracked from Cree flashlight 2017/01/12 20:03 DELETE

    Subject: Cree flashlight

    Get the best Cree LED Flashlights that is in stock plus at great cost today!
  39. Tracked from best flashlight 2017/01/12 20:20 DELETE

    Subject: best flashlight

    Get the top best flashlight now now in stock plus at the best cost today!
  40. Tracked from brightest led flashlight 2017/01/12 21:35 DELETE

    Subject: brightest led flashlight

    Get the best tactical cree led flashlight that's now in stock and at great cost today!
  41. Tracked from flash light 2017/01/12 21:54 DELETE

    Subject: flash light

    See the top Cree LED Flashlights now now in stock and at the best cost today!
  42. Tracked from slideshare pinterest 2017/01/12 22:26 DELETE

    Subject: slideshare pinterest

    See the top instruction on traffic generation now online plus at great cost today!
  43. Tracked from increase domain authority 2017/01/13 01:15 DELETE

    Subject: increase domain authority

    Find here the best instruction on Facebook Viral Content that is currently available and on sale today!
  44. Tracked from what is online marketing 2017/01/13 02:52 DELETE

    Subject: what is online marketing

    Get the best info on Pinterest Marketing that is available and on sale today!
  45. Tracked from instagram marketing strategy 2017/01/13 04:51 DELETE

    Subject: instagram marketing strategy

    Find here the greatest instruction on Instagram Traffic currently available and free today!
  46. Tracked from how to increase domain authority 2017/01/13 06:22 DELETE

    Subject: how to increase domain authority

    Get the top instruction on iinstagram marketing currently available and at great cost today!
  47. Tracked from organic search marketing 2017/01/13 06:51 DELETE

    Subject: organic search marketing

    See the brightest instruction on Semantic SEO that's currently available plus at the best cost today!
  48. Tracked from how to increase domain authority 2017/01/13 08:24 DELETE

    Subject: how to increase domain authority

    Find the top info on SEO Ranking Factors that is available and at the best cost today!
  49. Tracked from online marketing company 2017/01/13 13:59 DELETE

    Subject: online marketing company

    Find the best information on seo ranking factors 2016 now currently available plus at great cost today!
  50. Tracked from how to raise domain authority 2017/01/13 16:01 DELETE

    Subject: how to raise domain authority

    Find the top info on instagram marketing service now online and on sale today!
  51. Tracked from lottie tomlinson instagram 2017/01/13 20:39 DELETE

    Subject: lottie tomlinson instagram

    Get the brightest instruction on Website Backlinks that is currently available plus at the best cost today!
  52. Tracked from pinpoint flashlight 2017/01/13 22:49 DELETE

    Subject: pinpoint flashlight

    Find here the brightest cree flashlights that's now in stock plus reasonably priced today!
  53. Tracked from steel warehouse construction 2017/01/14 01:12 DELETE

    Subject: steel warehouse construction

    Get top industrial construction services currently available plus on sale today!
  54. Tracked from search engine ranking factors 2017/01/14 02:32 DELETE

    Subject: search engine ranking factors

    Find here the top information on Domain Authority Stacking currently online plus at great cost today!
  55. Tracked from twitter marketing statistics 2017/01/14 05:41 DELETE

    Subject: twitter marketing statistics

    Find here the top info on domain authority stacking now online plus reasonably priced today!
  56. Tracked from cree flashlights 2017/01/14 23:48 DELETE

    Subject: cree flashlights

    Find the top brightest led flashlight now in stock and at great cost today!
  57. Tracked from flash light 2017/01/15 00:43 DELETE

    Subject: flash light

    Get the top best flash light now available and at great cost today!
  58. Tracked from Construction Management 2017/01/15 03:08 DELETE

    Subject: Construction Management

    Get professional facility construction that are now in stock plus at the best price today!
  59. Tracked from organic search marketing 2017/01/15 06:35 DELETE

    Subject: organic search marketing

    Find the greatest info on traffic generation strategies that's online and at great cost today!
  60. Tracked from 200 lumens flashlight 2017/01/15 08:17 DELETE

    Subject: 200 lumens flashlight

    See the brightest T6 flashlight now available plus at great cost today!
  61. Tracked from electric clock movements 2017/01/15 11:25 DELETE

    Subject: electric clock movements

    Get the best accessories for clocks currently now in stock plus at great prices today!
  62. Tracked from design builder 2017/01/15 12:57 DELETE

    Subject: design builder

    See professional Tenant Improvement currently in stock and at great prices today!
  63. Tracked from replacement clock parts 2017/01/15 14:51 DELETE

    Subject: replacement clock parts

    Get the greatest crystal dial face that are available and reasonably priced today!
  64. Tracked from seo ranking factors 2016 2017/01/15 23:17 DELETE

    Subject: seo ranking factors 2016

    Find here the top instruction on domain authority stacking that is currently available and reasonably priced today!
  65. Tracked from replacement parts for battery operated clocks 2017/01/16 04:28 DELETE

    Subject: replacement parts for battery operated clocks

    See the top get more info here currently now in stock and at the best price today!
  66. Tracked from traffic generation strategies 2017/01/16 10:52 DELETE

    Subject: traffic generation strategies

    Get the best instruction on Website Backlinks that is currently available and at the best cost today!
  67. Tracked from electric clock movements 2017/01/17 10:33 DELETE

    Subject: electric clock movements

    Find top selling metall wall dials now in stock and at great prices today!
  68. Tracked from how to boost domain authority 2017/01/17 11:10 DELETE

    Subject: how to boost domain authority

    Find here the greatest information on Website Backlinks currently available plus free today!
  69. Tracked from clock parts 2017/01/17 11:27 DELETE

    Subject: clock parts

    Find the top DIY clock kits that are available plus on sale today!
  70. Tracked from clock making kit 2017/01/17 15:21 DELETE

    Subject: clock making kit

    Get the top parts for clocks that's in stock and at great prices today!
  71. Tracked from clock motor wholesale 2017/01/17 19:22 DELETE

    Subject: clock motor wholesale

    See the top auto set clock parts currently in stock and reasonably priced today!
  72. Tracked from ledflashlight 2017/01/17 22:03 DELETE

    Subject: ledflashlight

    See the top Best led Flashlight currently now in stock and at great cost today!
  73. Tracked from clock parts 2017/01/18 03:18 DELETE

    Subject: clock parts

    Find here the top get more info here that's now in stock plus currently on sale today!
  74. Tracked from seo ranking factors 2016 2017/01/18 07:15 DELETE

    Subject: seo ranking factors 2016

    See the top instruction on organic search marketing now online plus reasonably priced today!
  75. Tracked from large building contractors 2017/01/20 17:00 DELETE

    Subject: large building contractors

    Find here professional metal building contractors that are now in stock and currently available today!

Write a comment


PREV : [1] : [2] : [3] : [4] : [5] : ... [458] : NEXT



Nextbit Robin 5.2吋六核心智慧型手機 Microsoft Office 365 中文家用版PKC (無光碟)
ASUS華碩 AC1900 雙頻無線路由器 RT-AC68U 美國 VORNADO 533 渦流空氣循環機 (黑色)
御茶園 每朝健康綠茶(650mlx24入) 每朝健康 雙纖綠茶(650mlx24入)


 Waiting...