/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 vote300 views1 answer
Login phpmyadmin without password
SQL
0 vote312 views1 answer
How to combine first and last nae into one columb sql
SQL
1 vote318 views1 answer
Postgresql define pk sequence next number
SQL
0 vote304 views1 answer
User, group, or role 'open' already exists in the current database.
SQL
0 vote291 views1 answer
SQL > Manipulação de Tabelas > Constraint
SQL
0 vote319 views1 answer
ValueError: A string literal cannot contain NUL (0x00) characters.
SQL
7 votes349 views1 answer
Show line number in sql server
SQL
2 votes286 views2 answers
Mysql all columns
SQL
0 vote312 views2 answers
Collation in sql
SQL
0 vote280 views1 answer
Zsh: command not found: mysql mamp
SQL

Share