pCloud Partner Program

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

程式技術/Database 2016/12/29 12:13
views: 181408 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 Visit Now 2017/12/01 19:27 DELETE

    Subject: Visit Now

    Find the best Logs for gas fire pit that are available in addition at the best price now!
  2. Tracked from clock parts 2017/12/04 03:18 DELETE

    Subject: clock parts

    Get the greatest new bulk clock movement kits that's in stock in addition currently on sale but you must get it today!
  3. Tracked from nature 2017/12/04 12:36 DELETE

    Subject: nature

    See the best Grisaille mural that are in stock plus on sale today!
  4. Tracked from china packaging 2017/12/05 22:07 DELETE

    Subject: china packaging

    Find here top quality china direct that are in stock plus at the best price today!
  5. Tracked from Grisaille wallpaper 2017/12/07 22:51 DELETE

    Subject: Grisaille wallpaper

    Find here top quality affordable chinoiserie wallpaper that are now in stock and currently available today!
  6. Tracked from Clock kit parts 2017/12/07 23:05 DELETE

    Subject: Clock kit parts

    Find here the greatest new clock movement kit currently available plus now on sale but you must get it today!
  7. Tracked from replacement logs for gas fire pit 2017/12/08 00:58 DELETE

    Subject: replacement logs for gas fire pit

    See top Montana Firepits that's now in stock plus on sale now!
  8. Tracked from warming trends dealers 2017/12/09 06:53 DELETE

    Subject: warming trends dealers

    See top warming trends dealers that are in stock plus at great prices now!
  9. Tracked from yerba mate drink 2017/12/09 07:20 DELETE

    Subject: yerba mate drink

    Get the hottest yerba mate diet that are available plus reasonably priced. Get it today!
  10. Tracked from clock motors 2017/12/09 10:39 DELETE

    Subject: clock motors

    See the best new battery clock movements currently available plus reasonably priced but you must get it today!
  11. Tracked from china sourcing consultants 2017/12/11 05:04 DELETE

    Subject: china sourcing consultants

    Find here top quality outsourcing to China that's in stock plus at the best price today!

Write a comment


PREV : [1] : ... [12] : [13] : [14] : [15] : [16] : [17] : [18] : [19] : [20] : ... [473] : NEXT



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


 Waiting...