In [1]:

%LOAD sqlite3 db=chinook.db timeout=2 shared_cache=true

In [2]:

SELECT * FROM genres, media_types limit 10

Out[2]:

GenreId	Name	MediaTypeId	Name
1	Rock	1	MPEG audio file
2	Jazz	1	MPEG audio file
3	Metal	1	MPEG audio file
4	Alternative & Punk	1	MPEG audio file
5	Rock And Roll	1	MPEG audio file
6	Blues	1	MPEG audio file
7	Latin	1	MPEG audio file
8	Reggae	1	MPEG audio file
9	Pop	1	MPEG audio file
10	Soundtrack	1	MPEG audio file

10 rows in set (0.00 sec)

In [3]:

%XVEGA_PLOT X_FIELD GenreId Y_FIELD MediaTypeId MARK area COLOR red WIDTH 300 HEIGHT 300 <> SELECT * FROM genres, media_types

Out[3]:

In [4]:

select count(*) from genres;

Out[4]:

count(*)
25

1 row in set (0,00 sec)

In [5]:

select * from employees LIMIT 5;

Out[5]:

EmployeeId	LastName	FirstName	Title	ReportsTo	BirthDate	HireDate	Address	City	State	Country	PostalCode	Phone	Fax	Email
1	Adams	Andrew	General Manager	NULL	1962-02-18 00:00:00	2002-08-14 00:00:00	11120 Jasper Ave NW	Edmonton	AB	Canada	T5K 2N1	+1 (780) 428-9482	+1 (780) 428-3457	andrew@chinookcorp.com
2	Edwards	Nancy	Sales Manager	1	1958-12-08 00:00:00	2002-05-01 00:00:00	825 8 Ave SW	Calgary	AB	Canada	T2P 2T3	+1 (403) 262-3443	+1 (403) 262-3322	nancy@chinookcorp.com
3	Peacock	Jane	Sales Support Agent	2	1973-08-29 00:00:00	2002-04-01 00:00:00	1111 6 Ave SW	Calgary	AB	Canada	T2P 5M5	+1 (403) 262-3443	+1 (403) 262-6712	jane@chinookcorp.com
4	Park	Margaret	Sales Support Agent	2	1947-09-19 00:00:00	2003-05-03 00:00:00	683 10 Street SW	Calgary	AB	Canada	T2P 5G3	+1 (403) 263-4423	+1 (403) 263-4289	margaret@chinookcorp.com
5	Johnson	Steve	Sales Support Agent	2	1965-03-03 00:00:00	2003-10-17 00:00:00	7727B 41 Ave	Calgary	AB	Canada	T3B 1Y7	1 (780) 836-9987	1 (780) 836-9543	steve@chinookcorp.com

5 rows in set (0,00 sec)