Line | |
---|
1 | This SQL table example requires a connection to a SQL database.
|
---|
2 | Modify main.cpp to connect to your specific database.
|
---|
3 |
|
---|
4 | This example program expects a table called 'simpletable' to exist in
|
---|
5 | the database. You can create this table by running the following SQL
|
---|
6 | script (modify to suit your backend, if necessary):
|
---|
7 |
|
---|
8 | drop table simpletable;
|
---|
9 | create table simpletable
|
---|
10 | (id number primary key,
|
---|
11 | name varchar(20),
|
---|
12 | address varchar(20) );
|
---|
13 |
|
---|
14 | -- optional, some sample data
|
---|
15 | insert into simpletable (id, name, address)
|
---|
16 | values (1, 'Trond', 'Oslo');
|
---|
17 | insert into simpletable (id, name, address)
|
---|
18 | values (2, 'Dave', 'Oslo');
|
---|
Note:
See
TracBrowser
for help on using the repository browser.