/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 vote268 views2 answers
How to use aggregate functions in sql
SQL
0 vote264 views1 answer
Call procedure in wordpress
SQL
0 vote247 views1 answer
How to get inserted id in sql server
SQL
2 votes256 views1 answer
Create table with primary key
SQL
0 vote282 views1 answer
Object of class sendgrid\mail\mail could not be converted to string
SQL
2 votes266 views2 answers
Get all columns from table sql
SQL
0 vote275 views2 answers
Unique key
SQL
1 vote255 views1 answer
Truncate left characters mysql
SQL
0 vote272 views1 answer
Sql tablo sp
SQL
4 votes260 views2 answers
Mysql how to change default charset
SQL

Share