/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

1 vote132 views1 answer
Use of now() in mysql
SQL
2 votes169 views1 answer
Find column in all stored procedures sql server
SQL
16 votes140 views1 answer
Sqlserver add column to table
SQL
2 votes146 views2 answers
Sql percentage
SQL
0 vote144 views1 answer
Get all employees if name ends with in sql
SQL
0 vote133 views1 answer
Where case insensitive like mysql
SQL
2 votes151 views1 answer
Mysql time ago difference
SQL
5 votes137 views1 answer
Sql asynchronous stored procedure call
SQL
11 votes139 views1 answer
Mysql order by two columns priority
SQL
6 votes144 views2 answers
Mysql execute file
SQL

Share