VARCHAR row limit in MYSQL

mysql

#1

VARCHAR has a rowlimit of 65k.

Does it mean that if my list grows, I can’t store more than 65k?
Am I correct…?

I wanna store 150k urls

I am NOOB in SQL. So, pardon me…


#2

You can store 65k var-chars every row
Not that you can’t store more than 65k rows.


#3

I’m sorry what…? like I said I’m fucking noob.


#4

In a single row You can add up to 65k characters. So a url with 65,000 characters will be accepted.


#5

Gotcha…

Before Mysql version 5.0.3 Varchar datatype can store 255 character, but from 5.0.3 it can be store 65,535 characters . BUT it has a limitation of maximum row size of 65,535 bytes . It means including all columns it must not be more than 65,535 bytes


#6

Can you explain row limit and length limit…?


#7

Exactly!

And if you (Technically) just want to store the URLs in that table, those can be 65,000 Characters long.

Row Limit: Limit applied to a particular Row across all columns
Length Limit: Limit applied to a particular cell in the table.


#9

Fantastic… :ok_hand::ok_hand::ok_hand: