Question
MySQL 9. 3. Challenge Altering tables A mysql prompt has been opened for you. Using the EPDriver database: 1- Change the name of the name
MySQL
9. 3. Challenge
Altering tables
A mysql prompt has been opened for you.
Using the EPDriver database:
1- Change the name of the name column of the drivers table to driver_name with a VARCHAR data type and a 125 character limit that cant be null
2 - Add a new driver_age column to the drivers table with a TINYINT(2) data type that must not be a negative value and cant be null
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Database And Expert Systems Applications 22nd International Conference Dexa 2011 Toulouse France August/September 2011 Proceedings Part 1 Lncs 6860
Authors: Abdelkader Hameurlain ,Stephen W. Liddle ,Klaus-Dieter Schewe ,Xiaofang Zhou
2011th Edition
3642230873, 978-3642230875
