Use app×
Join Bloom Tuition
One on One Online Tuition
JEE MAIN 2025 Foundation Course
NEET 2025 Foundation Course
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
+1 vote
6.4k views
in Computer by (79.0k points)

Write MYSQL command to create the table SHOP with given structure and constraint :

                    Table: SHOP

Column_Name Data Type(size) Constraint
Fno Int (10) Primary Key
Fname Varchar (15)
Type Char (10)
Stock Int (3)
Price Decimal (8, 2)

1 Answer

+2 votes
by (76.3k points)
selected by
 
Best answer

CREATE TABLE SHOP(Fno int(10) Primary Key, Fname Varchar(15), Type Char(10), Stock int(3), Price decimal(8,2));

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

Categories

...