Question: Modify the content of the table Below by updating customer with customerid = 103 with your name and show your output. 3) Delete customer named

Modify the content of the table Below by updating customer with customerid = 103 with your name and show your output. 3) Delete customer named "Doug Nickle"; and display all records 1) Based on the data in the table below, use Bash/SQL scripts to create a table called 'customer' and 

So, here's my question when you start writing a program in the app, for example, PUTTY app which I use to write it in bash script such as for this assignment... you start with 

 vi customer.sh 

it takes us to the new page where we have to write

 #!/bin/bash 

CREATE TABLE customer (

CustomerId INTEGER,

Name TEXT,

Address TEXT,

CreditCardNumber TEXT

);

insert the first five records into the customer table

INSERT INTO customer (CustomerId, Name, Address, CreditCardNumber)

VALUES

(101, 'Dennis Cook', '123 Main Street', '2736 2371 2344 0382'),

(102, 'Doug Nickle', '456 Second Ave', '7362 7486 5957 3638'),

(103, 'Randy Wolf', '789 Elm Street', '4253 4773 6252 4436'),

(104, 'Amy Stevens', '321 Yellow Brick Road', '9876 5432 1234 5678'),

(105, 'Robert Person', '654 Lois Lane', '1122 3344 5566 7788');

"SELECT * FROM customer LIMIT 5;"

EOF

well this is my code for this assignment then I do hitting ESC shift+: and type wq, and it takes me to the main page after that I wrote 

cat customer.sh

(it shows my whole script here)

then I wrote bash customer.sh 

it shows an error in my scripts I don't know to do it so can u help me with these problems?

1) Based on the data in the table below, use Bash/SQL scripts to create a table called 'customer' and populate/load the table with at least first five records. Customerld 101 102 103 104 105 106 107 Name Dennis Cook Doug Nickle Randy Wolf Amy Stevens Robert Person David Coggin Susan Klaton Address 123 Main Street 456 Second Ave 789 Elm Street 4253 4773 6252 4436 321 Yellow Brick Road 9876 5432 1234 5678 654 Lois Lane 1122 3344 5566 7788 987 Broadway 8473 9687 4847 3784 345 Easy Street 2435 4332 1567 3232 Credit CardNumber 2736 2371 2344 0382 7362 7486 5957 3638

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

It seems like you are trying to combine Bash scripting with SQL commands which is ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!