Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
in oracle mysql commend line client .  i want to ccreate a data like this  create database test; Create table SPORTSCARS{     -> S_id int not null,     -> S_YEAR NUMBER(4,0),     -> S_Make VARCHAR 2(20),     -> S_Model VARCHAR 2 (20),     -> S_PRICE DECIMAL (10,0),     -> Primary key (S_id) INSERT into SPORTSCARS values(1, 2015 , 'Audi' , 'R8' , 112996); INSERT into SPORTSCARS values(2, 2013 , 'Ford' , 'Mustang' , 22995); INSERT into SPORTCARS values(3, 2020 , 'Honda' , 'RDX' , 34899); INSERT into SPORTSCARS values(4, 2009 , 'Porsche' , '911' , 90800); INSERT into SPORTSCARS (I'd, Year, Make, Model, Price) values(1, 2015 , 'Audi' , 'R8' , 112996); INSERT into SPORTSCARS(I'd, Year, Make, Model, Price) values(2, 2013 , 'Ford' , 'Mustang' , 22995); INSERT into SPORTCARS(I'd, Year, Make, Model, Price) values(3, 2020 , 'Honda' , 'RDX' , 34899); INSERT into SPORTSCARS(I'd, Year, Make, Model, Price) values(4, 2009 , 'Porsche' , '911' , 90800); ------------- it shows error like this   Create table SPORTSCARS{     -> S_id int not null,     -> S_YEAR NUMBER(4,0),     -> S_Make VARCHAR 2(20),     -> S_Model VARCHAR 2 (20),     -> S_PRICE DECIMAL (10,0),     -> Primary key (S_id)     ->     -> }; ERROR 1064 (42000): 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 '{ S_id int not null, S_YEAR NUMBER(4,0), S_Make VARCHAR 2(20), S_Model VARCHAR 2' at line 1 mysql>  Create table SPORTSCARS     -> S_id int not null,     -> S_YEAR NUMBER(4,0),     -> S_Make VARCHAR 2(20),     -> S_Model VARCHAR 2 (20),     -> S_PRICE DECIMAL (10,0),     -> Primary key (S_id)     -> INSERT into SPORTSCARS values(1, 2015 , 'Audi' , 'R8' , 112996); ERROR 1064 (42000): 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 'S_id int not null, S_YEAR NUMBER(4,0), S_Make VARCHAR 2(20), S_Model VARCHAR 2 (' at line 2 mysql> mysql> INSERT into SPORTSCARS values(2, 2013 , 'Ford' , 'Mustang' , 22995); ERROR 1046 (3D000): No database selected mysql> mysql> INSERT into SPORTCARS values(3, 2020 , 'Honda' , 'RDX' , 34899); ERROR 1046 (3D000): No database selected mysql> mysql> INSERT into SPORTSCARS values(4, 2009 , 'Porsche' , '911' , 90800); ERROR 1046 (3D000): No database selected mysql> Create table SPORTSCARS     -> INSERT into SPORTSCARS values(1, 2015 , 'Audi' , 'R8' , 112996); ERROR 1064 (42000): 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 'INSERT into SPORTSCARS values(1, 2015 , 'Audi' , 'R8' , 112996)' at line 2 mysql> mysql> INSERT into SPORTSCARS values(2, 2013 , 'Ford' , 'Mustang' , 22995); ERROR 1046 (3D000): No database selected mysql> mysql> INSERT into SPORTCARS values(3, 2020 , 'Honda' , 'RDX' , 34899); ERROR 1046 (3D000): No database selected mysql> mysql> INSERT into SPORTSCARS values(4, 2009 , 'Porsche' , '911' , 90800); ERROR 1046 (3D000): No database selected mysql> mysql> mysql> mysql> create database test; ERROR 1007 (HY000): Can't create database 'test'; database exists mysql> C --------- what can i do to fix this code into correct ?

in oracle mysql commend line client .  i want to ccreate a data like this  create database test; Create table SPORTSCARS{     -> S_id int not null,     -> S_YEAR NUMBER(4,0),     -> S_Make VARCHAR 2(20),     -> S_Model VARCHAR 2 (20),     -> S_PRICE DECIMAL (10,0),     -> Primary key (S_id) INSERT into SPORTSCARS values(1, 2015 , 'Audi' , 'R8' , 112996); INSERT into SPORTSCARS values(2, 2013 , 'Ford' , 'Mustang' , 22995); INSERT into SPORTCARS values(3, 2020 , 'Honda' , 'RDX' , 34899); INSERT into SPORTSCARS values(4, 2009 , 'Porsche' , '911' , 90800); INSERT into SPORTSCARS (I'd, Year, Make, Model, Price) values(1, 2015 , 'Audi' , 'R8' , 112996); INSERT into SPORTSCARS(I'd, Year, Make, Model, Price) values(2, 2013 , 'Ford' , 'Mustang' , 22995); INSERT into SPORTCARS(I'd, Year, Make, Model, Price) values(3, 2020 , 'Honda' , 'RDX' , 34899); INSERT into SPORTSCARS(I'd, Year, Make, Model, Price) values(4, 2009 , 'Porsche' , '911' , 90800); ------------- it shows error like this   Create table SPORTSCARS{     -> S_id int not null,     -> S_YEAR NUMBER(4,0),     -> S_Make VARCHAR 2(20),     -> S_Model VARCHAR 2 (20),     -> S_PRICE DECIMAL (10,0),     -> Primary key (S_id)     ->     -> }; ERROR 1064 (42000): 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 '{ S_id int not null, S_YEAR NUMBER(4,0), S_Make VARCHAR 2(20), S_Model VARCHAR 2' at line 1 mysql>  Create table SPORTSCARS     -> S_id int not null,     -> S_YEAR NUMBER(4,0),     -> S_Make VARCHAR 2(20),     -> S_Model VARCHAR 2 (20),     -> S_PRICE DECIMAL (10,0),     -> Primary key (S_id)     -> INSERT into SPORTSCARS values(1, 2015 , 'Audi' , 'R8' , 112996); ERROR 1064 (42000): 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 'S_id int not null, S_YEAR NUMBER(4,0), S_Make VARCHAR 2(20), S_Model VARCHAR 2 (' at line 2 mysql> mysql> INSERT into SPORTSCARS values(2, 2013 , 'Ford' , 'Mustang' , 22995); ERROR 1046 (3D000): No database selected mysql> mysql> INSERT into SPORTCARS values(3, 2020 , 'Honda' , 'RDX' , 34899); ERROR 1046 (3D000): No database selected mysql> mysql> INSERT into SPORTSCARS values(4, 2009 , 'Porsche' , '911' , 90800); ERROR 1046 (3D000): No database selected mysql> Create table SPORTSCARS     -> INSERT into SPORTSCARS values(1, 2015 , 'Audi' , 'R8' , 112996); ERROR 1064 (42000): 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 'INSERT into SPORTSCARS values(1, 2015 , 'Audi' , 'R8' , 112996)' at line 2 mysql> mysql> INSERT into SPORTSCARS values(2, 2013 , 'Ford' , 'Mustang' , 22995); ERROR 1046 (3D000): No database selected mysql> mysql> INSERT into SPORTCARS values(3, 2020 , 'Honda' , 'RDX' , 34899); ERROR 1046 (3D000): No database selected mysql> mysql> INSERT into SPORTSCARS values(4, 2009 , 'Porsche' , '911' , 90800); ERROR 1046 (3D000): No database selected mysql> mysql> mysql> mysql> create database test; ERROR 1007 (HY000): Can't create database 'test'; database exists mysql> C --------- what can i do to fix this code into correct ?

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
See similar textbooks
icon
Related questions
Question

in oracle mysql commend line client . 

i want to ccreate a data like this 


create database test;
Create table SPORTSCARS{
    -> S_id int not null,
    -> S_YEAR NUMBER(4,0),
    -> S_Make VARCHAR 2(20),
    -> S_Model VARCHAR 2 (20),
    -> S_PRICE DECIMAL (10,0),
    -> Primary key (S_id)
INSERT into SPORTSCARS values(1, 2015 , 'Audi' , 'R8' , 112996);

INSERT into SPORTSCARS values(2, 2013 , 'Ford' , 'Mustang' , 22995);

INSERT into SPORTCARS values(3, 2020 , 'Honda' , 'RDX' , 34899);

INSERT into SPORTSCARS values(4, 2009 , 'Porsche' , '911' , 90800);
INSERT into SPORTSCARS (I'd, Year, Make, Model, Price) values(1, 2015 , 'Audi' , 'R8' , 112996);

INSERT into SPORTSCARS(I'd, Year, Make, Model, Price) values(2, 2013 , 'Ford' , 'Mustang' , 22995);

INSERT into SPORTCARS(I'd, Year, Make, Model, Price) values(3, 2020 , 'Honda' , 'RDX' , 34899);

INSERT into SPORTSCARS(I'd, Year, Make, Model, Price) values(4, 2009 , 'Porsche' , '911' , 90800);

-------------

it shows error like this 

 Create table SPORTSCARS{
    -> S_id int not null,
    -> S_YEAR NUMBER(4,0),
    -> S_Make VARCHAR 2(20),
    -> S_Model VARCHAR 2 (20),
    -> S_PRICE DECIMAL (10,0),
    -> Primary key (S_id)
    ->
    -> };
ERROR 1064 (42000): 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 '{
S_id int not null,
S_YEAR NUMBER(4,0),
S_Make VARCHAR 2(20),
S_Model VARCHAR 2' at line 1
mysql>  Create table SPORTSCARS
    -> S_id int not null,
    -> S_YEAR NUMBER(4,0),
    -> S_Make VARCHAR 2(20),
    -> S_Model VARCHAR 2 (20),
    -> S_PRICE DECIMAL (10,0),
    -> Primary key (S_id)
    -> INSERT into SPORTSCARS values(1, 2015 , 'Audi' , 'R8' , 112996);
ERROR 1064 (42000): 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 'S_id int not null,
S_YEAR NUMBER(4,0),
S_Make VARCHAR 2(20),
S_Model VARCHAR 2 (' at line 2
mysql>
mysql> INSERT into SPORTSCARS values(2, 2013 , 'Ford' , 'Mustang' , 22995);
ERROR 1046 (3D000): No database selected
mysql>
mysql> INSERT into SPORTCARS values(3, 2020 , 'Honda' , 'RDX' , 34899);
ERROR 1046 (3D000): No database selected
mysql>
mysql> INSERT into SPORTSCARS values(4, 2009 , 'Porsche' , '911' , 90800);
ERROR 1046 (3D000): No database selected
mysql> Create table SPORTSCARS
    -> INSERT into SPORTSCARS values(1, 2015 , 'Audi' , 'R8' , 112996);
ERROR 1064 (42000): 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 'INSERT into SPORTSCARS values(1, 2015 , 'Audi' , 'R8' , 112996)' at line 2
mysql>
mysql> INSERT into SPORTSCARS values(2, 2013 , 'Ford' , 'Mustang' , 22995);
ERROR 1046 (3D000): No database selected
mysql>
mysql> INSERT into SPORTCARS values(3, 2020 , 'Honda' , 'RDX' , 34899);
ERROR 1046 (3D000): No database selected
mysql>
mysql> INSERT into SPORTSCARS values(4, 2009 , 'Porsche' , '911' , 90800);
ERROR 1046 (3D000): No database selected
mysql>
mysql>
mysql>
mysql> create database test;
ERROR 1007 (HY000): Can't create database 'test'; database exists
mysql> C

---------

what can i do to fix this code into correct ?

_mysql> mysql> INSERT into SPORTSCARS values (2, 2013, 'Ford', 'Mustang', 22995); ERROR 1046 (3D000): No database selected mysql> mysql> INSERT into SPORTCARS values (3, 2020, 'Honda', 'RDX', 34899); ERROR 1046 (3D000): No database selected mysql> mysql INSERT into SPORTSCARS values (4, 2009, 'Porsche', '911', 90800); ERROR 1046 (3D000): No database selected mysql> Create table SPORTSCARS -> INSERT into SPORTSCARS values (1, 2015, 'Audi', 'R8', 112996); ERROR 1064 (42000): 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 INSERT into SPORTSCARS values (1, 2015, 'Audi' 'R8', 112996)' at line 2 3 mysql> mysql INSERT into SPORTSCARS values (2, 2013, 'Ford', 'Mustang', 22995); ERROR 1046 (3D000): No database selected mysql> mysql INSERT into SPORTCARS values (3, 2020, 'Honda' 'RDX', 34899); ERROR 1046 (3D000): No database selected 3 mysql> mysql> INSERT into SPORTSCARS values (4, 2009, 'Porsche', '911', 90800); ERROR 1046 (3D000): No database selected mysql> mysql> mysql> mysql create database test; ERROR 1007 (HY000): Can't create database 'test'; database exists mysql> Create table SPORTSCARS {
Transcribed Image Text:_mysql> mysql> INSERT into SPORTSCARS values (2, 2013, 'Ford', 'Mustang', 22995); ERROR 1046 (3D000): No database selected mysql> mysql> INSERT into SPORTCARS values (3, 2020, 'Honda', 'RDX', 34899); ERROR 1046 (3D000): No database selected mysql> mysql INSERT into SPORTSCARS values (4, 2009, 'Porsche', '911', 90800); ERROR 1046 (3D000): No database selected mysql> Create table SPORTSCARS -> INSERT into SPORTSCARS values (1, 2015, 'Audi', 'R8', 112996); ERROR 1064 (42000): 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 INSERT into SPORTSCARS values (1, 2015, 'Audi' 'R8', 112996)' at line 2 3 mysql> mysql INSERT into SPORTSCARS values (2, 2013, 'Ford', 'Mustang', 22995); ERROR 1046 (3D000): No database selected mysql> mysql INSERT into SPORTCARS values (3, 2020, 'Honda' 'RDX', 34899); ERROR 1046 (3D000): No database selected 3 mysql> mysql> INSERT into SPORTSCARS values (4, 2009, 'Porsche', '911', 90800); ERROR 1046 (3D000): No database selected mysql> mysql> mysql> mysql create database test; ERROR 1007 (HY000): Can't create database 'test'; database exists mysql> Create table SPORTSCARS {
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS