获取您自己的 SQL 服务器

SQL 语句

结果

 customer_id |            customer_name             |    contact_name    |                    address                     |      city      | postal_code |  country
-------------+--------------------------------------+--------------------+------------------------------------------------+----------------+-------------+-----------
           1 | Alfreds Futterkiste                  | Maria Anders       | Obere Str. 57                                  | Berlin         | 12209       | Germany
           2 | Ana Trujillo Emparedados y helados   | Ana Trujillo       | Avda. de la Constitucion 2222                  | Mexico D.F.    | 05021       | Mexico
           3 | Antonio Moreno Taquera               | Antonio Moreno     | Mataderos 2312                                 | Mexico D.F.    | 05023       | Mexico
           4 | Around the Horn                      | Thomas Hardy       | 120 Hanover Sq.                                | London         | WA1 1DP     | UK
          21 | Familia Arquibaldo                   | Aria Cruz          | Rua Oros, 92                                   | Sao Paulo      | 05442-030   | Brazil
          22 | FISSA Fabrica Inter. Salchichas S.A. | Diego Roel         | C/ Moralzarzal, 86                             | Madrid         | 28034       | Spain
          27 | Franchi S.p.A.                       | Paolo Accorti      | Via Monte Bianco 34                            | Torino         | 10100       | Italy
          33 | GROSELLA-Restaurante                 | Manuel Pereira     | 5th Ave. Los Palos Grandes                     | Caracas        | 1081        | Venezuela
          35 | HILARION-Abastos                     | Carlos Hernandez   | Carrera 22 con Ave. Carlos Soublette #8-35     | San Cristobal  | 5022        | Venezuela
          37 | Hungry Owl All-Night Grocers         | Patricia McKenna   | 8 Johnstown Road                               | Cork           |             | Ireland
          41 | La maison d Asie                     | Annette Roulet     | 1 rue Alsace-Lorraine                          | Toulouse       | 31000       | France
          46 | LILA-Supermercado                    | Carlos Gonzalez    | Carrera 52 con Ave. Bolivar #65-98 Llano Largo | Barquisimeto   | 3508        | Venezuela
          49 | Magazzini Alimentari Riuniti         | Giovanni Rovelli   | Via Ludovico il Moro 22                        | Bergamo        | 24100       | Italy
(16 rows)
演示数据库

categories
customers
products
orders
order_details
testproducts