sqlite_tutorial

SQLite version 3.34.1 2021-01-20 14:10:07
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> .help
.auth ON|OFF             Show authorizer callbacks
.backup ?DB? FILE        Backup DB (default "main") to FILE
.bail on|off             Stop after hitting an error.  Default OFF
.binary on|off           Turn binary output on or off.  Default OFF
.cd DIRECTORY            Change the working directory to DIRECTORY
.changes on|off          Show number of rows changed by SQL
.check GLOB              Fail if output since .testcase does not match
.clone NEWDB             Clone data into NEWDB from the existing database
.databases               List names and files of attached databases
.dbconfig ?op? ?val?     List or change sqlite3_db_config() options
.dbinfo ?DB?             Show status information about the database
.dump ?TABLE?            Render database content as SQL
.echo on|off             Turn command echo on or off
.eqp on|off|full|...     Enable or disable automatic EXPLAIN QUERY PLAN
.excel                   Display the output of next command in spreadsheet
.exit ?CODE?             Exit this program with return-code CODE
.expert                  EXPERIMENTAL. Suggest indexes for queries
.explain ?on|off|auto?   Change the EXPLAIN formatting mode.  Default: auto
.filectrl CMD ...        Run various sqlite3_file_control() operations
.fullschema ?--indent?   Show schema and the content of sqlite_stat tables
.headers on|off          Turn display of headers on or off
.help ?-all? ?PATTERN?   Show help text for PATTERN
.import FILE TABLE       Import data from FILE into TABLE
.imposter INDEX TABLE    Create imposter table TABLE on index INDEX
.indexes ?TABLE?         Show names of indexes
.limit ?LIMIT? ?VAL?     Display or change the value of an SQLITE_LIMIT
.lint OPTIONS            Report potential schema issues.
.log FILE|off            Turn logging on or off.  FILE can be stderr/stdout
.mode MODE ?TABLE?       Set output mode
.nullvalue STRING        Use STRING in place of NULL values
.once ?OPTIONS? ?FILE?   Output for the next SQL command only to FILE
.open ?OPTIONS? ?FILE?   Close existing database and reopen FILE
.output ?FILE?           Send output to FILE or stdout if FILE is omitted
.parameter CMD ...       Manage SQL parameter bindings
.print STRING...         Print literal STRING
.progress N              Invoke progress handler after every N opcodes
.prompt MAIN CONTINUE    Replace the standard prompts
.quit                    Exit this program
.read FILE               Read input from FILE
.restore ?DB? FILE       Restore content of DB (default "main") from FILE
.save FILE               Write in-memory database into FILE
.scanstats on|off        Turn sqlite3_stmt_scanstatus() metrics on or off
.schema ?PATTERN?        Show the CREATE statements matching PATTERN
.selftest ?OPTIONS?      Run tests defined in the SELFTEST table
.separator COL ?ROW?     Change the column and row separators
.sha3sum ...             Compute a SHA3 hash of database content
.shell CMD ARGS...       Run CMD ARGS... in a system shell
.show                    Show the current values for various settings
.stats ?on|off?          Show stats or turn stats on or off
.system CMD ARGS...      Run CMD ARGS... in a system shell
.tables ?TABLE?          List names of tables matching LIKE pattern TABLE
.testcase NAME           Begin redirecting output to 'testcase-out.txt'
.testctrl CMD ...        Run various sqlite3_test_control() operations
.timeout MS              Try opening locked tables for MS milliseconds
.timer on|off            Turn SQL timer on or off
.trace ?OPTIONS?         Output each SQL statement as it is run
.vfsinfo ?AUX?           Information about the top-level VFS
.vfslist                 List all available VFSes
.vfsname ?AUX?           Print the name of the VFS stack
.width NUM1 NUM2 ...     Set minimum column widths for columnar output
sqlite> CREATE TABLE users (
   ...> id INTEGER PRIMARY KEY AUTOINCREMENT,
   ...> name TEXT NOT NULL UNIQUE
   ...> );
sqlite> SELECT * FROM users;
sqlite> SELECT * FROM usersa;
Error: no such table: usersa
sqlite> INSERT INTO users (name) VALUES ('Andrew');
sqlite> SELECT * FROM users;
1|Andrew
sqlite> INSERT INTO users (name) VALUES ('Andrew');
Error: UNIQUE constraint failed: users.name
sqlite> INSERT INTO users (id, name) VALUES (1, 'Andrew2');
Error: UNIQUE constraint failed: users.id
sqlite> INSERT INTO users (id, name) VALUES (2, 'Andrew2');
sqlite> SELECT * FROM users;
1|Andrew
2|Andrew2
sqlite> INSERT INTO users (name) VALUES ('Andrew3');
sqlite> SELECT * FROM users;
1|Andrew
2|Andrew2
3|Andrew3
sqlite> INSERT INTO users (id, name) VALUES (5, 'Andrew5');
sqlite> SELECT * FROM users;
1|Andrew
2|Andrew2
3|Andrew3
5|Andrew5
sqlite> INSERT INTO users (name) VALUES ('Andrew6');
sqlite> SELECT * FROM users;
1|Andrew
2|Andrew2
3|Andrew3
5|Andrew5
6|Andrew6
sqlite> drop table users;
sqlite> CREATE TABLE vehicle (
   ...> vin INTEGER PRIMARY KEY AUTOINCREMENT,
   ...> price INTEGER NOT NULL,
   ...> model TEXT NOT NULL UNIQUE
   ...> );
