Question: For date/time fields do i have the correct syntax? DB.4. Create a table named posts. This table will contain data about posts. It will include

 For date/time fields do i have the correct syntax? DB.4. Createa table named posts. This table will contain data about posts. Itwill include information about the author, the category to which the post For date/time fields do i have the correct syntax?

belongs, any tags that the author might set for a post, count

DB.4. Create a table named posts. This table will contain data about posts. It will include information about the author, the category to which the post belongs, any tags that the author might set for a post, count of comments submitted by other users to a post, and so on. t must have the following columns a. post id i. Must be configured as the primary key. ii. Must be an INTEGER (4). iii. Must be set to auto increment. iv. Must not be null. b. post cat id i. Must be an INTEGER (4). ii. Must not be null. C. post title i. Must be VARCHAR (255) ii. Must not be null. d. post author i. Must be VARCHAR (255). ii. Must not be null. e. post date i. Must be DATE TIME ii. Must not be null. iii. This will contain the date/time for a post in the format YYYY-MM-DD HH:MM:SS

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!