CODEWITHSUNDEEP
mysql
Abhishek Mittal
Abhishek Mittal

Reputation: 366

SQL data type for variable list of integers

I am newbie to SQL.

What I have learned so far is that we have SET as data type which stores the list of values but the entries in the SET are pre-defined.

CREATE TABLE myset (col SET('a', 'b', 'c', 'd'));

In my problem, I dont know what values would come during my way.

I want a table something like:

  DeviationInfoID   Value
  1             5, 6
  2             5930, 5561

Values in the column "Value" is not pre-defined.

Please suggest some data type for Value column of my table.

Thanks in advance !!

Upvotes: 0

Views: 1399

Answers (1)

jay.jivani
jay.jivani

Reputation: 1574

you can tack text datatype for your value coloumn

Upvotes: 1

Related Questions