/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 vote351 views1 answer
How to reset the database value in SQL server
SQL
5 votes325 views1 answer
Sql asynchronous stored procedure call
SQL
1 vote364 views1 answer
How to get the date diff on once field in sql server
SQL
2 votes327 views1 answer
Sql select min value from multiple columns
SQL
5 votes367 views1 answer
Sql table columns
SQL
1 vote347 views1 answer
Mysql show queries running
SQL
1 vote339 views1 answer
Python clean sql string
SQL
6 votes390 views1 answer
Oracle trigger after logon on database
SQL
0 vote322 views1 answer
Install ms sql server management studio
SQL
2 votes325 views2 answers
Join update query in sql
SQL

Share