Syntax error at or near integer? how do I fix using Psequel CREATE TABLE cards (...

Question

Question

Syntax error at or near integer? how do I fix using Psequel CREATE TABLE cards (...

Syntax error at or near integer? how do I fix using Psequel

CREATE TABLE cards (
library id INTEGER,
brief description VARCHAR (200),
copy num INTEGER
)

engineering Computer-Science

Add a comment Improve this question Transcribed image text

Answer 1

Answer #1

There will be a semicolon at the end of the line. That's why Syntax error at or near integer is coming.

CREATE TABLE cards (library id INTEGER,brief description VARCHAR (200),copy num INTEGER);

Snapshot of the table created

Add a comment

Answer 2

Similar Homework Help Questions

If I have this schema, how can I solve the following problem by using MySQL? Please...

If I have this schema, how can I solve the following problem by using MySQL? Please help me, thanks a lot. create table Buildings ( integer, varchar (100), varchar (100), varchar (2), 2 id unswid 4 name 5 campus primary key (id) 6 8 9 create table Rooms ( integer, varchar (100), varchar (100), integer references Buildings (id), integer, id 1 unswid name building capacity primary key (id) 3 4 5 6 ; 17 8 create table Staff ( integer,...
I keep getting this error "You have an error in your SQL syntax; check the manual...

I keep getting this error "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4" line 4 is the "Genre char(20) not null," any help or guidance would be lovely create table Games (gameid int not null auto_increment primary key, title varchar(100) not null, Genre char(20) not null, year_released int not null); insert into Games(title, Genre,...
CREATE TABLE actor( id INTEGER NOT NULL, name VARCHAR(100), PRIMARY KEY (id) ); SELECT name FROM...

CREATE TABLE actor( id INTEGER NOT NULL, name VARCHAR(100), PRIMARY KEY (id) ); SELECT name FROM actor WHERE name LIKE 'M%'; Q. How to run explain plan on the above query and display its output?

I don't understand why I keep getting this error, How do I fix it? In file...

I don't understand why I keep getting this error, How do I fix it? In file included from Chrono. cpp: 3:0: Chrono. h:50:22: error: Chrono Date& Chrono operator++ must have an argumen t of class or enumerated type Date& operator++
How do I set a column attribute with value from another table? I have this manager_specialisation table: CREATE TABLE ma...

How do I set a column attribute with value from another table? I have this manager_specialisation table: CREATE TABLE manager_specialisation ( specialisation_id NUMBER(4) NOT NULL, specialisation_type VARCHAR(50) NOT NULL ); And I want to update a column in my garage_manager table like this except the specialisation_id is WHERE specialisation_type = 'S'.? UPDATE garage_manager SET specialisation_id=manager_specialisation.specialisation_id WHERE man_id=1 AND garage_email= (SELECT garage_code FROM garage WHERE garage_email = '[email protected]') ;
Given the schema, write a query and subquery to do the following: CREATE TABLE Majors major...

Given the schema, write a query and subquery to do the following: CREATE TABLE Majors major VARCHAR(12), description VARCHAR, PRIMARY KEY (major) ); CREATE TABLE Course ( courseMajor VARCHAR(12), courseNo VARCHAR(6), credits INTEGER NOT NULL, enroll_limit INTEGER, PRIMARY KEY(courseNo, courseMajor), FOREIGN KEY (courseMajor) REFERENCES Majors (major) CREATE TABLE Tracks trackMajor VARCHAR(12), trackCode VARCHAR(10), title VARCHAR, PRIMARY KEY(trackMajor, trackCode), FOREIGN KEY (trackMajor) REFERENCES Majors(major) CREATE TABLE Student ( SID CHAR(8), sName VARCHAR(30), studentMajor VARCHAR(12), trackCode VARCHAR(10), PRIMARY KEY(SID), FOREIGN KEY (studentMajor,...

Using the Table and data below, create a procedure that accepts product ID as a parameter...

Using the Table and data below, create a procedure that accepts product ID as a parameter and returns the name of the product from ProductTable table. Add exception handling to catch if product ID is not in the table. Please use Oracle SQL and provide screenshot. Thanks! CREATE TABLE ProductTable( ProductID INTEGER NOT NULL primary key, ProductName VARCHAR(50) NOT NULL, ListPrice NUMBER(10,2), Category INTEGER NOT NULL ); / INSERT INTO ProductTable VALUES(299,'Chest',99.99,10); INSERT INTO ProductTable VALUES(300,'Wave Cruiser',49.99,11); INSERT INTO ProductTable...
Please Explain why I am getting this error from the code below. ORA-06550: line 1, column...

Please Explain why I am getting this error from the code below. ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'P_PRODUCT_INFORMATION' I have tried changing everything. Code is below. Table to use: CREATE TABLE ProductTable( ProductID INTEGER NOT NULL primary key, ProductName VARCHAR(50) NOT NULL, ListPrice NUMBER(10,2), Category INTEGER NOT NULL ); / INSERT INTO ProductTable VALUES(299,'Chest',99.99,10); INSERT INTO ProductTable VALUES(300,'Wave Cruiser',49.99,11); INSERT INTO ProductTable VALUES(301,'Megaland Play Tent',59.99,11); INSERT...
Using the code below in Oracle SQL Live I keep getting an error message for the...

Using the code below in Oracle SQL Live I keep getting an error message for the last 4 INSERTS. The error message is: ORA-00932: inconsistent datatypes: expected DATE got NUMBER. How do I correct that error? CREATE TABLE BASE ( BASENUM CHARACTER(3) NOT NULL, BASECITY varchar(20), BASESTATE CHARACTER(2), BASEPHON varchar(10), BASEMGR varchar(10), PRIMARY KEY (BASENUM) ); CREATE TABLE TYPE ( TYPENUM CHARACTER(1) NOT NULL, TYPEDESC varchar(30), PRIMARY KEY (TYPENUM) ); CREATE TABLE TRUCK ( TNUM CHARACTER(4) NOT NULL, BASENUM CHARACTER(3),...

Using SQL and the following info Question 3: Find the people who do not have Viper...

Using SQL and the following info Question 3: Find the people who do not have Viper Certification but are still assigned to Viper class ship Find the fname, lname, and ship_instance_id for all people who do not have Viper certification but are assigned to at least one instance of a Viper class ship (this includes all variants of Viper class ships). Return a row for every ship/person combination. Order your results by fname in ascending order. Use the BSG database...

Syntax error at or near integer? how do I fix using Psequel CREATE TABLE cards (...

Homework Answers

Add Answer to:
Syntax error at or near integer? how do I fix using Psequel CREATE TABLE cards (...

Post as a guest

Earn Coins

If I have this schema, how can I solve the following problem by using MySQL? Please...

I keep getting this error "You have an error in your SQL syntax; check the manual...

CREATE TABLE actor( id INTEGER NOT NULL, name VARCHAR(100), PRIMARY KEY (id) ); SELECT name FROM...

I don't understand why I keep getting this error, How do I fix it? In file...

How do I set a column attribute with value from another table? I have this manager_specialisation table: CREATE TABLE ma...

Given the schema, write a query and subquery to do the following: CREATE TABLE Majors major...

Using the Table and data below, create a procedure that accepts product ID as a parameter...

Please Explain why I am getting this error from the code below. ORA-06550: line 1, column...

Using the code below in Oracle SQL Live I keep getting an error message for the...

Using SQL and the following info Question 3: Find the people who do not have Viper...

Syntax error at or near integer? how do I fix using Psequel CREATE TABLE cards (...

Homework Answers

Add Answer to: Syntax error at or near integer? how do I fix using Psequel CREATE TABLE cards (...

Post as a guest

Earn Coins

Add Answer to:
Syntax error at or near integer? how do I fix using Psequel CREATE TABLE cards (...