Beginner SQL Scripting...

[meccaboy858]

I trying to figure out how to create a SQL script to make my data insertion a bit easier, but something is going wrong. First I'm trying to just get a basic create table script to work but I keep getting an that I wouldn't get if I typed it in manually.


CREATE TABLE users
(
user_id int unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY,
created datetime,
contact_id int unsigned NOT NULL,
username varchar(20) NOT NULL,
password varchar(20) NOT NULL,
index idx_contact_id (contact_id)
);

I would think this would work since it just cut and paste from a site. But I keep getting a syntax error @ line 11. But when i look at the code, its looks fine. I'm just naming it user.sql. And when I get into sqlplus i just type in "! user.sql;". It runs but it finds the error, what am i doing wrong?

 

[Haircut]

You mention that you are using SQL*Plus, so I'm assuming the database is Oracle.

The code that you have there will not work for Oracle, the site you downloaded it from was probably giving the SQL for a different db.
In Oracle you would need something like this:

CREATE TABLE users
(user_id NUMBER NOT NULL,
created DATE,
contact_id NUMBER NOT NULL,
username VARCHAR2(20) NOT NULL,
PASSWORD VARCHAR2(20) NOT NULL,
CONSTRAINT user_pk PRIMARY KEY (user_id)
);

CREATE INDEX user_i01 ON users(contact_id);

CREATE SEQUENCE users_s START WITH 1;