/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 vote305 views1 answer
Sql multiple into
SQL
0 vote296 views1 answer
How to add a Try/Catch to SQL Stored Procedure
SQL
0 vote297 views1 answer
Sql delete caracter list
SQL
1 vote297 views1 answer
Postgresql append array
SQL
0 vote290 views2 answers
Nodejs mysql convert to plain object
SQL
0 vote280 views1 answer
Select even number id data from table
SQL
3 votes269 views1 answer
Oracle apex warning message
SQL
0 vote271 views1 answer
Mysql get last 2 month data
SQL
0 vote297 views1 answer
How to get nth number in sql
SQL
4 votes282 views4 answers
What is primary key
SQL

Share