Modify the content of the table Below by updating customer with customerid = 103 with your name
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 "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?
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last