Hi I am new to all of this creating tables using SQL. I usally do database stuff with access. I have created this table and included some data but how do i run it so i can view the table with its data. I am using emacs on a computer that has unix btw. Here is what i typed in. Is this correct and how do i run it.
CREATE TABLE course(
coursecode CHAR(5) NOT NULL,
title CHAR(25),
school CHAR(15),
PRIMARY KEY (coursecode));
INSERT INTO course VALUES
('AB12', 'Civil Engineering', 'Engineering');
INSERT INTO course VALUES
('CE65', 'Computer Science', 'Computing');
Cheers
Bookmarks