Question: 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

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 TABLE statement that adds a post_idcolumn to the blog.comments table. This new column should be an INTEGER data type with a max. size of 3 digits, UNSIGNED, it should be NOT NULL and it should work as a FOREIGN KEY that uses as a reference the id column of the blog.posts table.

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!

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...

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):...

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...

11. 1. Challenge A simple blog database A sql-5-7.sql file has been opened for you. In the sql-5-7.sql file: 1. Use the blog database 2. Write a SQL RIGHT OUTER JOIN statement that joins the user_id...

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...

need the sql solution the question relates to the data model shown below in the picture. the sql code needs to be written in regards to the example data model given below ecerything there nothing...

Please help me ASAP. I need the code from part 3 I. OBJECTIVES Take a look at the process of creating and managing database backups and how these backups are used in recovery of the database when it...

5. 3. Challenge A mysql prompt has been opened for you. Using the collegedatabase, complete the following tasks (use either a single-line or a multi-line SQL statement): Create a classroomstable with...

I am working on my final project in an SQL class using MYSQL. I am working my way through it but it is going slow so I think that I may need a little bit of help to finish in time. If I could get a...

Please help me explain #1 - 4 of the word document part. Thank you Goal of this assignment: Practice simple SQL statements by creating, loading, exporting and importing the EMPLOYEE table in the...

Waves of Arbitrary Shape. (a) Explain why any wave described by a function of the form y(x, t) = fix - ut) moves in the +x-direction with speed u. (b) Show that y(x, t) = f(x - ut) satisfies the wave...

2. As a director, write a MEMO to the heads of your relevant departments with a clear Headline, Introduction, Context with Discussion and Closing Segments. Remember memos offer both an identification...

In what instance will a parent company begin to consplidate its financial statements with the financial statements of its subsidiary?

CT Corp Comprehensive Question Canadian Tire Corporation, Limited (Canadian Tire) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

(Appendices) PREPARATION OF MERCHANDISING FINANCIAL STATEMENTS. Jay Coat Company has prepared the following unadjusted trial balance as of December Ble Ox2: LO9 The following data are also available:...

(Appendices) UNCOLLECTIBLE ACCOUNT EXPENSE: CREDIT SALES METHOD. The Glass House, a glass and china store, sells nearly half its merchandise on credit. During the past 4 years, the following data...

(Appendices) PURCHASES AND PURCHASES RETURNS. On November 6, Lubin Products purchased on credit 350 parts kits from Michaels Electronics for $38 per kit. Michaels paid $320 to have the kits shipped...