Question: CREATE TABLE Vehicle ( VehicleID CHAR ( 8 ) PRIMARY KEY, TypeCode CHAR ( 3 ) NOT NULL, YearNumber INT UNSIGNED NOT NULL, MakeCode CHAR
CREATE TABLE Vehicle
VehicleID CHAR PRIMARY KEY,
TypeCode CHAR NOT NULL,
YearNumber INT UNSIGNED NOT NULL,
MakeCode CHAR NOT NULL,
ModelName VARCHAR NOT NULL,
PlateID CHAR NOT NULL,
StateCode CHAR NOT NULL,
RegistrationDate DATE NOT NULL,
UNIQUE PlateID StateCode
;
SHOW TABLES; and i have given code and there are some mistakes in it that Traceback most recent call last:
File usercodezylabunittestrunner.py line in
passed testcase.testpassedwriter
File usercodecodingroomsunittests.py line in testpassed
cursor.executeshow columns from VehicleEvent;"
File nixstorezyjggwarzjdyjmhkhdqvppythonmysqlconnectorlibpythonsitepackagesmysqlconnectorcursorpy line in execute
self.handleresultselfconnection.cmdquerystmt
File nixstorezyjggwarzjdyjmhkhdqvppythonmysqlconnectorlibpythonsitepackagesmysqlconnectorconnectionpy line in cmdquery
result self.handleresultselfsendcmdServerCmdQUERY, query
File nixstorezyjggwarzjdyjmhkhdqvppythonmysqlconnectorlibpythonsitepackagesmysqlconnectorconnectionpy line in handleresult
raise errors.getexceptionpacket
mysqlconnector.errors.ProgrammingError: S: Table 'zybooksdb.vehicleevent' doesn't exist
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