sqlite> CREATE TABLE car (
   ...> vin INTEGER PRIMARY KEY,
   ...> engine_size REAL NOT NULL,
   ...> FOREIGN KEY (vin) REFERENCES vehicle(vin) ON UPDATE CASCADE ON DELETE CASCADE
   ...> );
sqlite> insert into vehicle (vin, price, model) values (1, 5, 'a');
sqlite> select * from vehicle;
1|5|a
sqlite> insert into car (vin, engine_size) values (1, 5.5);
sqlite> insert into car (vin, engine_size) values (2, 5.5);
sqlite> PRAGMA foreign_keys = ON;
sqlite> insert into car (vin, engine_size) values (3, 5.5);
Error: FOREIGN KEY constraint failed
sqlite> select * from car;
1|5.5
2|5.5
sqlite> delete from car where vin = 2;
sqlite> select * from car;
1|5.5
sqlite> select * from vehicle;
1|5|a
sqlite> UPDATE vehicle SET vin = 42 WHERE vin = 1;
sqlite> select * from vehicle;
42|5|a
sqlite> select * from car;
42|5.5
sqlite> delete from vehicle;
sqlite> select * from car;
sqlite> CREATE TABLE suv (
   ...> vin INTEGER PRIMARY KEY,
   ...> seat_count INTEGER NOT NULL DEFAULT 4,
   ...> FOREIGN KEY (vin) REFERENCES vehicle(vin) ON UPDATE CASCADE ON DELETE CASCADE
   ...> );
