Need code to create table ??

Question

So I'm trying to create a table called "vitamins" and insert the fields ; vitamin, size, jars in stock and cost price but don't have the proper codes for it.. Especially the cost pricing code and size and jars in stock.. Help please

Answer 1

Hi,

Here's an example.  
Provide an appropriate data type for each field.

CREATE TABLE vitamins (
         vitamin <define type here>,
         size <define type here>,
         jars <define type here>,
        price <define type here>
 );