productlines productLine VARCHAR(50) text:Description VARCHAR(4000) htmlDescription MEDIUMTEXT image MEDIUMBLOB Indexes pments tomerN heckber CHAR(50) products productCode VARCHAR(15) productName VARCHAR(70) productLine VARCHAR(50) productScale VARCHAR(10) productVendor VARCHAR(50) product Description TEXT quantityInStock SMALLINT buyPrice DECIMAL (10,2) MSRP DECIMAL(10,2)
productlines productLine VARCHAR(50) text:Description VARCHAR(4000) htmlDescription MEDIUMTEXT image MEDIUMBLOB Indexes pments tomerN heckber CHAR(50) products productCode VARCHAR(15) productName VARCHAR(70) productLine VARCHAR(50) productScale VARCHAR(10) productVendor VARCHAR(50) product Description TEXT quantityInStock SMALLINT buyPrice DECIMAL (10,2) MSRP DECIMAL(10,2)
Related questions
Question
SQL
From the ER model below, write a SELECT statement that will display the productName, productScale, textDescription and htmlDescription columns.
Note, the yellow key symbol represents a primary key and the red diamond symbol represents a foreign key.
Transcribed Image Text:productlines
productLine VARCHAR(50)
textDescription VARCHAR(4000)
htmlDescription MEDIUMTEXT
image MEDIUMBLOB
Indexes
pments
tomer Nu
checkmber CHAR(50)
products
productCode VARCHAR(15)
productName VARCHAR(70)
productLine VARCHAR(50)
productScale VARCHAR(10)
productVendor VARCHAR(50)
product Description TEXT
quantityInStock SMALLINT
>buyPrice DECIMAL (10,2)
MSRP DECIMAL (10,2)
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps
