Question: 11. 2. Challenge Defining the comments table A mysql prompt has been opened for you. Using the blog database, complete the following tasks: 1 -

11. 2. Challenge

Defining the comments table

A mysql prompt has been opened for you.

Using the blog database, complete the following tasks:

1 - Create a comments table with this definition (use either a single-line or a multi-line SQL statement):

Field ------- Type------------- ---- Null------ Key------ ------- Default -------- Extra

id --------- int(3) unsigned------ NO------- PRI ------------NULL ---------auto_increment

body------- text ------------ ------ YES------------------------ NULL

user_id----- - int(7) unsigned---- NO ------ MUL----------- NULL

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

5. 2. Challenge Defining the reference table A mysql prompt has been opened for you. Using the college database, complete the following tasks (use either a single-line or a multi-line SQL statement):...

Q:

MySQL 11. 3. Challenge Altering the comments table A mysql prompt has been opened for you. Using the blog database (use either a single-line or a multi-line SQL statement): 1 - Write a SQL ALTER...

Q:

MySQL 11. Final challenges Reset challenge database If you make a mistake while editing the database in this section or just want to reset the database back to its original state, return to this page...

Q:

MySQL FINAL CHALLENGE User settings are another example of data that needs to be updated. Users often decide to change their username, password, email accounts, email notification frequency and so...

Q:

MySQL Codio 11. Final challenges User settings are another example of data that needs to be updated. Users often decide to change their username, password, email accounts, email notification...

Q:

As you have experienced, relationships between different database tables are a very common way of organizing data in a relational database system. In this last set of challenges, youll be working...

Q:

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

Q:

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

Q:

PLEASE READ CAREFULLY THE CASE STUDY PROVIDED AND FEEL FREE TO ADD HERE YOUR COMMENTS FOR EXAMPLE LIKES DISLIKES WORDS OR PHRASES YOU DO NOT UNDERSTAND ANY COMMENTS THAT WILL IMPROVE THE DIALOGUE...

Q:

haa23684_PlugInT6CD.qxd 9/6/06 5:38 PM Page 2 CONFIRMING PAGES P L U G - I N T6 Basic Skills and Tools Using Access LEARNING OUTCOMES 1. Describe the primary functions using Microsoft Access. 2....

Q:

Assume the same information as in QS 12-14 except that the Equipment was sold for $85,000 on April 1, 2014. Prepare the journal entry to record the final distribution ofcash. Accum. Deprec. Sam,...

Q:

Suppose you are using a completely randomized design to study some phenomenon. There are three treatment levels and a total of 17 people in the study. Complete the following ANOVA table. Use...

Q:

The term deviance can be defined as the regulation and enforcement of norms. a violation of established sockal norms, whether follways, mores, or codificd law. social reward for the violation of...

Q:

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Q:

14-1 What are the objectives of project management, and why is it so essential in developing information systems?

Q:

2. Use the web to do more research on project management methodologies and tools. Explore the Project Management Institute (PMI) website or review the Project Management Institutes book, A Guide to...

Q:

3. Try to find information on how projects are managed at XYZ Multimedia. Inquire what project management methodologies and tools are used at this company. If possible, show you are familiar with...