Nith regard to the taes CUSTONER the fallowing queries Change the ny Date o 10-M

Question

Nith regard to the taes CUSTONER the fallowing queries Change the ny Date o 10-MOr-05 INE ond PRODUCT write ou for invoi e line price in of croductS to 99 2) chinge the vendor ine numbrr of product is 3 the cuistomer last mame to Sui r ciStomers th irNgice number i C ghange product pnce by nat are ber 3 endor codde is 232 splay aul tables Table name CUSTOMER Primary Foreign k DL 0011 Dunn 10018 Farriss Primary key INV NUMBER Foreign key: CUS CODE Table same UNE Primarykey: INV(NUMBERINE NUMBER i Foreign keyes INVENUMBER PROD CODE 10014 08-a 10011 08r-08 10012 0-Mr-0 100111 09Mr 18. 03459 001278-42 Table name: PRODUCT Foreign key none 001278-AB Clew hanmer QFR-34256 Sledpe hammer,18-b.heod z Primary key: PROD CODE

Explanation / Answer

Note- In this answer please change CUST_LNAME as it is in customer table, in given screen shot its not visible so i assumed it as CUST_LNAME .

Answer 6.

SHOW TABLES;

This query will dislplay all table name only.

if you want to display all data of a tablen then use below query

SELECT * FROM <Table Name>

Replace <Table Name> with your table name

for example-

SELECT * FROM PRODUCT

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.