/SQL/Mysql varchar length

Mysql varchar length

Mysql varchar length

SELECT length('abcd') FROM DUAL;		-- Oracle
SELECT length('abcd');					-- MySql
SELECT len('abcd');						-- SQL Server

2

Varchar max length

TINYTEXT              255
TEXT/VARCHAR          65,535
MEDIUMTEXT    	      16,777,215
LONGTEXT              4,294967,295

2

Change varchar length mysql

ALTER TABLE emp MODIFY COLUMN name VARCHAR(100);

0

Source: stackoverflow.com

Similar codes

0 vote282 views2 answers
What is 1=2 in sql
SQL
0 vote323 views1 answer
MySQL - Enabling the Event Scheduler
SQL
0 vote318 views1 answer
Select sql in descending order
SQL
0 vote308 views1 answer
Execute sql stored procedure in powershell
SQL
0 vote284 views1 answer
Python mysql executemany
SQL
1 vote293 views2 answers
T sql get foreign key
SQL
0 vote306 views1 answer
How to get specific salary in sql
SQL
0 vote288 views1 answer
Casterar postgres
SQL
0 vote286 views3 answers
Get count of null in column sql
SQL
-2 votes285 views2 answers
Sqlserver docker
SQL

Share