Newer
Older
labs / tiddlers / content / labs / lab03 / _Labs_03_Test your connection.md

Before we start the task for today we will test that we have our set up correct.
Write a simple create table statement.

CREATE TABLE test(  
UserName varchar(10)  
);

Control Enter will run the statement or use the buttons on the left.
Right click on the gutter between the statements and controls and select line numbers, this can be helpful to find errors.
Check the Navigator window to see if it created ok. No?
Right click on the WaterSample database in the navigator and go refresh.
Can you see table test now?
Try insert some data.

INSERT INTO test (UserName) values ('Dr Dick');

Control Enter to run the insert statament.
Now we test that it worked by interrogating the database with a SELECT statement.

SELECT * FROM   test;

to check it is there.

DROP TABLE test;

Test completed, clear out the the test table and we are ready to start work.