sqlite> insert into vehicle (vin, price, model) values (1, 5, 'a');
sqlite> insert into suv (vin) values (1);
sqlite> select * from suv;
1|4
sqlite> .open Northwind_small.sqlite
sqlite> select * from Customer;
ALFKI|Alfreds Futterkiste|Maria Anders|Sales Representative|Obere Str. 57|Berlin|Western Europe|12209|Germany|030-0074321|030-0076545
ANATR|Ana Trujillo Emparedados y helados|Ana Trujillo|Owner|Avda. de la Constitución 2222|México D.F.|Central America|05021|Mexico|(5) 555-4729|(5) 555-3745
ANTON|Antonio Moreno Taquería|Antonio Moreno|Owner|Mataderos  2312|México D.F.|Central America|05023|Mexico|(5) 555-3932|
AROUT|Around the Horn|Thomas Hardy|Sales Representative|120 Hanover Sq.|London|British Isles|WA1 1DP|UK|(171) 555-7788|(171) 555-6750
BERGS|Berglunds snabbköp|Christina Berglund|Order Administrator|Berguvsvägen  8|Luleå|Northern Europe|S-958 22|Sweden|0921-12 34 65|0921-12 34 67
BLAUS|Blauer See Delikatessen|Hanna Moos|Sales Representative|Forsterstr. 57|Mannheim|Western Europe|68306|Germany|0621-08460|0621-08924
BLONP|Blondesddsl père et fils|Frédérique Citeaux|Marketing Manager|24, place Kléber|Strasbourg|Western Europe|67000|France|88.60.15.31|88.60.15.32
BOLID|Bólido Comidas preparadas|Martín Sommer|Owner|C/ Araquil, 67|Madrid|Southern Europe|28023|Spain|(91) 555 22 82|(91) 555 91 99
BONAP|Bon app|Laurence Lebihan|Owner|12, rue des Bouchers|Marseille|Western Europe|13008|France|91.24.45.40|91.24.45.41
BOTTM|Bottom-Dollar Markets|Elizabeth Lincoln|Accounting Manager|23 Tsawassen Blvd.|Tsawassen|North America|T2F 8M4|Canada|(604) 555-4729|(604) 555-3745
BSBEV|B's Beverages|Victoria Ashworth|Sales Representative|Fauntleroy Circus|London|British Isles|EC2 5NT|UK|(171) 555-1212|
CACTU|Cactus Comidas para llevar|Patricio Simpson|Sales Agent|Cerrito 333|Buenos Aires|South America|1010|Argentina|(1) 135-5555|(1) 135-4892
CENTC|Centro comercial Moctezuma|Francisco Chang|Marketing Manager|Sierras de Granada 9993|México D.F.|Central America|05022|Mexico|(5) 555-3392|(5) 555-7293
CHOPS|Chop-suey Chinese|Yang Wang|Owner|Hauptstr. 29|Bern|Western Europe|3012|Switzerland|0452-076545|
COMMI|Comércio Mineiro|Pedro Afonso|Sales Associate|Av. dos Lusíadas, 23|Sao Paulo|South America|05432-043|Brazil|(11) 555-7647|
CONSH|Consolidated Holdings|Elizabeth Brown|Sales Representative|Berkeley Gardens 12  Brewery|London|British Isles|WX1 6LT|UK|(171) 555-2282|(171) 555-9199
DRACD|Drachenblut Delikatessen|Sven Ottlieb|Order Administrator|Walserweg 21|Aachen|Western Europe|52066|Germany|0241-039123|0241-059428
DUMON|Du monde entier|Janine Labrune|Owner|67, rue des Cinquante Otages|Nantes|Western Europe|44000|France|40.67.88.88|40.67.89.89
EASTC|Eastern Connection|Ann Devon|Sales Agent|35 King George|London|British Isles|WX3 6FW|UK|(171) 555-0297|(171) 555-3373
ERNSH|Ernst Handel|Roland Mendel|Sales Manager|Kirchgasse 6|Graz|Western Europe|8010|Austria|7675-3425|7675-3426
FAMIA|Familia Arquibaldo|Aria Cruz|Marketing Assistant|Rua Orós, 92|Sao Paulo|South America|05442-030|Brazil|(11) 555-9857|
FISSA|FISSA Fabrica Inter. Salchichas S.A.|Diego Roel|Accounting Manager|C/ Moralzarzal, 86|Madrid|Southern Europe|28034|Spain|(91) 555 94 44|(91) 555 55 93
FOLIG|Folies gourmandes|Martine Rancé|Assistant Sales Agent|184, chaussée de Tournai|Lille|Western Europe|59000|France|20.16.10.16|20.16.10.17
FOLKO|Folk och fä HB|Maria Larsson|Owner|Åkergatan 24|Bräcke|Northern Europe|S-844 67|Sweden|0695-34 67 21|
FRANK|Frankenversand|Peter Franken|Marketing Manager|Berliner Platz 43|München|Western Europe|80805|Germany|089-0877310|089-0877451
FRANR|France restauration|Carine Schmitt|Marketing Manager|54, rue Royale|Nantes|Western Europe|44000|France|40.32.21.21|40.32.21.20
FRANS|Franchi S.p.A.|Paolo Accorti|Sales Representative|Via Monte Bianco 34|Torino|Southern Europe|10100|Italy|011-4988260|011-4988261
FURIB|Furia Bacalhau e Frutos do Mar|Lino Rodriguez|Sales Manager|Jardim das rosas n. 32|Lisboa|Southern Europe|1675|Portugal|(1) 354-2534|(1) 354-2535
GALED|Galería del gastrónomo|Eduardo Saavedra|Marketing Manager|Rambla de Cataluña, 23|Barcelona|Southern Europe|08022|Spain|(93) 203 4560|(93) 203 4561
GODOS|Godos Cocina Típica|José Pedro Freyre|Sales Manager|C/ Romero, 33|Sevilla|Southern Europe|41101|Spain|(95) 555 82 82|
GOURL|Gourmet Lanchonetes|André Fonseca|Sales Associate|Av. Brasil, 442|Campinas|South America|04876-786|Brazil|(11) 555-9482|
GREAL|Great Lakes Food Market|Howard Snyder|Marketing Manager|2732 Baker Blvd.|Eugene|North America|97403|USA|(503) 555-7555|
GROSR|GROSELLA-Restaurante|Manuel Pereira|Owner|5ª Ave. Los Palos Grandes|Caracas|South America|1081|Venezuela|(2) 283-2951|(2) 283-3397
HANAR|Hanari Carnes|Mario Pontes|Accounting Manager|Rua do Paço, 67|Rio de Janeiro|South America|05454-876|Brazil|(21) 555-0091|(21) 555-8765
HILAA|HILARION-Abastos|Carlos Hernández|Sales Representative|Carrera 22 con Ave. Carlos Soublette #8-35|San Cristóbal|South America|5022|Venezuela|(5) 555-1340|(5) 555-1948
HUNGC|Hungry Coyote Import Store|Yoshi Latimer|Sales Representative|City Center Plaza 516 Main St.|Elgin|North America|97827|USA|(503) 555-6874|(503) 555-2376
HUNGO|Hungry Owl All-Night Grocers|Patricia McKenna|Sales Associate|8 Johnstown Road|Cork|British Isles||Ireland|2967 542|2967 3333
ISLAT|Island Trading|Helen Bennett|Marketing Manager|Garden House Crowther Way|Cowes|British Isles|PO31 7PJ|UK|(198) 555-8888|
KOENE|Königlich Essen|Philip Cramer|Sales Associate|Maubelstr. 90|Brandenburg|Western Europe|14776|Germany|0555-09876|
LACOR|La corne d'abondance|Daniel Tonini|Sales Representative|67, avenue de l'Europe|Versailles|Western Europe|78000|France|30.59.84.10|30.59.85.11
LAMAI|La maison d'Asie|Annette Roulet|Sales Manager|1 rue Alsace-Lorraine|Toulouse|Western Europe|31000|France|61.77.61.10|61.77.61.11
LAUGB|Laughing Bacchus Wine Cellars|Yoshi Tannamuri|Marketing Assistant|1900 Oak St.|Vancouver|North America|V3F 2K1|Canada|(604) 555-3392|(604) 555-7293
LAZYK|Lazy K Kountry Store|John Steel|Marketing Manager|12 Orchestra Terrace|Walla Walla|North America|99362|USA|(509) 555-7969|(509) 555-6221
LEHMS|Lehmanns Marktstand|Renate Messner|Sales Representative|Magazinweg 7|Frankfurt a.M.|Western Europe|60528|Germany|069-0245984|069-0245874
LETSS|Let's Stop N Shop|Jaime Yorres|Owner|87 Polk St. Suite 5|San Francisco|North America|94117|USA|(415) 555-5938|
LILAS|LILA-Supermercado|Carlos González|Accounting Manager|Carrera 52 con Ave. Bolívar #65-98 Llano Largo|Barquisimeto|South America|3508|Venezuela|(9) 331-6954|(9) 331-7256
LINOD|LINO-Delicateses|Felipe Izquierdo|Owner|Ave. 5 de Mayo Porlamar|I. de Margarita|South America|4980|Venezuela|(8) 34-56-12|(8) 34-93-93
LONEP|Lonesome Pine Restaurant|Fran Wilson|Sales Manager|89 Chiaroscuro Rd.|Portland|North America|97219|USA|(503) 555-9573|(503) 555-9646
MAGAA|Magazzini Alimentari Riuniti|Giovanni Rovelli|Marketing Manager|Via Ludovico il Moro 22|Bergamo|Southern Europe|24100|Italy|035-640230|035-640231
MAISD|Maison Dewey|Catherine Dewey|Sales Agent|Rue Joseph-Bens 532|Bruxelles|Western Europe|B-1180|Belgium|(02) 201 24 67|(02) 201 24 68
MEREP|Mère Paillarde|Jean Fresnière|Marketing Assistant|43 rue St. Laurent|Montréal|North America|H1J 1C3|Canada|(514) 555-8054|(514) 555-8055
MORGK|Morgenstern Gesundkost|Alexander Feuer|Marketing Assistant|Heerstr. 22|Leipzig|Western Europe|04179|Germany|0342-023176|
NORTS|North/South|Simon Crowther|Sales Associate|South House 300 Queensbridge|London|British Isles|SW7 1RZ|UK|(171) 555-7733|(171) 555-2530
OCEAN|Océano Atlántico Ltda.|Yvonne Moncada|Sales Agent|Ing. Gustavo Moncada 8585 Piso 20-A|Buenos Aires|South America|1010|Argentina|(1) 135-5333|(1) 135-5535
OLDWO|Old World Delicatessen|Rene Phillips|Sales Representative|2743 Bering St.|Anchorage|North America|99508|USA|(907) 555-7584|(907) 555-2880
OTTIK|Ottilies Käseladen|Henriette Pfalzheim|Owner|Mehrheimerstr. 369|Köln|Western Europe|50739|Germany|0221-0644327|0221-0765721
PARIS|Paris spécialités|Marie Bertrand|Owner|265, boulevard Charonne|Paris|Western Europe|75012|France|(1) 42.34.22.66|(1) 42.34.22.77
PERIC|Pericles Comidas clásicas|Guillermo Fernández|Sales Representative|Calle Dr. Jorge Cash 321|México D.F.|Central America|05033|Mexico|(5) 552-3745|(5) 545-3745
PICCO|Piccolo und mehr|Georg Pipps|Sales Manager|Geislweg 14|Salzburg|Western Europe|5020|Austria|6562-9722|6562-9723
PRINI|Princesa Isabel Vinhos|Isabel de Castro|Sales Representative|Estrada da saúde n. 58|Lisboa|Southern Europe|1756|Portugal|(1) 356-5634|
QUEDE|Que Delícia|Bernardo Batista|Accounting Manager|Rua da Panificadora, 12|Rio de Janeiro|South America|02389-673|Brazil|(21) 555-4252|(21) 555-4545
QUEEN|Queen Cozinha|Lúcia Carvalho|Marketing Assistant|Alameda dos Canàrios, 891|Sao Paulo|South America|05487-020|Brazil|(11) 555-1189|
QUICK|QUICK-Stop|Horst Kloss|Accounting Manager|Taucherstraße 10|Cunewalde|Western Europe|01307|Germany|0372-035188|
RANCH|Rancho grande|Sergio Gutiérrez|Sales Representative|Av. del Libertador 900|Buenos Aires|South America|1010|Argentina|(1) 123-5555|(1) 123-5556
RATTC|Rattlesnake Canyon Grocery|Paula Wilson|Assistant Sales Representative|2817 Milton Dr.|Albuquerque|North America|87110|USA|(505) 555-5939|(505) 555-3620
REGGC|Reggiani Caseifici|Maurizio Moroni|Sales Associate|Strada Provinciale 124|Reggio Emilia|Southern Europe|42100|Italy|0522-556721|0522-556722
RICAR|Ricardo Adocicados|Janete Limeira|Assistant Sales Agent|Av. Copacabana, 267|Rio de Janeiro|South America|02389-890|Brazil|(21) 555-3412|
RICSU|Richter Supermarkt|Michael Holz|Sales Manager|Grenzacherweg 237|Genève|Western Europe|1203|Switzerland|0897-034214|
ROMEY|Romero y tomillo|Alejandra Camino|Accounting Manager|Gran Vía, 1|Madrid|Southern Europe|28001|Spain|(91) 745 6200|(91) 745 6210
SANTG|Santé Gourmet|Jonas Bergulfsen|Owner|Erling Skakkes gate 78|Stavern|Scandinavia|4110|Norway|07-98 92 35|07-98 92 47
SAVEA|Save-a-lot Markets|Jose Pavarotti|Sales Representative|187 Suffolk Ln.|Boise|North America|83720|USA|(208) 555-8097|
SEVES|Seven Seas Imports|Hari Kumar|Sales Manager|90 Wadhurst Rd.|London|British Isles|OX15 4NB|UK|(171) 555-1717|(171) 555-5646
SIMOB|Simons bistro|Jytte Petersen|Owner|Vinbæltet 34|Kobenhavn|Northern Europe|1734|Denmark|31 12 34 56|31 13 35 57
SPECD|Spécialités du monde|Dominique Perrier|Marketing Manager|25, rue Lauriston|Paris|Western Europe|75016|France|(1) 47.55.60.10|(1) 47.55.60.20
SPLIR|Split Rail Beer & Ale|Art Braunschweiger|Sales Manager|P.O. Box 555|Lander|North America|82520|USA|(307) 555-4680|(307) 555-6525
SUPRD|Suprêmes délices|Pascale Cartrain|Accounting Manager|Boulevard Tirou, 255|Charleroi|Western Europe|B-6000|Belgium|(071) 23 67 22 20|(071) 23 67 22 21
THEBI|The Big Cheese|Liz Nixon|Marketing Manager|89 Jefferson Way Suite 2|Portland|North America|97201|USA|(503) 555-3612|
THECR|The Cracker Box|Liu Wong|Marketing Assistant|55 Grizzly Peak Rd.|Butte|North America|59801|USA|(406) 555-5834|(406) 555-8083
TOMSP|Toms Spezialitäten|Karin Josephs|Marketing Manager|Luisenstr. 48|Münster|Western Europe|44087|Germany|0251-031259|0251-035695
TORTU|Tortuga Restaurante|Miguel Angel Paolino|Owner|Avda. Azteca 123|México D.F.|Central America|05033|Mexico|(5) 555-2933|
TRADH|Tradiçao Hipermercados|Anabela Domingues|Sales Representative|Av. Inês de Castro, 414|Sao Paulo|South America|05634-030|Brazil|(11) 555-2167|(11) 555-2168
TRAIH|Trail's Head Gourmet Provisioners|Helvetius Nagy|Sales Associate|722 DaVinci Blvd.|Kirkland|North America|98034|USA|(206) 555-8257|(206) 555-2174
VAFFE|Vaffeljernet|Palle Ibsen|Sales Manager|Smagsloget 45|Århus|Northern Europe|8200|Denmark|86 21 32 43|86 22 33 44
VICTE|Victuailles en stock|Mary Saveley|Sales Agent|2, rue du Commerce|Lyon|Western Europe|69004|France|78.32.54.86|78.32.54.87
VINET|Vins et alcools Chevalier|Paul Henriot|Accounting Manager|59 rue de l'Abbaye|Reims|Western Europe|51100|France|26.47.15.10|26.47.15.11
WANDK|Die Wandernde Kuh|Rita Müller|Sales Representative|Adenauerallee 900|Stuttgart|Western Europe|70563|Germany|0711-020361|0711-035428
WARTH|Wartian Herkku|Pirkko Koskitalo|Accounting Manager|Torikatu 38|Oulu|Scandinavia|90110|Finland|981-443655|981-443655
WELLI|Wellington Importadora|Paula Parente|Sales Manager|Rua do Mercado, 12|Resende|South America|08737-363|Brazil|(14) 555-8122|
WHITC|White Clover Markets|Karl Jablonski|Owner|305 - 14th Ave. S. Suite 3B|Seattle|North America|98128|USA|(206) 555-4112|(206) 555-4115
WILMK|Wilman Kala|Matti Karttunen|Owner/Marketing Assistant|Keskuskatu 45|Helsinki|Scandinavia|21240|Finland|90-224 8858|90-224 8858
WOLZA|Wolski  Zajazd|Zbyszek Piestrzeniewicz|Owner|ul. Filtrowa 68|Warszawa|Eastern Europe|01-012|Poland|(26) 642-7012|(26) 642-7012
sqlite> SELECT Id, ContactName FROM Customer;
ALFKI|Maria Anders
ANATR|Ana Trujillo
ANTON|Antonio Moreno
AROUT|Thomas Hardy
BERGS|Christina Berglund
BLAUS|Hanna Moos
BLONP|Frédérique Citeaux
BOLID|Martín Sommer
BONAP|Laurence Lebihan
BOTTM|Elizabeth Lincoln
BSBEV|Victoria Ashworth
CACTU|Patricio Simpson
CENTC|Francisco Chang
CHOPS|Yang Wang
COMMI|Pedro Afonso
CONSH|Elizabeth Brown
DRACD|Sven Ottlieb
DUMON|Janine Labrune
EASTC|Ann Devon
ERNSH|Roland Mendel
FAMIA|Aria Cruz
FISSA|Diego Roel
FOLIG|Martine Rancé
FOLKO|Maria Larsson
FRANK|Peter Franken
FRANR|Carine Schmitt
FRANS|Paolo Accorti
FURIB|Lino Rodriguez
GALED|Eduardo Saavedra
GODOS|José Pedro Freyre
GOURL|André Fonseca
GREAL|Howard Snyder
GROSR|Manuel Pereira
HANAR|Mario Pontes
HILAA|Carlos Hernández
HUNGC|Yoshi Latimer
HUNGO|Patricia McKenna
ISLAT|Helen Bennett
KOENE|Philip Cramer
LACOR|Daniel Tonini
LAMAI|Annette Roulet
LAUGB|Yoshi Tannamuri
LAZYK|John Steel
LEHMS|Renate Messner
LETSS|Jaime Yorres
LILAS|Carlos González
LINOD|Felipe Izquierdo
LONEP|Fran Wilson
MAGAA|Giovanni Rovelli
MAISD|Catherine Dewey
MEREP|Jean Fresnière
MORGK|Alexander Feuer
NORTS|Simon Crowther
OCEAN|Yvonne Moncada
OLDWO|Rene Phillips
OTTIK|Henriette Pfalzheim
PARIS|Marie Bertrand
PERIC|Guillermo Fernández
PICCO|Georg Pipps
PRINI|Isabel de Castro
QUEDE|Bernardo Batista
QUEEN|Lúcia Carvalho
QUICK|Horst Kloss
RANCH|Sergio Gutiérrez
RATTC|Paula Wilson
REGGC|Maurizio Moroni
RICAR|Janete Limeira
RICSU|Michael Holz
ROMEY|Alejandra Camino
SANTG|Jonas Bergulfsen
SAVEA|Jose Pavarotti
SEVES|Hari Kumar
SIMOB|Jytte Petersen
SPECD|Dominique Perrier
SPLIR|Art Braunschweiger
SUPRD|Pascale Cartrain
THEBI|Liz Nixon
THECR|Liu Wong
TOMSP|Karin Josephs
TORTU|Miguel Angel Paolino
TRADH|Anabela Domingues
TRAIH|Helvetius Nagy
VAFFE|Palle Ibsen
VICTE|Mary Saveley
VINET|Paul Henriot
WANDK|Rita Müller
WARTH|Pirkko Koskitalo
WELLI|Paula Parente
WHITC|Karl Jablonski
WILMK|Matti Karttunen
WOLZA|Zbyszek Piestrzeniewicz
sqlite> SELECT Id, ContactName FROM Customer ORDER BY ContactName;
ROMEY|Alejandra Camino
MORGK|Alexander Feuer
ANATR|Ana Trujillo
TRADH|Anabela Domingues
GOURL|André Fonseca
EASTC|Ann Devon
LAMAI|Annette Roulet
ANTON|Antonio Moreno
FAMIA|Aria Cruz
SPLIR|Art Braunschweiger
QUEDE|Bernardo Batista
FRANR|Carine Schmitt
LILAS|Carlos González
HILAA|Carlos Hernández
MAISD|Catherine Dewey
BERGS|Christina Berglund
LACOR|Daniel Tonini
FISSA|Diego Roel
SPECD|Dominique Perrier
GALED|Eduardo Saavedra
CONSH|Elizabeth Brown
BOTTM|Elizabeth Lincoln
LINOD|Felipe Izquierdo
LONEP|Fran Wilson
CENTC|Francisco Chang
BLONP|Frédérique Citeaux
PICCO|Georg Pipps
MAGAA|Giovanni Rovelli
PERIC|Guillermo Fernández
BLAUS|Hanna Moos
SEVES|Hari Kumar
ISLAT|Helen Bennett
TRAIH|Helvetius Nagy
OTTIK|Henriette Pfalzheim
QUICK|Horst Kloss
GREAL|Howard Snyder
PRINI|Isabel de Castro
LETSS|Jaime Yorres
RICAR|Janete Limeira
DUMON|Janine Labrune
MEREP|Jean Fresnière
LAZYK|John Steel
SANTG|Jonas Bergulfsen
SAVEA|Jose Pavarotti
GODOS|José Pedro Freyre
SIMOB|Jytte Petersen
TOMSP|Karin Josephs
WHITC|Karl Jablonski
BONAP|Laurence Lebihan
FURIB|Lino Rodriguez
THECR|Liu Wong
THEBI|Liz Nixon
QUEEN|Lúcia Carvalho
GROSR|Manuel Pereira
ALFKI|Maria Anders
FOLKO|Maria Larsson
PARIS|Marie Bertrand
HANAR|Mario Pontes
FOLIG|Martine Rancé
BOLID|Martín Sommer
VICTE|Mary Saveley
WILMK|Matti Karttunen
REGGC|Maurizio Moroni
RICSU|Michael Holz
TORTU|Miguel Angel Paolino
VAFFE|Palle Ibsen
FRANS|Paolo Accorti
SUPRD|Pascale Cartrain
HUNGO|Patricia McKenna
CACTU|Patricio Simpson
VINET|Paul Henriot
WELLI|Paula Parente
RATTC|Paula Wilson
COMMI|Pedro Afonso
FRANK|Peter Franken
KOENE|Philip Cramer
WARTH|Pirkko Koskitalo
LEHMS|Renate Messner
OLDWO|Rene Phillips
WANDK|Rita Müller
ERNSH|Roland Mendel
RANCH|Sergio Gutiérrez
NORTS|Simon Crowther
DRACD|Sven Ottlieb
AROUT|Thomas Hardy
BSBEV|Victoria Ashworth
CHOPS|Yang Wang
HUNGC|Yoshi Latimer
LAUGB|Yoshi Tannamuri
OCEAN|Yvonne Moncada
WOLZA|Zbyszek Piestrzeniewicz
sqlite> SELECT Id, ContactName FROM Customer ORDER BY ContactName ASC;
ROMEY|Alejandra Camino
MORGK|Alexander Feuer
ANATR|Ana Trujillo
TRADH|Anabela Domingues
GOURL|André Fonseca
EASTC|Ann Devon
LAMAI|Annette Roulet
ANTON|Antonio Moreno
FAMIA|Aria Cruz
SPLIR|Art Braunschweiger
QUEDE|Bernardo Batista
FRANR|Carine Schmitt
LILAS|Carlos González
HILAA|Carlos Hernández
MAISD|Catherine Dewey
BERGS|Christina Berglund
LACOR|Daniel Tonini
FISSA|Diego Roel
SPECD|Dominique Perrier
GALED|Eduardo Saavedra
CONSH|Elizabeth Brown
BOTTM|Elizabeth Lincoln
LINOD|Felipe Izquierdo
LONEP|Fran Wilson
CENTC|Francisco Chang
BLONP|Frédérique Citeaux
PICCO|Georg Pipps
MAGAA|Giovanni Rovelli
PERIC|Guillermo Fernández
BLAUS|Hanna Moos
SEVES|Hari Kumar
ISLAT|Helen Bennett
TRAIH|Helvetius Nagy
OTTIK|Henriette Pfalzheim
QUICK|Horst Kloss
GREAL|Howard Snyder
PRINI|Isabel de Castro
LETSS|Jaime Yorres
RICAR|Janete Limeira
DUMON|Janine Labrune
MEREP|Jean Fresnière
LAZYK|John Steel
SANTG|Jonas Bergulfsen
SAVEA|Jose Pavarotti
GODOS|José Pedro Freyre
SIMOB|Jytte Petersen
TOMSP|Karin Josephs
WHITC|Karl Jablonski
BONAP|Laurence Lebihan
FURIB|Lino Rodriguez
THECR|Liu Wong
THEBI|Liz Nixon
QUEEN|Lúcia Carvalho
GROSR|Manuel Pereira
ALFKI|Maria Anders
FOLKO|Maria Larsson
PARIS|Marie Bertrand
HANAR|Mario Pontes
FOLIG|Martine Rancé
BOLID|Martín Sommer
VICTE|Mary Saveley
WILMK|Matti Karttunen
REGGC|Maurizio Moroni
RICSU|Michael Holz
TORTU|Miguel Angel Paolino
VAFFE|Palle Ibsen
FRANS|Paolo Accorti
SUPRD|Pascale Cartrain
HUNGO|Patricia McKenna
CACTU|Patricio Simpson
VINET|Paul Henriot
WELLI|Paula Parente
RATTC|Paula Wilson
COMMI|Pedro Afonso
FRANK|Peter Franken
KOENE|Philip Cramer
WARTH|Pirkko Koskitalo
LEHMS|Renate Messner
OLDWO|Rene Phillips
WANDK|Rita Müller
ERNSH|Roland Mendel
RANCH|Sergio Gutiérrez
NORTS|Simon Crowther
DRACD|Sven Ottlieb
AROUT|Thomas Hardy
BSBEV|Victoria Ashworth
CHOPS|Yang Wang
HUNGC|Yoshi Latimer
LAUGB|Yoshi Tannamuri
OCEAN|Yvonne Moncada
WOLZA|Zbyszek Piestrzeniewicz
sqlite> SELECT Id, ContactName FROM Customer ORDER BY ContactName DESC;
WOLZA|Zbyszek Piestrzeniewicz
OCEAN|Yvonne Moncada
LAUGB|Yoshi Tannamuri
HUNGC|Yoshi Latimer
CHOPS|Yang Wang
BSBEV|Victoria Ashworth
AROUT|Thomas Hardy
DRACD|Sven Ottlieb
NORTS|Simon Crowther
RANCH|Sergio Gutiérrez
ERNSH|Roland Mendel
WANDK|Rita Müller
OLDWO|Rene Phillips
LEHMS|Renate Messner
WARTH|Pirkko Koskitalo
KOENE|Philip Cramer
FRANK|Peter Franken
COMMI|Pedro Afonso
RATTC|Paula Wilson
WELLI|Paula Parente
VINET|Paul Henriot
CACTU|Patricio Simpson
HUNGO|Patricia McKenna
SUPRD|Pascale Cartrain
FRANS|Paolo Accorti
VAFFE|Palle Ibsen
TORTU|Miguel Angel Paolino
RICSU|Michael Holz
REGGC|Maurizio Moroni
WILMK|Matti Karttunen
VICTE|Mary Saveley
BOLID|Martín Sommer
FOLIG|Martine Rancé
HANAR|Mario Pontes
PARIS|Marie Bertrand
FOLKO|Maria Larsson
ALFKI|Maria Anders
GROSR|Manuel Pereira
QUEEN|Lúcia Carvalho
THEBI|Liz Nixon
THECR|Liu Wong
FURIB|Lino Rodriguez
BONAP|Laurence Lebihan
WHITC|Karl Jablonski
TOMSP|Karin Josephs
SIMOB|Jytte Petersen
GODOS|José Pedro Freyre
SAVEA|Jose Pavarotti
SANTG|Jonas Bergulfsen
LAZYK|John Steel
MEREP|Jean Fresnière
DUMON|Janine Labrune
RICAR|Janete Limeira
LETSS|Jaime Yorres
PRINI|Isabel de Castro
GREAL|Howard Snyder
QUICK|Horst Kloss
OTTIK|Henriette Pfalzheim
TRAIH|Helvetius Nagy
ISLAT|Helen Bennett
SEVES|Hari Kumar
BLAUS|Hanna Moos
PERIC|Guillermo Fernández
MAGAA|Giovanni Rovelli
PICCO|Georg Pipps
BLONP|Frédérique Citeaux
CENTC|Francisco Chang
LONEP|Fran Wilson
LINOD|Felipe Izquierdo
BOTTM|Elizabeth Lincoln
CONSH|Elizabeth Brown
GALED|Eduardo Saavedra
SPECD|Dominique Perrier
FISSA|Diego Roel
LACOR|Daniel Tonini
BERGS|Christina Berglund
MAISD|Catherine Dewey
HILAA|Carlos Hernández
LILAS|Carlos González
FRANR|Carine Schmitt
QUEDE|Bernardo Batista
SPLIR|Art Braunschweiger
FAMIA|Aria Cruz
ANTON|Antonio Moreno
LAMAI|Annette Roulet
EASTC|Ann Devon
GOURL|André Fonseca
TRADH|Anabela Domingues
ANATR|Ana Trujillo
MORGK|Alexander Feuer
ROMEY|Alejandra Camino
sqlite> SELECT Id, ContactName, City FROM Customer WHERE City = 'London' ORDER BY ContactName DESC;
BSBEV|Victoria Ashworth|London
AROUT|Thomas Hardy|London
NORTS|Simon Crowther|London
SEVES|Hari Kumar|London
CONSH|Elizabeth Brown|London
EASTC|Ann Devon|London
sqlite> SELECT Id, ContactName FROM Customer WHERE City = 'London' ORDER BY ContactName DESC;
BSBEV|Victoria Ashworth
AROUT|Thomas Hardy
NORTS|Simon Crowther
SEVES|Hari Kumar
CONSH|Elizabeth Brown
EASTC|Ann Devon
sqlite> SELECT Id, ContactName, City, ContactTitle FROM Customer WHERE City = 'London' AND ContactTitle = 'Owner' ORDER BY ContactName DESC;
sqlite> SELECT Id, ContactName, City, ContactTitle FROM Customer WHERE City = 'London' AND ContactTitle = 'Sales Representative' ORDER BY ContactName DESC;
BSBEV|Victoria Ashworth|London|Sales Representative
AROUT|Thomas Hardy|London|Sales Representative
CONSH|Elizabeth Brown|London|Sales Representative
sqlite> SELECT Id, ContactName, City, ContactTitle FROM Customer WHERE City = 'London' AND ContactTitle = 'Sales Representative' ORDER BY ContactName DESC;
BSBEV|Victoria Ashworth|London|Sales Representative
AROUT|Thomas Hardy|London|Sales Representative
CONSH|Elizabeth Brown|London|Sales Representative
sqlite> UPDATE ContactTitle = 'Owner', Address = 'Haupt Str. 66', PostalCode = 12208 WHERE Id = 'ALFKI';
Error: near "=": syntax error
sqlite> UPDATE Customer SET ContactTitle = 'Owner', Address = 'Haupt Str. 66', PostalCode = 12208 WHERE Id = 'ALFKI';
sqlite> DELETE FROM Customer WHERE Country = 'France';
sqlite> ALTER TABLE shipper RENAME TO distributor;
sqlite> ALTER TABLE distributor ADD COLUMN created_at INTEGER NOT NULL DEFAULT (strftime('%s', 'now'));
Error: Cannot add a column with non-constant default
sqlite> ALTER TABLE distributor ADD COLUMN created_at INTEGER NOT NULL DEFAULT 0;
sqlite>