/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 vote152 views1 answer
How to update date add hours in postgresql
SQL
1 vote165 views1 answer
Where not in array sql
SQL
0 vote146 views1 answer
First mysql
SQL
0 vote148 views1 answer
What is the essence of SQL?
SQL
0 vote142 views1 answer
Where case insensitive like mysql
SQL
4 votes180 views2 answers
Oracle unlock account
SQL
0 vote187 views1 answer
How to find top 3 salary in sql
SQL
0 vote147 views1 answer
What are the aggregate function in sql
SQL
0 vote149 views1 answer
Run mssql server terminal
SQL
0 vote152 views2 answers
Update Query in SQL Server Table - NAYCode.com
SQL

Share