获得属于你的 SQL 服务器

SQL 语句

结果

 customer_id |       customer_name       |    contact_name     |           address            |      city       | postal_code | country
-------------+---------------------------+---------------------+------------------------------+-----------------+-------------+---------
           1 | Alfreds Futterkiste       | Maria Anders        | Obere Str. 57                | Berlin          | 12209       | Germany
           4 | Around the Horn           | Thomas Hardy        | 120 Hanover Sq.              | London          | WA1 1DP     | UK
           6 | Blauer See Delikatessen   | Hanna Moos          | Forsterstr. 57               | Mannheim        | 68306       | Germany
           7 | Blondel pere et fils      | Frederique Citeaux  | 24, place Kleber             | Strasbourg      | 67000       | France
           9 | Bon app                   | Laurence Lebihans   | 12, rue des Bouchers         | Marseille       | 13008       | France
          11 | Bs Beverages              | Victoria Ashworth   | Fauntleroy Circus            | London          | EC2 5NT     | UK
          16 | Consolidated Holdings     | Elizabeth Brown     | Berkeley Gardens 12 Brewery  | London          | WX1 6LT     | UK
          17 | Drachenblut Delikatessend | Sven Ottlieb        | Walserweg 21                 | Aachen          | 52066       | Germany
          18 | Du monde entier           | Janine Labrune      | 67, rue des Cinquante Otages | Nantes          | 44000       | France
          19 | Eastern Connection        | Ann Devon           | 35 King George               | London          | WX3 6FW     | UK
          23 | Folies gourmandes         | Martine Rance       | 184, chaussee de Tournai     | Lille           | 59000       | France
          25 | Frankenversand            | Peter Franken       | Berliner Platz 43            | Munchen         | 80805       | Germany
          26 | France restauration       | Carine Schmitt      | 54, rue Royale               | Nantes          | 44000       | France
          38 | Island Trading            | Helen Bennett       | Garden House Crowther Way    | Cowes           | PO31 7PJ    | UK
          39 | Koniglich Essen           | Philip Cramer       | Maubelstr. 90                | Brandenburg     | 14776       | Germany
          40 | La corne d abondance      | Daniel Tonini       | 67, avenue de l Europe       | Versailles      | 78000       | France
          41 | La maison d Asie          | Annette Roulet      | 1 rue Alsace-Lorraine        | Toulouse        | 31000       | France
          44 | Lehmanns Marktstand       | Renate Messner      | Magazinweg 7                 | Frankfurt a.M.  | 60528       | Germany
          52 | Morgenstern Gesundkost    | Alexander Feuer     | Heerstr. 22                  | Leipzig         | 04179       | Germany
          53 | North/South               | Simon Crowther      | South House 300 Queensbridge | London          | SW7 1RZ     | UK
          56 | Ottilies Keseladen        | Henriette Pfalzheim | Mehrheimerstr. 369           | Koln            | 50739       | Germany
          57 | Paris specialites         | Marie Bertrand      | 265, boulevard Charonne      | Paris           | 75012       | France
          63 | QUICK-Stop                | Horst Kloss         | Taucherstrasse 10            | Cunewalde       | 01307       | Germany
          72 | Seven Seas Imports        | Hari Kumar          | 90 Wadhurst Rd.              | London          | OX15 4NB    | UK
          74 | Specialites du monde      | Dominique Perrier   | 25, rue Lauriston            | Paris           | 75016       | France
          79 | Toms Spezialiteten        | Karin Josephs       | Luisenstr. 48                | Manster         | 44087       | Germany
          84 | Victuailles en stock      | Mary Saveley        | 2, rue du Commerce           | Lyon            | 69004       | France
          85 | Vins et alcools Chevalier | Paul Henriot        | 59 rue de l Abbaye           | Reims           | 51100       | France
          86 | Die Wandernde Kuh         | Rita Moller         | Adenauerallee 900            | Stuttgart       | 70563       | Germany
(29 rows)
演示数据库

categories
customers
products
orders
order_details
testproducts