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. 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
Get step-by-step solutions from verified subject matter experts
