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
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
Step: 1
It seems like you are trying to combine Bash scripting with SQL commands which is ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started