CODEWITHSUNDEEP
mysqltypes
sswwss
sswwss

Reputation: 13

What type of data should I use (MySQL)?

Data type for the string - VARCHAR. data type for numbers - INT. What data type will be used for the string with numbers? E.g., "test123".

Upvotes: 1

Views: 45

Answers (2)

Mureinik
Mureinik

Reputation: 311163

A string is a string, even if some of its characters are digits. You can use a varchar.

Upvotes: 1

Peter Dongan
Peter Dongan

Reputation: 2306

Varchar. A string with numbers in it is still a string.

Upvotes: 1

Related Questions